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 SEPTEMBER 09, 2020

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

Due to this issue, users cannot migrate the database for P6.

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!


In this Document
Symptoms
Cause
Solution


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