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 220.127.116.11 and later
Information in this document applies to any platform.
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.
The Schedule Project job should run while the project copy job is running.
The issue can be reproduced at will using the following steps
- Log into P6 Professional.
- Copy/paste a large project.
- Schedule a different project.
- The Schedule job remains in Pending status until the copy/paste completes.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!