Error in Run SQL Script sspm_ins_aux.sql : DatabaseToolException (The ALTER TABLE Statement Conflicted With the FOREIGN KEY Constraint "Fk_taskrsrc_rsrccurv". the Conflict Occurred in Database "PMDB", Table "dbo.RSRCCURV", Column 'Curv_id'
(Doc ID 2095074.1)
Last updated on SEPTEMBER 09, 2020
Applies to:Primavera P6 Enterprise Project Portfolio Management - Version 188.8.131.52 and later
Information in this document applies to any platform.
When attempting to migrate a database using the migrate.bat (.sh) utility, the following error occurs:
(Error in Run SQL Script sspm_ins_aux.sql : DatabaseToolException (The ALTER TABLE statement conflicted with the FOREIGN KEY constraint "fk_taskrsrc_rsrccurv". The conflict occurred in database "PMDB", table "dbo.RSRCCURV", column 'curv_id'.)
The issue can be reproduced at will with the following steps:
1. Upgrade database to R15.2
2. Run the migrate.bat file from the P6 15.2 installation files
3. During the wizard, error message is thrown and will not proceed
Due to this issue, users cannot migrate the database for P6.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document