OBIEE Sessions Persist After A BI Publisher Report Is Executed Via the Scheduler With the BI Server Security Model

(Doc ID 2363344.1)

Last updated on MARCH 01, 2018

Applies to:

Business Intelligence Server Enterprise Edition - Version 11.1.1.5.0 BP2 and later
Information in this document applies to any platform.

Symptoms

In an environment where OBIEE and BI Publisher (BIP) are installed, and BI Publisher Security Model is set to "Oracle BI Server" executing a BIP report via the BIP scheduler results in the creation of many BI Presentation Server (OBIPS) sessions that persist even after the BIP report has completed.  These "inactive" sessions are only closed when the User Session Expiry time elapses or the environment is re-started.

To reproduce / confirm the issue:

1. Set the BIP Security Model to "Oracle BI Server" and re-start
    Login to /analytics > Administration > Manage BI Publisher > Security Configuration > Set Authorization > Security Model to "Oracle BI Server"

2. Schedule a BIP report
    Login to /analtyics > Catalog > Navigate to the BIP report > Schedule

3. Check the OBIPS sessions upon completion of the scheduled BIP report and see multiple sessions (for example, 10+) are present for the user who scheduled the report and with no Host Address
    Login to /analytics > Administration > Manage Sessions

4. Check the OBIPS sessions after the User Session Expiry time elapses and see the above sessions are no longer present
    Login to /analytics > Administration > Manage Sessions

Notes:

(i) With the BIP Security Model set to "Oracle BI Server", this issue is not encountered if the BIP report is executed interactively.
    With the BIP Security Model set to "Oracle Fusion Middleware", this issue is not encountered if the BIP report is executed interactively or via the BIP scheduler.

(ii) The User Session Expiry time is the <ClientSessionExpireMinutes> parameter in the OBIPS instanceconfig.xml file and is set as:
    11g: FMW Enterprise Manager > Business Intelligence > coreapplication > Capacity Management > Performance
    12c: FMW Enterprise Manager > Target Navigation > Business Intelligence > biinstance > Capacity Management > Performance

(iii) This issue is encountered in 11g (11.1.1.5.x+) and 12c (including 12.2.1.3.x which is the current release as of the writing of this document).

Cause

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