When Running A Summarization Job Which Contains A Large Amount Of Projects, The Job Stops Processing And Remains In A Pending State Or Delegated State Indefinately Using A Microsoft SQL Server Database (Doc ID 2043013.1)

Last updated on FEBRUARY 15, 2023

Applies to:

Symptoms

Using Primavera P6 Enterprise Project Portfolio Management (P6 EPPM) with a SQL Server database:

ACTUAL BEHAVIOR

When creating a summarization job that will summarize a large amount of projects, there is potential that the jobs will stop processing and cause the job to stay in a pending state if the Job Service Poll Rate runs a second time before all the child jobs have finished creating for the initial scheduling of the summarize job.

EXPECTED BEHAVIOR

For all service jobs from an active transaction to complete successfully if the Job Service Poll Rate runs a second time before all the child jobs have finished creating for the initial scheduling of the summarize job.

STEPS

The issue can be reproduced at will with the following steps:
 - Job Service Poll Rate = 10s (in configuration of P6 or p6services.jar)
 - Summarize job of an EPS created contains 5000 projects

1. Run the summarize job.
2. Once the job service poll rate runs, it will start to queue the projects (and rerun within 10 seconds).
3. If child jobs for every project did not yet create in the JOBSVC table (say only 4000 of the 5000 jobs created), and the job service code polls the table to look for new jobs before the initial job put all its projects in queue, it will result in the remaining projects to not get added and existing projects in queue to remain in a pending state (and not run).

Changes

Cause

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