P6 EPPM Services Stop Processing Pending, Available Jobs While Connecting To An Oracle RAC
Last updated on JANUARY 12, 2018
Applies to:Primavera P6 Enterprise Project Portfolio Management - Version 188.8.131.52 and later
Information in this document applies to any platform.
P6Services intermittently stops processing some jobs, causing them to be stuck in Pending status. Restarting P6Services allows all jobs to complete.
The job type does not matter and can include ASAP jobs (for example, "Send to Unifier") as well as Reoccurring jobs (for example, Global Scheduled Services).
Additionally, if using r16.2.10 or later, you receive the following error within the services log file:
A safety_date ($DATE) that is earlier than previous safety date ($DATE). This is a possible indicator that database RAC node clocks are not synchronized, and may cause jobs to get skipped. Please ensure clocks are synchronized.
All jobs should move from Pending to Running to Complete in a timely manner when they are in a pending state for immediate execution.
The issue can be reproduced at will with the following steps:
1. Start the P6 Services process.
2. Monitor process for a few days.
3. Note stuck jobs.
Due to this issue, some jobs do not run and complete unless the P6 Services process is stopped and restarted.
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