DB Migration Fails "Error in run SQL script sspm_ins_aux : DatabaseToolException (the Alter table statement conflicted with the foreign key constraint "fk_project_matrix". the conflict occurred in database XX, table "dbo.riskscrmtx", column 'matrix_id' (Doc ID 2646921.1)

Last updated on MARCH 12, 2020

Applies to:

Symptoms

When migrating a P6 database From SQLServer 2014 to SQLServer 2016 using the migrate.bat database utility, the following errors is observed:

ERROR
-----------------------
Error in run SQL script sspm_ins_aux : DatabaseToolException (the Alter table statement conflicted with the foreign key constraint "fk_project_matrix". the conflict occurred in database XX, table "dbo.riskscrmtx", column 'matrix_id'

The issue can be reproduced at will with the following steps:

1. Launch <P6 version>\database\migrate.bat.
2. Select to perform a SQL Server to SQL Server Migration.
3. Enter the source and target database information.
4. Observe migration process fails with the reported error in the 3rd Step.

Cause

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