My Oracle Support Banner

BI Publisher Creates too Many Sessions While Executing a Scheduled Job (Doc ID 2338493.1)

Last updated on DECEMBER 03, 2020

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.

Changes

 

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


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