Qlik Community

Ask a Question

Connectivity & Data Prep

Discussion board where members can learn more about Qlik Sense Data Connectivity.

Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
shah_sapana
Contributor
Contributor

QMC Task Failing - Statement Timing out

QMC has a Task for one of the QVD being used in our Qlik Dashboard. It's schedule on task and usually gets completed successfully. But since today morning it's failing on scheduled time as well as on manual run.

Below is the error message in log. I am not sure where do we configure maximum statement execution time in Qlik. Our data source database do not have any such limitations. 

2019-07-18 18:26:14 Error: Connector reply error: SQL##f - SqlState: S1000, ErrorCode: 3024, ErrorMsg: [MySQL][ODBC 5.3(w) Driver][mysqld-5.7.21-log]Query execution was interrupted, maximum statement execution time exceeded
2019-07-18 18:26:14 Execution Failed
2019-07-18 18:26:14 Execution finished.

Please Suggest.

2 Replies
NadiaB
Support
Support

Hi @shah_sapana 

You might need to contact the developer or your DBA.

https://dba.stackexchange.com/questions/134923/query-execution-was-interrupted-max-statement-time-ex...

Kind regards.

Note: if this suggestion helps to resolve the issue or answers your question, it will be appreciated if you select the "Accept as Solution" option.
We encourage you to visit our Knowledge Base https://qliksupport.force.com/QS_CoveoSearch when trying to find a solution related and not limited to: errors, feature requests, product defects. You can also visit our Qlik Help portal https://help.qlik.com/
shah_sapana
Contributor
Contributor
Author

Hi Nadia, Really appreciate your input but i did talk to our dba and he confirmed there is no max query execution time configured in our database which can interrupt query execution.

Is there anything like max execution time in Qlik QMC?

Please suggest. Thanks !