My Oracle Support Banner

OAC: How To Pass BI User Credential Pass Through To Essbase (Doc ID 2409129.1)

Last updated on FEBRUARY 03, 2019

Applies to:

Oracle Analytics Cloud Service - Version 17.4.1 to 18.1.3 [Release 17 to 18]
Information in this document applies to any platform.

Symptoms

OAC-Essbase Cloud

+ Connecting to Essbase as Back-End DB


+ Configured rpd --> connection pool with SSO & Shared logon enabled

+ Username using :USER for USER and :PASSWORD for password

+ The reports fail with the following error

[2018-05-23T16:36:19.465-00:00] [OBIS] [TRACE:2] [] [] [ecid: afdf0140-510c-4001-b9fb-e04f75277619-000008c0,0:1:9:5] [sik: bootstrap] [tid: b88a8700] [messageid: USER-34] [requestid: 185003e] [sessionid: 1850000] [username: email@example.com] -------------------- Query Status: [nQSError: 96002] Essbase Error: Login fails due to invalid login credentials [[[nQSError: 43119] Query Failed:



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.