topic Re: Qlik Cloud - Reload Task Fails - Socket Closed in Management & Governance

Qlik Cloud - Reload Task Fails - Socket Closed

CurtDaughtryBP — Fri, 02 Apr 2021 08:39:16 GMT

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?

Re: Qlik Cloud - Reload Task Fails - Socket Closed

jfgiudicelli — Mon, 01 Feb 2021 17:06:25 GMT

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

Re: Qlik Cloud - Reload Task Fails - Socket Closed

CurtDaughtryBP — Wed, 03 Feb 2021 18:23:22 GMT

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

Re: Qlik Cloud - Reload Task Fails - Socket Closed

Akshesh_Patel — Fri, 19 Feb 2021 21:11:48 GMT

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.

Re: Qlik Cloud - Reload Task Fails - Socket Closed

CurtDaughtryBP — Fri, 26 Feb 2021 14:46:13 GMT

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.

Re: Qlik Cloud - Reload Task Fails - Socket Closed

Akshesh_Patel — Fri, 05 Mar 2021 23:21:15 GMT

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

Re: Qlik Cloud - Reload Task Fails - Socket Closed

CurtDaughtryBP — Tue, 09 Mar 2021 02:04:31 GMT

Akki,

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

Re: Qlik Cloud - Reload Task Fails - Socket Closed

StefanSonntag — Tue, 09 Mar 2021 12:33:09 GMT

@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

Re: Qlik Cloud - Reload Task Fails - Socket Closed

-AA — Thu, 09 Feb 2023 08:01:59 GMT

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

Re: Qlik Cloud - Reload Task Fails - Socket Closed

Albert_Candelario — Thu, 09 Feb 2023 20:22:01 GMT

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

Re: Qlik Cloud - Reload Task Fails - Socket Closed

Serkan — Mon, 20 Feb 2023 08:34:21 GMT

Hi @Albert_Candelario we are facing out the same issue.

When could we expect the next release?

Thanks.

Regards

Serkan

Re: Qlik Cloud - Reload Task Fails - Socket Closed

fmarvnnt — Mon, 20 Feb 2023 09:16:52 GMT

Mee too with SAP SQL Connector using Qlik Data Gateway!

Re: Qlik Cloud - Reload Task Fails - Socket Closed

Albert_Candelario — Mon, 20 Feb 2023 09:16:57 GMT

Hello @Serkan ,

The latest release, Qlik Data Gateway Direct Access version 1.3.0 was out later last week.

Kindly, try it out and let us know if it has resolved your current challenges.

Cheers,

Albert

Re: Qlik Cloud - Reload Task Fails - Socket Closed

Albert_Candelario — Mon, 20 Feb 2023 09:19:21 GMT

Hello @fmarvnnt,

If having a similar issue within an specific database like the one you have mentioned, I would strongly suggest to open a separate post as might be beneficial for the rest of the Community users. Also, add as much context as possible so we can also have a look at it.

Cheers,

Albert

Re: Qlik Cloud - Reload Task Fails - Socket Closed

fmarvnnt — Mon, 20 Feb 2023 09:21:20 GMT

Let me decide to open a case to support.. ..maybe is the case since I cannot setup the mentioned socked param on this thread. I check also the ver...

Re: Qlik Cloud - Reload Task Fails - Socket Closed

fmarvnnt — Mon, 20 Feb 2023 09:31:51 GMT

Just one note: V 1.3.0 is not yet mentioned here: https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/Gateways/direct-access-gateway-upgrading.htm

Re: Qlik Cloud - Reload Task Fails - Socket Closed

Albert_Candelario — Mon, 20 Feb 2023 10:20:01 GMT

If you download the Data Gateway Direct Access from your tenant, you will see is already version 1.3.0. The Help page might need to get updated as you have mentioned. Thanks for flagging such, we will check within the needed teams.

Cheers,

Albert

Re: Qlik Cloud - Reload Task Fails - Socket Closed

Albert_Candelario — Mon, 20 Feb 2023 10:20:48 GMT

Hello @fmarvnnt ,

Are you saying you are getting this issue constantly? or is within a random fashion on some specific connections?

Cheers,

Albert

Re: Qlik Cloud - Reload Task Fails - Socket Closed

fmarvnnt — Mon, 20 Feb 2023 17:19:14 GMT

Hi Albert,

I've finished the tests right now and I can confirm that the Socked Closed happears randomly so the QDG ETL is extremely unstable. I guess I have to open a case; do you confirm Shall I?

Re: Qlik Cloud - Reload Task Fails - Socket Closed

Albert_Candelario — Mon, 20 Feb 2023 21:26:29 GMT

Hello @fmarvnnt,

I would suggest so as we would like to have more details of your connection, DB... to be able to assist you here.

Cheers,

Albert