topic Connection with BigQuery error in Qlik Compose

Connection with BigQuery error

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

Hello dear community, I would like to request help, we are connecting to bigquery from the Qlik Compose platform and we get the following error "Unable to connect to the remote server"

Re: Connection with BigQuery error

sureshkumar — Fri, 15 Sep 2023 13:42:28 GMT

Hello @manuelgomez

Please check in compose log and compose agent log for more information.

Regards,
Suresh

Re: Connection with BigQuery error

manuelgomez — Wed, 20 Sep 2023 18:42:57 GMT

38 2023-09-19 03:50:17 [Host ] [WARN ] Unable to connect to the remote server
System.Net.WebException: Unable to connect to the remote server ---> System.Net.Sockets.SocketException: No connection could be made because the target machine actively refused it 127.0.0.1:56458
at System.Net.Sockets.Socket.DoConnect(EndPoint endPointSnapshot, SocketAddress socketAddress)
at System.Net.ServicePoint.ConnectSocketInternal(Boolean connectFailure, Socket s4, Socket s6, Socket& socket, IPAddress& address, ConnectSocketState state, IAsyncResult asyncResult, Exception& exception)

Re: Connection with BigQuery error

sureshkumar — Fri, 22 Sep 2023 12:37:40 GMT

Hello @manuelgomez
Try to ping and telnet the URL that you are trying to connect to. If this doesn't work, seek help from your network team to fix this.

Regards,

Suresh

Re: Connection with BigQuery error

manuelgomez — Fri, 22 Sep 2023 16:54:43 GMT

We noticed that when we included the JDBC .jar files necessary for the connection, the Compose Agent was disconnected.

Solution
To solve the connection error, it was necessary to delete the gson-2.10.1.jar file, which caused the connection to Compose Agent to not be made.

After this change we restarted the Qlik Compose service which ensured that the connection with Compose Agent was made correctly.

With this I have resolved, we performed the “Test Connection” again and the connection with Google BigQuery was completed satisfactorily.

Re: Connection with BigQuery error

sureshkumar — Mon, 25 Sep 2023 07:38:30 GMT

Thanks @manuelgomez for the information 🙂