My Oracle Support Banner

OAC : Saving Google Analytics Connection Fails With "Internal Query Error" (Doc ID 2494154.1)

Last updated on FEBRUARY 03, 2019

Applies to:

Oracle Analytics Cloud Service - Version 18.2.1 to 18.3.3 [Release 18]
Information in this document applies to any platform.

Symptoms

OAC Version : 18.3.3-69

While creating connection to Google Analytics, authorization completes successfully. When saving the connection, it fails with below error :

Failed to save the connection. 
Internal query error.

 

 

Below exception is captured in bi_server1-diagnostic.log :

[2018-08-28T02:08:54.114+00:00] [bi_server1] [ERROR] [] [oracle.bi.datasource.trace] [tid: pool-44-thread-11] [userId: <anonymous>]
[ecid: 87f41ea9-3093-4958-b98c-ae6b32518e91-00023585,0:4:57:2] [APP:obi.datasrc.server] [partition-name: DOMAIN] [tenant-name: GLOBAL] [SI-Key: bootstrap] 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)

Changes

 

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
Changes
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.