topic Re: Qlik Compose - Snowflake issue: The remote server returned an error: (401) Unauthorized in Qlik Compose

Qlik Compose - Snowflake issue: The remote server returned an error: (401) Unauthorized

t_schueller — Fri, 14 Mar 2025 20:49:07 GMT

Hi,

I used Qlik C4DW with snowflake and it worked fine. On the same server, I installed the new product Qlik Compose (merge between C4DW and C4DL).

In Qlik Compose when I try to connect to Snowflake with exactly the same parameters as C4DW, I have this issue: The remote server returned an error: (401) Unauthorized.

Do you have any ideas?

Qlik C4DW

Qlik Compose

Thanks,

Best regards,

Thibaut

Re: Qlik Compose - Snowflake issue: The remote server returned an error: (401) Unauthorized

Brian_Jones — Tue, 30 Mar 2021 13:35:37 GMT

The connection parameters are unchanged between Qlik Compose for Data Warehouses and Qlik Compose.

However, the default directory has changed to C:\Program Files\Qlik\Compose. I'd suggest checking the following:

Check your Snowflake JDBC driver is in the following path for Qlik Compose.

C:\Program Files\Qlik\Compose\java\jdbc

( I'm using snowflake-jdbc-3.12.2.jar)

Check your Snowflake ODBC driver is current.

Download and install Snowflake ODBC driver for Windows 2.18.1 or above.

Re: Qlik Compose - Snowflake issue: The remote server returned an error: (401) Unauthorized

t_schueller — Tue, 30 Mar 2021 13:53:33 GMT

Hi Brian,

Thanks.

That's the first thing I checked. I copied all JBDC used in C4DW to the new default directory of Qlik Compose.

Best regards,

Thibaut

Re: Qlik Compose - Snowflake issue: The remote server returned an error: (401) Unauthorized

TimGarrod — Tue, 30 Mar 2021 13:59:00 GMT

Do you have a source connection tied to a Replicate task?

This maybe your connection to Replicate from Qlik Compose? or even a conncetion to a source system if you have that defined.

Can you check those and also type in your passwords again ?

The easy way to tell if the Snowflake connection is working is to edit the connection and click the elipses to select your dw schema / database. If Compose can connect to Snowflake - you'll get the list. If its having an issue connecting to Snowflake - you'll get an error.

Re: Qlik Compose - Snowflake issue: The remote server returned an error: (401) Unauthorized

t_schueller — Tue, 30 Mar 2021 19:27:26 GMT

Hi Tim,

The connection to my replicate server is working and the connection to the source database is also working (Discover option works properly).

If I select a dw schema or database or Warehouse, it's working. The test connection is not working. In Data Warehouse section, run ETL set is not working with the same error (401 Unauthorized).

Re: Qlik Compose - Snowflake issue: The remote server returned an error: (401) Unauthorized

TimGarrod — Tue, 30 Mar 2021 19:31:03 GMT

Compose connects with the UI via ODBC and at runtime with JDBC via the Java agent. So this appears to be a jdbc related issue (Test connection tests both ODBC and JDBC)...

Can you turn on logging for the agent and provide the agent log (you can private message me instead of posting here in the community) - or I suggest opening a ticket with support. But it appears to be a jdbc issue based on what you've said above. Seems like the driver is there, or you'd normally get some type of class not found error.

Are you using a proxy at all to connect to snowflake?

Re: Qlik Compose - Snowflake issue: The remote server returned an error: (401) Unauthorized

t_schueller — Tue, 30 Mar 2021 19:49:57 GMT

Actually the 401 is sent by the Compose server. I can't change the log level, I have the same error. Any idea? Otherwise i will open a case with support.

Thanks,

Thibaut

Re: Qlik Compose - Snowflake issue: The remote server returned an error: (401) Unauthorized

TimGarrod — Tue, 30 Mar 2021 19:52:19 GMT

DO you have Compose DW (7.x) on the same server?

If so - can you shut down ComposeDW - make sure there are no java processes running on the server (which is the Compose agent) and restart QLik Compose. I'm wondering if its a port issue with the 2 running on the same server. (if thats what you've got running on your server)

Re: Qlik Compose - Snowflake issue: The remote server returned an error: (401) Unauthorized

t_schueller — Tue, 30 Mar 2021 20:05:17 GMT

Yes. I disabled C4DW and C4DL services and restart the server but still the same issue.

Re: Qlik Compose - Snowflake issue: The remote server returned an error: (401) Unauthorized

t_schueller — Wed, 31 Mar 2021 09:28:41 GMT

Hi Tim,

