Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
QlikView GCP BigQuery connection JSON database not connected.
we are getting the below error while relaoding the app in QMC and by manually also.
we have defined the project in GCP console and using JSON file to fetch the connection string.
(Information) 21/03/2022: 15:41:50 0166 SQL
(Information) 21/03/2022: 15:41:50 0167 SELECT * FROM `prj-xx.....xx..roamer`
(Information) 21/03/2022: 15:41:51 Error: Connector reply error: Unable to connect to database:
(Information) 21/03/2022: 15:41:51 Error message:
(Information) 21/03/2022: 15:41:51 Please check the values for Username‚ Password‚ Host and other properties.
(Information) 21/03/2022: 15:41:51 Description: Access credentials are not valid for this connection.It is not possible to use encrypted credentials when encryption is disabled.
(Information) 21/03/2022: 15:41:51 Execution Failed
(Information) 21/03/2022: 15:41:52 Execution finished.
Hello @AbhiUKVM
Verify the user configured in the connection is granted the proper permissions, is enabled, and the password is correctly typed. Make the user has access to the database.