Connection with BigQuery error

[manuelgomez]

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"

 

[sureshkumar]

Hello @manuelgomez 

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

Regards,
Suresh

[manuelgomez]

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)

[sureshkumar]

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

[manuelgomez · Accepted solution]

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.

[sureshkumar]

Thanks @manuelgomez  for the information 🙂