I changed the agent from local to a remote (who doesn't exist) and then change it again to local and now it's working.

Thanks ofr your help.

Thibaut

Re: Qlik Compose - Snowflake issue: The remote server returned an error: (401) Unauthorized

philipp_ebner — Mon, 25 Oct 2021 13:43:00 GMT

I still have that issue:

IS there a different solution for this, I am facing the same behaviour, when trying to connect Compose to MS SQL Server (to set up a Data Warehouse).

In prior Versions this was not an issue, but after upgrading to Version August 2021 (Compose4DL) the "test connection" fails with an 401 error.

The user running the Compose Service was/is Admin on both system (Qlik Compose Server and MS SQL Server)

The user can log on to SQL Server without problems...

With Qlik Replicate (on the same Server as Compose is) I can easily execute and Create Relaod and CDC tasks...

A complete uninstall and re-install of Compose does not help....

the compose logs constantly show: [START: 2021-10-25 14:39:23 Qlik Compose Version: 2021.8.0.139]
4 2021-10-25 14:39:24 [Host ] [INFO ] Setting up web host
4 2021-10-25 14:39:25 [Host ] [INFO ] The server will listen on the following location: http://trnbiqv01.terna-bi.com/qlikcompose
4 2021-10-25 14:39:25 [Host ] [INFO ] The server will listen on the following location: https://trnbiqv01.terna-bi.com/qlikcompose
4 2021-10-25 14:39:25 [Host ] [INFO ] Starting web host
4 2021-10-25 14:39:25 [Host ] [INFO ] Web host started
6 2021-10-25 14:39:28 [Compose ] [INFO ] Java Server:starting REST server.
6 2021-10-25 14:39:29 [Compose ] [INFO ] Java Server:Listening on port: 49771
6 2021-10-25 14:39:29 [Compose ] [INFO ] Java Server:Hit Q<Enter> to stop:
9 2021-10-25 14:39:34 [Host ] [WARN ] Der Remoteserver hat einen Fehler zurückgegeben: (401) Nicht autorisiert.
System.Net.WebException: Der Remoteserver hat einen Fehler zurückgegeben: (401) Nicht autorisiert.
bei System.Net.HttpWebRequest.GetResponse()
bei Attunity.Infrastructure.Globals.AtRestApiClientUtils.A(CookieContainer , Boolean )
bei Attunity.Infrastructure.Globals.AtRestApiClientUtils.A(String , String , String[] , Object , Stream , String , Boolean )
bei Attunity.Infrastructure.Globals.AtRestApiClientUtils.A(String , String , String[] , Object , Stream , String )
bei Attunity.ComposeEngineCtl.Client.ComposeEngineCtlClient.ComposePing(ComposePingParams restParams, PingMessage req)
37 2021-10-25 14:39:34 [Host ] [WARN ] Der Remoteserver hat einen Fehler zurückgegeben: (401) Nicht autorisiert.
System.Net.WebException: Der Remoteserver hat einen Fehler zurückgegeben: (401) Nicht autorisiert.
bei System.Net.HttpWebRequest.GetResponse()
bei Attunity.Infrastructure.Globals.AtRestApiClientUtils.A(CookieContainer , Boolean )
bei Attunity.Infrastructure.Globals.AtRestApiClientUtils.A(String , String , String[] , Object , Stream , String , Boolean )
bei Attunity.Infrastructure.Globals.AtRestApiClientUtils.A(String , String , String[] , Object , Stream , String )
bei Attunity.ComposeEngineCtl.Client.ComposeEngineCtlClient.ComposePing(ComposePingParams restParams, PingMessage req)
37 2021-10-25 14:39:36 [Host ] [WARN ] Der Remoteserver hat einen Fehler zurückgegeben: (401) Nicht autorisiert.
System.Net.WebException: Der Remoteserver hat einen Fehler zurückgegeben: (401) Nicht autorisiert.
bei System.Net.HttpWebRequest.GetResponse()
bei Attunity.Infrastructure.Globals.AtRestApiClientUtils.A(CookieContainer , Boolean )
bei Attunity.Infrastructure.Globals.AtRestApiClientUtils.A(String , String , String[] , Object , Stream , String , Boolean )
bei Attunity.Infrastructure.Globals.AtRestApiClientUtils.A(String , String , String[] , Object , Stream , String )
bei Attunity.ComposeEngineCtl.Client.ComposeEngineCtlClient.ComposePing(ComposePingParams restParams, PingMessage req)
37 2021-10-25 14:39:37 [Host ] [WARN ] Der Remoteserver hat einen Fehler zurückgegeben: (401) Nicht autorisiert.
System.Net.WebException: Der Remoteserver hat einen Fehler zurückgegeben: (401) Nicht autorisiert.

Re: Qlik Compose - Snowflake issue: The remote server returned an error: (401) Unauthorized

philipp_ebner — Thu, 28 Oct 2021 06:40:55 GMT

Hello, further investigation indicate that this issue is somehow related to an SSL Certificate which i applied in order to run compose via HTTPS. COnsole opens up without Certificate error but the error logs say the following :

Remote name culd not be resolved (i guess the remotename is the Servername of the SQL Server)

Der Remotename konnte nicht aufgelöst werden: 'https'
System.Net.WebException: Der Remotename konnte nicht aufgelöst werden: 'https'

Re: Qlik Compose - Snowflake issue: The remote server returned an error: (401) Unauthorized

philipp_ebner — Mon, 22 Nov 2021 07:36:01 GMT

Praise to Qlik Support, for helping me out:

The agent wasn't connected to the Server, so we have performed the below steps, which solved the issue:
1. Backup data/projects folder
2. Backup GlobalRepository.sqlite file
3. Stop Compose service
4. Open GlobalRepository.sqlite (using DB Browser)
5. Go to Browse Data tab
6. From Table option scroll down to "objecst"
7. Search the "JavaServerConfiguration" type , mark the whole row and delete it (screenshot attached)
8. Save the file, start Compose service again.