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 06, 2017

Applies to:

Primavera P6 Enterprise Project Portfolio Management - Version 8.0 and later
Information in this document applies to any platform.

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).

 

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