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:

Symptoms

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

Essbase.log

=============

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: [[
[]Local////140525161473792/Error(1042013)

Network error [104]: Failed to receive data

[nQSError: 43119] Query Failed:

Cause

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