QMC Task Failing - Statement Timing out

[shah_sapana]

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.

[NadiaB]

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.

[shah_sapana]

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 !