BI Publisher Creates too Many Sessions While Executing a Scheduled Job

(Doc ID 2338493.1)

Last updated on DECEMBER 20, 2017

Applies to:

BI Publisher (formerly XML Publisher) - Version 11.1.1.9.x and later
Information in this document applies to any platform.

Symptoms

Oracle BI Publisher 11.1.1.9.171017 (Oct 2017 update)


ACTUAL BEHAVIOR
---------------------------------
Total number of sessions is shown as 40 for a single BI Publisher scheduler job execution.


EXPECTED BEHAVIOR
----------------------------------
When a single report job is executed, it should not span 40 sessions to complete the job.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1. Schedule a BI Publisher Report job.
2. From OBIEE Administration page, observe that the total number of sessions displayed as 40 during the job execution.


BUSINESS IMPACT
-----------------------
This issue may lead to performance problems when multiple jobs are scheduled and executed simultaneously.

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