My Oracle Support Banner

OBIEE 12c - case sensitivity of USER session variable name (Doc ID 2673580.1)

Last updated on MAY 27, 2020

Applies to:

Business Intelligence Server Enterprise Edition - Version 12.2.1.0.0 to 12.2.1.4.200414 [Release 12g]
Information in this document applies to any platform.

Symptoms

NQ_SESSION.user/NQ_SESSION.User is working in OBIEE 11g but in OBIEE 12c NQ_SESSION.user/User is not working. 

In OBIEE 12c NQ_SESSION.USER is only working as expected.



Error details from OBIEE 12c if we try to use NQ_SESSION.user/NQ_SESSION.User

Formula syntax is invalid.
[nQSError: 10058] A general error has occurred. (HY000)
[nQSError: 43113] Message returned from OBIS. (HY000)
[nQSError: 23006] The session variable, NQ_SESSION.user, has no value definition. (HY000)
SQL Issued: SELECT VALUEOF(NQ_SESSION.user) FROM "Sample Sales"
OK (Ignore Error)

With this lot of reports (over 1000) are failing in OBIEE 12c

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
Cause
Solution


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