Statement Cancelled Due to Client Request Error

Dwayne Cooper shared this problem 2 years ago
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

Comments (3)

photo
1

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

photo
1

This appeared to be a timeout issue. I trimmed down the query and it ran fine.

photo
1

Hi Dwayne,


Glad to hear you got it working.


Regards,

Nathan