Skip to main content
Announcements
A fresh, new look for the Data Integration & Quality forums and navigation! Read more about what's changed.
cancel
Showing results for 
Search instead for 
Did you mean: 
V_Ortis
Contributor II

Qlik Data Gateway - Error EDC_ERROR:22013

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

V_Ortis_0-1732884714907.png

V_Ortis_1-1732884840263.png

V_Ortis_2-1732884999589.png

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?

8 Replies
fmarvnnt
Partner - Creator III

Hi,

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

fmarvnnt_0-1732886304936.png

 

V_Ortis
Contributor II
Author

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
Partner - Creator III

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
Contributor II
Author

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

V_Ortis
Contributor II
Author

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
Contributor II
Author

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

koala23
Partner - Contributor III

Hi V_Ortis, 

Did you find a solution for this case ? 

V_Ortis
Contributor II
Author

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.