BIP In OBIEE Creates Too Many Sessions For Scheduled Reports (Doc ID 1638391.1)

Last updated on JANUARY 23, 2017

Applies to:

BI Publisher (formerly XML Publisher) - Version 11.1.1.5.0 to 11.1.1.5.0 [Release 11.1]
Information in this document applies to any platform.

Symptoms

In OBI Analytics version 11.1.1.5.4:
BIP in OBIEE creates a lot of sessions when running offline reports. The report is scheduled to run and to send the output in .csv format to a mail address, or the output file is downloaded from the server. The spawned session appears in schedule history and does not disappear when the job is complete.

Expect Behavior:
Multiple sessions should not be created for the same user and should be cleaned up when done.

The issue can be reproduced at will with the following steps:
1. Log on to OBIEE.
2. Browse the catalogue of BI Publisher reports
3. Schedule a BI Publisher report with the option “Save Data for Republishing“ and format “CSV”.
4. Activate the notification email.
5. Submit the schedule request.
6. When the report finishes, log on to OBIEE and download the CSV file.

The following Business Impact occurs:
Due to multiple sessions getting spawned, all users are not able to run the BIP report. Some important management users are unable to post their Monthly Sell Through reports.

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