My Oracle Support Banner

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 MARCH 22, 2022

Applies to:

Primavera P6 Enterprise Project Portfolio Management - Version 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

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