My Oracle Support Banner

OBIeE 12c: OBIEE Not Authenticating Credentials When Using Essbase As A Datasource, "Network error [104]: Failed to receive data", "[nQSError : 43119] Query Failed" and generation of " xcp " crash files For Essbase NON ADMIN users (Doc ID 2716099.1)

Last updated on OCTOBER 09, 2020

Applies to:

Business Intelligence Server Administrator - Version and later
Information in this document applies to any platform.


Oracle Business Intelligence not authenticating credentials when using Essbase as a datasource

Using Essbase as a datasource in OBIEE and select the BI Username / Password Passthrough for the Essbase authentication method.

The RPD connnection pool is set to shared logon and  have entered the variables :USER and :PASSWORD for username and password.

Since this has been enabled, the queries are generating the following errors: Query Status: [nQSError: 96002] Essbase Error: Login fails due to invalid login credentials and [nQSError: 43119] Query Failed:

Error Codes

nQSError: 96002, nQSError: 43119



Network error [104]: Failed to receive data

Also, there will be essbase crash xcp files generated.


For Essbase NON ADMIN user , Excerpt of Session Log: :--


[] [OBIS] [TRACE:2] [] [] [ecid: xxxx] [sik: ssi] [tid: xxxxx] [messageid: USER-xx] [requestid: xxxxx] [sessionid: xxxx] [username: xxxxxxx]  Query Status: [nQSError: 96002] Essbase Error: message on contacting or from application: [[

Network error [104]: Failed to receive data

[nQSError: 43119] Query Failed:



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.