P6 EPPM Services Stop Processing Pending, Available Jobs While Connecting to an Oracle RAC
(Doc ID 2304711.1)
Last updated on FEBRUARY 28, 2019
Applies to:Primavera P6 Enterprise Project Portfolio Management - Version 22.214.171.124 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.
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