Append sub-queries to SQL views timing out

Brendan Codrington shared this problem 8 months ago
Defect Fixed

Hi, we deployed build 20191202 in early February and have since identified an issue with reports that use SQL views (most of our views are drag and drop). The reports timeout on running and if I edit the report and make any changes it kicks me out of the session.

We are yet to apply the 20191217 build, and note it addresses issues with editing SQL views, so is the behaviour I'm experiencing related or known, or something separate? Will the 20191217 patch resolve this?

For info, if I am able to get the code for that view (from within the report code, not the SQL view as this also times out), I can then recreate the SQL view as a virtual table which then runs and behaves as expected. This is the current workaround but then requires editing each report affected and redoing all config related to the SQL view.

I've also noticed that reports using an SQL view also have an old issue where row limits seem to be applied to each append sub-query, whereas this has been resolved for drag and drop views.

(Appreciate this may be hard to replicate etc and it will be difficult to extract logs related to this. Just curious to know if it has been identified/resolved or not.)

Brendan

Comments (3)

photo
1

Hi Brendan,


You are correct, the most recent re-publish of Yellowfin 7.4.12 addressed a defect with the editing of Views, which sounds like the root cause of the problems that you are describing. It was only a very minor bugfix so I strongly encourage you to perform this upgrade as it should resolve this issue, without change to your existing experience. If the issue persists after the upgrade, I would be more than happy to look into it further with you via a screen share so that I can get a better understanding of how I can replicate the behaviour if it turns out to be a separate issue!


The second behaviour you've observed could be a defect. Would you mind letting me know what Data Source you are connecting to when you observe this? Again this is an issue that might've been addressed in the minor re-publish as it seems to stem from the same root cause, which is that there were some aspects of Views that were broken in that release.


Kind regards,

Simon

photo
1

Hi Simon, thanks for confirming. With the row limit issue, both drag and drop and SQL views were connected to a Generic JDBC data source. I'll include that in our internal notes of issues to retest once we apply the latest patch, as well as checking that these SQL views work again and can be edited. I'll sing out if I have any more issues post this.

Kind regards,

Brendan

photo
1

Hi Brendan,


Thanks for passing that information through, it will be very useful to know later down the track if the issue persists.


I will go ahead and mark this ticket as completed for the time being. If you continue to face issues following the upgrade, please respond here in order to re-open the ticket and I will get back to you shortly.


Have a wonderful weekend!


Kind regards,

Simon