Qlik Community

Qlik Sense Data Connectivity

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

Announcements
See why Qlik is recognized as a Leader for the 10th year in a row – and discover how Qlik can help put your business in the lead. Get Report
Highlighted
shah_sapana
New 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
Highlighted
Support
Support

Re: QMC Task Failing - Statement Timing out

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/
Highlighted
shah_sapana
New Contributor

Re: QMC Task Failing - Statement Timing out

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 !