My Oracle Support Banner

OBIEE 12c : While Saving Google Analytics Connection to DV Fails With "Internal Query Error" (Doc ID 2627183.1)

Last updated on JANUARY 21, 2020

Applies to:

Business Intelligence Suite Enterprise Edition - Version 12.2.1.4.0 and later
Information in this document applies to any platform.

Symptoms

While creating connection to Google Analytics(GA) for DV 12.2.1.4, authorization completes successfully. But when trying to save the connection, it fails with below error :

Failed to save the connection.
Internal query error. 

 

The bi_server1-diagnostic.log file shows the following error -

[bi_server1] [ERROR] [] [oracle.bi.datasource] [tid: <TID>] [userId: <anonymous>] [ecid: <ECID>] [APP: obi.datasrc.server] [partition-name: DOMAIN] [tenant-name: GLOBAL] [SI-Key: ssi] Proxy Detection/Setup Failed
[bi_server1] [ERROR] [] [oracle.bi.datasource] [tid: <TID>] [userId: <anonymous>] [ecid: <ECID>] [APP: obi.datasrc.server] [partition-name: DOMAIN] [tenant-name: GLOBAL] [SI-Key: ssi] GoogleAnalytics: Invalid Credentials
[bi_server1] [ERROR] [] [oracle.bi.datasource.trace] [tid: <TID>] [userId: <anonymous>] [ecid: <ECID>] [APP: obi.datasrc.server] [partition-name: DOMAIN] [tenant-name: GLOBAL] [SI-Key: ssi]
INVALID_KEY [JDSError : 62] Invalid key from {0}[[
Cause - Invalid cipher key is used
Action - Check the cipher key in {0}

oracle.bi.datasource.saas.connector.google.analytics.GoogleAnalyticsConnector.getConnection(GoogleAnalyticsConnector.java:294)
oracle.bi.datasource.saas.connector.google.analytics.GoogleAnalyticsConnector.<init>(GoogleAnalyticsConnector.java:144)
oracle.bi.datasource.saas.connector.google.analytics.GoogleAnalyticsMetadataImporter.<init>(GoogleAnalyticsMetadataImporter.java:46)
oracle.bi.datasource.saas.connector.google.analytics.GoogleAnalyticsProvider.<init>(GoogleAnalyticsProvider.java:52)
oracle.bi.datasource.saas.connector.google.analytics.GoogleAnalyticsConnectorMetadata.createProvider(GoogleAnalyticsConnectorMetadata.java:103)
oracle.bi.datasource.service.DatasourceServiceProcessor.createProvider(DatasourceServiceProcessor.java:456)
oracle.bi.datasource.service.DatasourceServiceProcessor.verifyConnection(DatasourceServiceProcessor.java:1083)
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)...

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.