Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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"
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.
Hello @manuelgomez
Please check in compose log and compose agent log for more information.
Regards,
Suresh
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)
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
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.
Thanks @manuelgomez for the information 🙂