My Oracle Support Banner

OBIEE 12c: Analysis Running Against Hyperion Planning Data Source Returns "ADM Incorrect URL -- Error: Error creating objectjava.lang.ClassNotFoundException" (Doc ID 2507060.1)

Last updated on NOVEMBER 06, 2019

Applies to:

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

Symptoms

On : 12.2.1.2.180717 version, Analytics

1. Set up a Hyperion Planning data source as the instructions in Note 2360587.1

2. Import metadata into the repository successfully

3. When running the analysis against the Hyperion Planning data source, the following error returns:

The ODBC driver returned an error (SQLExecDirectW).
  Error details

Error code: OPR4ONWY:U9IM8TAC:U9IM8TAC:U9IM8TAC:U9IM8TAC:OI2DL65P
Status: HY000。code: 10058。[NQODBC] [SQL_STATE: HY000] [nQSError: 10058] occurred。 (HY000)
Status: HY000。code: 43113。[nQSError: 43113] Returns a message from OBIS. (HY000)
Status: HY000。code: 43119。[nQSError: 43119] Query failed: (HY000)
Status: HY000。code: 77031。[nQSError: 77031] [nQSError: 77031] Error occurs while calling remote service ADMService.  Details: ADM Query Execution Error -- oracle.bi.integration.ADM.service.ADMException: ADM Incorrect URL -- oracle.bi.integration.ADM.service.ADMException: ADM Incorrect URL -- Error: Error creating objectjava.lang.ClassNotFoundException Details: (HY000)

You have the following error in the BI Server log under $DOMAIN_HOME/servers/obis1/logs.

obis1-query.log
-----------------------
Query Status: [nQSError: 77031] Error occurs while calling remote service ADMService. Details: ADM Query Execution Error -- oracle.bi.integration.ADM.service.ADMException: ADM Incorrect URL -- oracle.bi.integration.ADM.service.ADMException: ADM Incorrect URL -- Error: Error creating objectjava.lang.ClassNotFoundException

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.