My Oracle Support Banner

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

Last updated on MAY 13, 2021

Applies to:

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


On Oracle Business Intelligence Enterprise Edition Version or later :

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

Failed to save the connection. 
Internal query error.

bi_server1.out shows below error :

<Error> <><BEA-000000> <Unable to verify connection '<USERNAME>'.'<CONNECTION NAME>'>

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

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

<Warning> <> <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=""><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></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 




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

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