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 JULY 25, 2017

Applies to:

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

Symptoms

When attempting to migrate a database using the migrate.bat (.sh) utility, the following error occurs:

ERROR
-----------------------
(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'.)


STEPS
-----------------------
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

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot migrate the database for P6.

Changes

 

Cause

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 hundreds of Community platforms