Error when creating webi report using Google BigQuery Open connection

[hema_komaragiri]

Hello,

We have installed below version SAP BO on linux server and same version client IDT on windows server. In IDT created the Google BigQuery Open Connection using Json, test was successful and setup the universe published to repository. 

Version: SAP BusinessObjects BI Platform 4.3 Support Pack 4 Patch 5 Version : 14.3.4.4970.5

Steps followed: 2944991 - How To Create Google BigQuery Connection In Information Design Tools - BI 4.3 - SAP for Me

When we try to create WEBI report using the above created universe getting the below error message

The following database error occurred: (CS) "Java Exception : java.lang.NullPointerException: while trying to invoke the method com.google.cloud.bigquery.BigQueryOptions.getService() of a null object returned from com.sap.connectivity.cs.java.drivers.bigquery.BigQueryConnection.getBuild()" . For information about this error, please refer to SAP Knowledge Base Article 2054721 on the SAP Support Portal. (IES 10901)

To fix the issue we have recreated APS DLSBridge as suggested below link but no luck 

3135524 - "The following database error occurred: (CS) "Java Exception : xxxx the method com.google....

We can create the webi report using the BigQuery universe in the Rich client but not in the browser, since its new install there is no load balancer setup yet.  Also we have tested eFashion universe in the browser it works fine but not the BigQuery universe.  would appreciate if you could help us to fix the issue. 

Thank you

Hema

[hema_komaragiri]

Hello, could you please help? Thank you

[ayman_salem]

Have you checked if you can access Google BigQuery from your Linux computer?

[hema_komaragiri]

Hi Ayman, Thank you for the prompt response. yes we have tested the bigquery connection from linux box and it works see below. Would appreciate if you could help us to fix the issue. Thank you

$ bq query --use_legacy_sql=false 'SELECT CURRENT_DATE()'
BQ CLI will soon require all users to log in using `gcloud auth login`. `bq
init` will no longer handle authentication after January 1, 2024.

Welcome to BigQuery! This script will walk you through the
process of initializing your .bigqueryrc configuration file.

First, we need to set up your credentials if they do not
already exist.

Setting project_id test as the default.

BigQuery configuration complete! Type "bq" to get started.

+------------+
| f0_ |
+------------+
| 2024-08-20 |
+------------+