OBIEE 12c ACT AS Not Working As Expected - Logged Out Error
Last updated on APRIL 12, 2018
Applies to:Business Intelligence Suite Enterprise Edition - Version 22.214.171.124.0 and later
Information in this document applies to any platform.
1. Enabled the ACT AS functionality using the document - https://docs.oracle.com/middleware/1221/biee/BIESC/mgrgrpsusers.htm#BIESC3146.
2. Login as the proxy user, open drop down menu under user, select ACT AS.
3. Select the target user. Click OK. User is logged out of Analytics and taken to the OBIEE login page.
The following error is seen in the obis1-diagnostic.log -
Observed that the RUNASORIGUSER is sending in junk value and not my userid. Due to this the init block cannot execute successfully.
********** Task: 1. Running for (mls): **********
Description: Execute Init Block
Name: PROXYLEVEL Init
Query:select proxyLevel ^M
where UPPER(targetid) = UPPER('VALUEOF(NQ_SESSION.RUNAS)') ^M
and UPPER(proxyid) = UPPER('ofn2yw8epi4ktdcgrjvsla7zuxhb3mq5')
********** Task: 2. Running for (mls): 289 **********
[nQSError: 23006] The session variable, NQ_SESSION.RUNAS, has no value definition.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms