P6 EPPM Services Stop Processing Pending, Available Jobs While Connecting To An Oracle RAC

(Doc ID 2304711.1)

Last updated on JANUARY 12, 2018

Applies to:

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

Symptoms

ACTUAL BEHAVIOR

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:


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



EXPECTED BEHAVIOR

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.

Changes

 

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