Google Web Connector failing with SSL/TLS issue
Article Number: 000047510 | Last Modified: 2018/11/21
Connections/reload tasks are failing due to SSL/TLS errors when attempting to pull data from Google Analytics.
Some admins may elect to lock down windows from adding/updating Trusted Root Certificates. This may cause occasional errors when using the Qlik Web Connectors specifically 'There was an error running the table (Failed on attempt 1 to GET. (The underlying connection was closed: Could not establish trust relationship for the SSL/TSL secure channel.))' when the Web Connectors try to connect to a source the server doesn't have a certificate for or has a certificate but that certificate has recently expired.
The server running the Qlik Web Connectors needs to have the root certificates that the remote sources (Google in this case) leverage to have a chain of trust in the request.
More specifically it has been validated which certs were needed, GeoTrust Global CA for google (https://pki.google.com
) and downloaded the needed certificate from https://www.geotrust.com/resources/root-certificates/