Category
Report Builder
Product Version
7.2
Statement Cancelled Due to Client Request Error
Resolved
I have a report that was working fine through yesterday and now I get a generic exception in yellowfin that says:
Error retrieving resultsAn error occurred retrieving the results from the database. Please check the SQL syntax and try again.
I thought it might be a timeout but it does it after 2 or 3 minutes and the report has always been taking that long. I had my DBA run the resulting query against the DB and it returns fine.
Here's what I see in the log:
YF:2017-07-20 17:15:30:ERROR (DBAction:doSelect) - Error occured selecting data: com.mysql.jdbc.exceptions.MySQLStatementCancelledException: Statement cancelled due to client request
The same problem 
Hi Dwayne,
Is this the only error that occurred in the logs at that time? Are you still receiving this error? Could you send me the entire logs folder?
One thing that may be worth looking into, is to enable volatile data sources, to ensure your connection is active when you need it:
https://community.yellowfinbi.com/knowledge-base/article/volatile-data-sources-what-is-it-and-when-do-i-need-it
Regards,
Nathan
Hi Dwayne,
Is this the only error that occurred in the logs at that time? Are you still receiving this error? Could you send me the entire logs folder?
One thing that may be worth looking into, is to enable volatile data sources, to ensure your connection is active when you need it:
https://community.yellowfinbi.com/knowledge-base/article/volatile-data-sources-what-is-it-and-when-do-i-need-it
Regards,
Nathan
This appeared to be a timeout issue. I trimmed down the query and it ran fine.
This appeared to be a timeout issue. I trimmed down the query and it ran fine.
Hi Dwayne,
Glad to hear you got it working.
Regards,
Nathan
Hi Dwayne,
Glad to hear you got it working.
Regards,
Nathan
Replies have been locked on this page!