3690226 - Error : "sun.security.validator.ValidatorException: PKIX path building failed ... unable to find valid certification path" when refreshing a Web Intelligence document based on Google BigQuery

• Below error when refreshing a web intelligence report based on a ".unx" universe build on top of a Google BigQuery connection:

"Unexpected behavior: sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target"

• When creating a new report based on FHSQL with the Google BigQuery connection an error appears:

"Unexpected behavior: sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target"

• When creating a new relational connection based on Google BigQuery and using BusinessObjects OpenConnectivity as driver in IDT, the following error is displayed:

 "DBDriver failed to load java.lang.NoClassDefFoundError: com/google/cloud/bigquery/JobException"

• The test of an existing connection, in IDT, is successful.
• Issue appeared suddenly.

• SAP BusinessObjects Business Intelligence 4.3 SP3 patch 12
• Web Intelligence
• Information Design Tool
• Linux
• Reporting DB: Google BigQuery

ssl, certificate, big query, idt, webi, BO OC, sudden, , KBA , BI-RA-WBI , Web Intelligence , BI-BIP-IDT , Information design tool , Problem