topic Re: Qlik cloud data gateway in Data Movement & Streaming

Qlik cloud data gateway

KC1974 — Wed, 19 Mar 2025 23:02:17 GMT

Does the gateway support remote execution of stored procedures in SQL? I am getting the below error when trying to execute the Stored Procedure through the Qlik Data Gateway. 'The following error occurred: (Connector error: Invalid load request (DirectAccess-1006))'

Re: Qlik cloud data gateway

Vinay_B — Wed, 09 Aug 2023 12:50:59 GMT

Hi @KC1974

Stored Procedures are supported in the gateway. I don’t think that error would be related to the use of a stored procedure. Please review the logs for more clues.

The logs are located in: C:\Program Files\Qlik\ConnectorAgent\data\logs

You could raise a support case to investigate this error.

Re: Qlik cloud data gateway

KC1974 — Wed, 09 Aug 2023 13:01:42 GMT

Hi Vinay,
Thanks for the suggestion, I am not seeing anything in the logs. I tried switching the Stored Procedure to be the first thing to run in the script and that seemed to fix the issue. Previously the stored procedure was occurring at the end. Figured I would mention this in case it helps anyone else.

Re: Qlik cloud data gateway

Vinay_B — Thu, 10 Aug 2023 04:05:04 GMT

Hi, @KC1974 The error would be logged in the connector-agent logs and ODBC-connector logs. You can also raise a case with our support team to investigate this.