Qlik Data Gateway - Error EDC_ERROR:22013

[V_Ortis]

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?

[fmarvnnt]

Hi,

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

[V_Ortis]

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

[fmarvnnt]

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

[V_Ortis]

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

[V_Ortis]

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

[V_Ortis]

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

[koala23]

Hi V_Ortis, 

Did you find a solution for this case ? 

[V_Ortis]

Hi @koala23, 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.