My Oracle Support Banner

Copy Project and Copy Baseline Jobs Take 15+ Minutes in P6 Connected to a MS SQL Server Database (Doc ID 2836099.1)

Last updated on SEPTEMBER 27, 2022

Applies to:

Primavera P6 Professional Project Management - Version 19.12 to 19.12.18.1 [Release 19.12]
Primavera P6 Professional Project Management - Version 20.12 to 20.12.12.1 [Release 20.12]
Primavera P6 Professional Project Management - Version 21.12 to 21.12.2.0 [Release 21.12]
Primavera P6 Professional Project Management - Version 17.12.8.0 to 18.8.25.0 [Release 17.12 to 18.8]
Primavera P6 Enterprise Project Portfolio Management Cloud Service - Version 22.1 to 22.1 [Release 22.1]
Information in this document applies to any platform.

Symptoms

ACTUAL BEHAVIOR

Copying large projects or baselines with 10,000 or more Activities in P6 Professional connected to a Microsoft SQL Server database takes at least 15 minutes.

EXPECTED BEHAVIOR

The Copy process should take much less time to complete.

Changes

This issue is specific to MS SQL Server databases and has not been observed with Oracle databases.

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.