Qlik Cloud - Reload Task Fails - Socket Closed

[CurtDaughtryBP]

I have a load scrip that has been running well for a long time.

Now - I'm getting the following error halfway through the script execution for no explainable reason.

The following error occurred:
 (Connector error: Socket closed)

How do I troubleshoot? Has anyone seen?

[jfgiudicelli]

Hi i've the same issue , i just change the socket size 900 to 400. tell me if it's you find any another issue

best regards

[CurtDaughtryBP]

How would you achieve that setting change? We are using QSE on Qlik Cloud.

[Akshesh_Patel]

Which connector are you using? Socket closed' is usually seen when a connector terminates suddenly.  Look for the script error and see at what point it is failing. If you are running a complex reload then try running a simple reload and see if that works. 

[CurtDaughtryBP]

The SalesForce connector. The reload is straight-forward (simple data extraction - select * type load) and the failure comes at different points in the scripts' progress on any given day.

[Akshesh_Patel]

Hi,

Would you mind trying now, there is recently a fix released for the web connector for a similar issue. If you are still getting an error then is it possible for you to get the reload logs or just a reload ID? 

Best

Akki

[CurtDaughtryBP]

Akki,

I believe you are running the support ticket, right? Will you please respond on that thread?

[StefanSonntag]

@CurtDaughtryBP I experience the same thing, with Google Drive. It started about 1.5 to 2 weeks ago that I got more frequent stops in load scripts with the same error message, at varying points in various scripts. Roughly 1 out of 10 reloads failed this way. Now, at the time of writing this post things seem to work stable since 24 hrs , so lets see if this (hopefully) stays that way

[-AA]

Hello, We are facing the same errors while running the queries to redshift via gateway. This errors happens randomly. Do anyone know the fix for this already? 

-Thanks

[Albert_Candelario · Accepted solution]

Hello @-AA ,

If having such issues with Qlik Data Gateway, I would strongly suggest to stay tune for the next release that should be resolving such issues.

Cheers,

Albert