My Oracle Support Banner

OBIEE 12.2.1.4 : Connection To Essbase Server 11.1.2.4 Fails (Doc ID 2620415.1)

Last updated on DECEMBER 13, 2019

Applies to:

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

Symptoms

On Oracle Business Intelligence Enterprise Edition Version 12.2.1.4.0 or later :

While saving connection to Essbase server version 11.1.2.4.x in data visualization (DV), it fails with below error :

Failed to save the connection. 
Internal query error.

bi_server1.out shows below error :

<Error> <oracle.bi.web.datasetsvc><BEA-000000> <Unable to verify connection '<USERNAME>'.'<CONNECTION NAME>'>

<Error> <oracle.bi.tech.services.dataset><BEA-000000> <Failed to create connection. : Internal Server Error - {"code":500101,"message":"JDS - Internal Server error","subMessage":" [JDSError : 77] 0 : java.io.IOException: execute query failed[nQSError: 43113] Message returned from OBIS.\nEssbase Error 114\nCause: SQLException is thrown from the datasource\nAction: Check the log"}>

<Warning> <oracle.bi> <BEA-000000><Unsupported property passed in properties: fixedString=true>

<Warning> <oracle.bi> <BEA-000000><Unsupported property passed in properties: oracle.jdbc.J2EE13Compliant=true>

obis1-diagnostic.log shows below error :

[OBIS] [NOTIFICATION:1] [] [] [ecid:<ECID>] [sik: ssi] [tid:<TID>] call NQSExternalVerifyConnection( '<?xml version="1.0" encoding="UTF-8" standalone="no"?><cm:dsConnMetadata xmlns:cm="com.oracle.bi/ConnMetadata/v1"><cm:dsMetadata><cm:cliName>ESSBASE</cm:cliName><cm:targetName>Essbase11</cm:targetName><cm:providerName>essbase</cm:providerName><cm:useSqlOverHttp>false</cm:useSqlOverHttp></cm:dsMetadata><cm:connectionParameters/><cm:dsSignon><cm:dsn><ESSBASE SERVER HOSTNAME>:<PORT></cm:dsn><cm:userName><USERNAME></cm:userName><cm:password><PASSWORD></cm:password><cm:driverClass>oracle.bi.jdbc.AnaJdbcDriver</cm:driverClass></cm:dsSignon><cm:enablePooling>false</cm:enablePooling><cm:dsConnPoolParams><cm:maxConnections>100</cm:maxConnections><cm:timeOut>600</cm:timeOut></cm:dsConnPoolParams></cm:dsConnMetadata>' ,'''<USERNAME>''.''<CONNECTION NAME>''' )

[ERROR:1] [] [] [ecid:<ECID>] [sik: ssi] [tid:<TID>] Essbase Error 114 [[file: server/Query/Execution/DbGateway/DbGatewayEssbaseCAPI/PrivateInclude/SQXDGEssbaseCAPIImport.h; line: 66 

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.