topic Re: Qlik cloud Data gateways in Data Movement & Streaming

Qlik cloud Data gateways

Thierno — Wed, 19 Mar 2025 23:08:30 GMT

Hi everyone,

I'm currently testing the new Data gateways - Direct access service on Qlik cloud but i'm having trouble creating a connection.

I have diligently followed the setup guide to install and configure à Data gateway given at this url :

https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/Gateways/setting-up-gateways.htm

Just for you know, I have installed the exe on my datawarehouse of development (just for our testing phase).

My gateway is showing "connected" on the QMC, but the problem i'm having is at the creation of the connection. I choose the Sql server Via Direct access gateway, but after putting all the info of the connection, i have an error which is the following :

Internal error
'O' is an invalid start of a value. Path: $ | LineNumber: 0 | BytePositionInLine: 0.

Whatever i type on the input of the connection seems to give me the same error. I think there is something i'm missing but i don't know what. I have also watched the guide, and i did everything showed there too.

At first, i though that it was because of the space i had affected the gateway, but i did exactly as showed in the video but it still give me the same error.
Please can you help me ?

Re: Qlik cloud Data gateways

Vinay_B — Sat, 27 Aug 2022 06:36:30 GMT

Hi 1047seatpi,

Can you tell me more about the environment Data gateway is installed? Is there a Proxy setup? Which server the application is installed on? Which roles you have on the QLik Cloud?

Please make sure that the Port HTTPS/TCP-443 should be opened for outbound communication to <tenant-id>.<region>.qlikcloud.com.

Below is the limitations:

Only HTTP proxy schemas are supported.
Proxy servers that are configured to intercept SSL connections (for the purposes of content inspection or other security measures) are not supported.

Please check the proxy settings.

Vinay

Re: Qlik cloud Data gateways

Thierno — Mon, 29 Aug 2022 08:46:51 GMT

Hi Vinay_B,

Thank you for your quick answer.
The server I installed the gateway do not have a proxy setup.

We installed the gateway on the same server of our database. And when i create de connection on Qlik cloud, i chose the Micorosoft SQL Server via direct access gateway, I put the server name (i've also tried localhost and some default port). But the error is the same. Do you think it can be the problem ?

I'm currently in a testing phase, before we migrate our environnement to Qlik cloud.
I've access to internet, but i just connected to Qlik cloud from the server, so i guess it's okay.

I have every role available on Qlik cloud. We have a testing license with 30 days.

But what i find weird is the error is no matter what i put on the hostname.

Re: Qlik cloud Data gateways

Vinay_B — Fri, 02 Sep 2022 15:32:28 GMT

Hi 1047seatpi,

Sorry for the delay, I was OoO.

Data Gateway uses port 5000. I suspect that the port is consumed by another app probably. I would suggest clearing this port and seeing if the test connection is successful. You can review the local Qlik Data Gateway logs in: C:\Program Files\Qlik\ConnectorAgent\data\logs

Example error:

[ERROR] connector-agent - System.IO.IOException: Failed to bind to address http://127.0.0.1:5000: address already in use.

FYI: https://community.qlik.com/t5/Knowledge/Qlik-Data-Gateway-Direct-Access-Data-Gateway-failing-with/ta-p/1974139

Let me know how it goes.

Re: Qlik cloud Data gateways

Thierno — Fri, 02 Sep 2022 15:50:04 GMT

Hi,

Yes, i'm aware of that solution. I've already tried it.
I've followed this post :
https://community.qlik.com/t5/Knowledge/Qlik-Data-Gateway-Direct-Access-Data-Gateway-failing-with/ta-p/1974139

and this one
https://community.qlik.com/t5/Knowledge/Data-Gateway-failing-with-Invalid-metadata-response-DirectAccess/ta-p/1975952

Now, So we have opened the port 5000, as you can see in the screenshot below.

After that changed, I had a different error :

The thing that bother me is, before we unblocked the port, we had in the log file the attempt of data connection (when we tried to create a connection in Qlik cloud) like this :
72 2022-09-02 10:12:50 [Service ] [ERROR] One or more errors occurred. (Aucune connexion n’a pu être établie car l’ordinateur cible l’a expressément refusée. (localhost:5000))

But now the log file, only show the ping to QCS.

Re: Qlik cloud Data gateways

NadiaB — Tue, 06 Sep 2022 12:54:51 GMT

Hi @Thierno

It will probably be better to start a new thread about the new issue, it seems you are getting now "Invalid metadata response (DirectAccess-2201)", is that still current?

If so, could you confirm the privileges of the user are correct on the Space where the Data Gateway resides and the Space where the connection is attempted to be configured correct?

Did you try to connect to the DB from the server where Qlik Data Gateway is installed?

Do you see anything in the logs when you get the error?

If you open the browser developer tools, under Network tab, do you see any errors?

Any details will be appreciated.

Re: Qlik cloud Data gateways

Thierno — Tue, 06 Sep 2022 14:03:46 GMT

I found the solution.

Qlik data gateway doesn't seem to work when you install the gateway on the same server as your database.

Re: Qlik cloud Data gateways

FedericoC — Wed, 21 Sep 2022 09:30:05 GMT

Hello,

I had the same problem but the cause was different. I solved it disabling IPV6 on the server where is Qlik Data Gateway.