ERROR [HY000] [Simba][BigQuery] (100) Error interacting with REST API: Peer certificate cannot be authenticated with given CA certificates when trying to fetch data from Qlik GoogleBigQuery Connection. The issue is related to an outdated Certificate installed on the server or local machine.
Qlik Sense 3.x all SRs
Qlik Sense June 2017 and further
Qlik View all versions.
The following certificate GTS GIAG3 can be manually updated from the Google Trusted Services' Website
.It has to be added on root level:
GTS GIAG3 RSA 2048, SHA-256ee:ac:bd:0c:b4:52:81:95:77:91:1e:1e:62:03:db:26:2f:84:a3:18Dec 15, 2021 using the DER link to the right.https://pki.goog/gsr2/GTSGIAG3.crt
It seems to be related to the fact that Google has issued new certificates. You have to download and install the certification on every machine that uses the Qlik Google BigQuery Connector.
The certificate should be installed to Certificates (Local Computer) > Trusted Root Certification Authorities > Certificates
or Certificates (Local Computer) >
Intermediate Certification Authorities > Certificates