Copy/Paste, Create Baseline or Copy Baseline Service Delay Between Time Job Moves From Running State And When Service Code To Create Data Actually Begins (Doc ID 2738487.1)

Last updated on MARCH 22, 2022

Applies to:

Symptoms

ACTUAL RESULTS

After creating a copy/paste project, create baseline or copy baseline job, there can be intermittent delay between:

• The time the job is moved into a running state (ie, JOBSVC.status_code='JS_Running')
• The time copy/paste service code actually begins

This can be spotted while reviewing log entries configured in debug mode.

Example:

EXPECTED RESULTS

After a copy/paste project, create baseline or copy baseline job is created and moved to a running state, the services code for creating the associated data should start immediately. 

STEPS TO REPRODUCE

This example uses the Create Baseline job (and P6 Professional to initiate the job), but can also be simulated with copy/paste project and copy baseline (as well as initiating the job from other P6 EPPM modules).

1. Login to P6 Professional
2. Open a project
3. Browse to Project > Maintain Baseline
4. Click Add
5. Choose option to save copy of project as a baseline
6. Click OK

After the job is submitted, the delay can be observed when monitoring the log file as noted above.  Also, when the JOBSVC row has been created and first moves to a running state, note the timestamp from the JOBSVC.update_date column (before it moves to a completed status) and compare to the time the "calling stored procedure" message is written to the log to determine delay.

Changes

 This issue occurs when running p6 services through the p6services.jar deployment.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.