topic Re: QMC Task Failing - Statement Timing out in Connectivity & Data Prep

QMC Task Failing - Statement Timing out

shah_sapana — Thu, 18 Jul 2019 18:48:54 GMT

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.

Re: QMC Task Failing - Statement Timing out

NadiaB — Sat, 20 Jul 2019 15:41:54 GMT

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-exceeded

Kind regards.

Re: QMC Task Failing - Statement Timing out

shah_sapana — Mon, 22 Jul 2019 13:34:54 GMT

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 !