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
Last updated on NOVEMBER 28, 2017
Applies to:Primavera P6 Enterprise Project Portfolio Management - Version 8.0 and later
Information in this document applies to any platform.
Using Primavera P6 Enterprise Project Portfolio Management (P6 EPPM) with a SQL Server database:
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.
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.
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
- Run the summarize job.
- Once the job service poll rate runs, it will start to queue the projects (and rerun within 10 seconds).
- 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).
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms