topic Re: Qlik Data Gateway - Error EDC_ERROR:22013 in Data Movement & Streaming

Qlik Data Gateway - Error EDC_ERROR:22013

V_Ortis — Wed, 19 Mar 2025 21:46:28 GMT

Hello everyone, I’m facing the following issue with my data loads using the Qlik Data Gateway.

Coincidentally, I updated to version 1.6.9, and table loads that used to take 24 minutes are now reaching a limit of 3 hours and being automatically canceled. Does anyone know if this could be related to the version update, or is it another issue?

Re: Qlik Data Gateway - Error EDC_ERROR:22013

fmarvnnt — Fri, 29 Nov 2024 13:18:33 GMT

Hi,

I guess it is not a gateway issue but simply you've reached the limit of 3 hours reload:

Re: Qlik Data Gateway - Error EDC_ERROR:22013

V_Ortis — Fri, 29 Nov 2024 14:09:16 GMT

Hello @fmarvnnt , so this load used to take around 20 to 30 minutes, but now it’s taking 3 hours. The data volume is still very similar from one load to the next, approximately 5 million rows. I’d like to understand what could have caused this increase in time, because there haven’t been any changes to the SQL query

Re: Qlik Data Gateway - Error EDC_ERROR:22013

fmarvnnt — Fri, 29 Nov 2024 14:51:51 GMT

Could be something external to Qlik Data Gateway. Have you tried to run the query from a client tool onto Qlik Data Gateway Remote Desktop (or QlikView Desktop)..?

Fma

Re: Qlik Data Gateway - Error EDC_ERROR:22013

V_Ortis — Mon, 02 Dec 2024 11:25:57 GMT

Olá, não consegui testar essa consulta em outra ferramenta, porém consigo testar no Qlikview Desktop

Re: Qlik Data Gateway - Error EDC_ERROR:22013

V_Ortis — Mon, 02 Dec 2024 11:45:15 GMT

I carried out the test on Qlikview desktop, and the same query takes no more than 15 minutes, while on Qlik Cloud I have this error as it takes more than 3 hours

Re: Qlik Data Gateway - Error EDC_ERROR:22013

V_Ortis — Tue, 03 Dec 2024 12:10:34 GMT

Hello everyone, I haven't found a solution yet, if anyone has any ideas, I'm at your disposal.

Re: Qlik Data Gateway - Error EDC_ERROR:22013

panda23 — Thu, 06 Mar 2025 15:31:22 GMT

Hi V_Ortis,

Did you find a solution for this case ?

Re: Qlik Data Gateway - Error EDC_ERROR:22013

V_Ortis — Tue, 11 Mar 2025 11:13:54 GMT

Hi @panda23, I haven't found a solution yet, but I opened a call with Qlik and got feedback about the datagateway service, and I isolated the service on a single server, the frequency of errors was lower when I made this change, but now it happened again.