https://community.qlik.com/t5/Connectivity-Data-Prep/Error-message-during-load-phase/m-p/1824462#M9360 <P>Hi all,</P><P>&nbsp;</P><P>Does anybody have any insight as to what is causing this error message and how to resolve?</P><P>Connecting to a MYSQL database, c12,000,000 rows of data, the load time before failure is between 4 &amp; 6 minutes, it usually fails at around row 1,000,000.</P><P>Thanks in advance!</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="GaryMcDonald_0-1627295866315.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/59135iA64A432B7F1402B1/image-size/medium?v=v2&amp;px=400" role="button" title="GaryMcDonald_0-1627295866315.png" alt="GaryMcDonald_0-1627295866315.png" /></span></P><P>&nbsp;</P><P>&nbsp;</P> Mon, 26 Jul 2021 10:42:07 GMT GaryMcDonald 2021-07-26T10:42:07Z https://community.qlik.com/t5/Connectivity-Data-Prep/Error-message-during-load-phase/m-p/1824462#M9360 <P>Hi all,</P><P>&nbsp;</P><P>Does anybody have any insight as to what is causing this error message and how to resolve?</P><P>Connecting to a MYSQL database, c12,000,000 rows of data, the load time before failure is between 4 &amp; 6 minutes, it usually fails at around row 1,000,000.</P><P>Thanks in advance!</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="GaryMcDonald_0-1627295866315.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/59135iA64A432B7F1402B1/image-size/medium?v=v2&amp;px=400" role="button" title="GaryMcDonald_0-1627295866315.png" alt="GaryMcDonald_0-1627295866315.png" /></span></P><P>&nbsp;</P><P>&nbsp;</P> Mon, 26 Jul 2021 10:42:07 GMT https://community.qlik.com/t5/Connectivity-Data-Prep/Error-message-during-load-phase/m-p/1824462#M9360 GaryMcDonald 2021-07-26T10:42:07Z https://community.qlik.com/t5/Connectivity-Data-Prep/Error-message-during-load-phase/m-p/1847654#M9688 <P>Hi GaryMCDonald</P> <P>&nbsp;</P> <P>It's a timeout problem, are you using our connector or a third party one?</P> <P>Have you contacted your DB administrator already?&nbsp;</P> <P>You probably can configure something in the connection string but you probably need to double check with your DB you are able to do so.</P> <P>&nbsp;</P> <P><A href="https://dba.stackexchange.com/questions/134923/query-execution-was-interrupted-max-statement-time-exceeded" target="_blank">https://dba.stackexchange.com/questions/134923/query-execution-was-interrupted-max-statement-time-exceeded</A></P> <P>&nbsp;</P> <P>Kind Regards.</P> Sat, 16 Oct 2021 00:21:09 GMT https://community.qlik.com/t5/Connectivity-Data-Prep/Error-message-during-load-phase/m-p/1847654#M9688 NadiaB 2021-10-16T00:21:09Z