My Oracle Support Banner

P6 Professional Scheduling Hangs While a Project Copy Job Is Running on a SQL Server Database (Doc ID 2456104.1)

Last updated on NOVEMBER 18, 2019

Applies to:

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

Symptoms

ACTUAL BEHAVIOR

In P6 Professional connected to a SQL Server database, when a large project is being copied (copy/paste operation), if the user Schedules a different project, the Project Schedule job does not start until the project copy operation, completes due to an exclusive lock on the database by the copy/paste procedure.

EXPECTED BEHAVIOR

The Schedule Project job should run while the project copy job is running.


The issue can be reproduced at will using the following steps

  1. Log into P6 Professional.
  2. Copy/paste a large project.
  3. Schedule a different project.
  4. The Schedule job remains in Pending status until the copy/paste completes.

Changes

 

Cause

To view full details, 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 a vibrant support community of peers and Oracle experts.