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 22, 2022
Applies to:
Primavera P6 Professional Project Management - Version 8.4.0.0 and laterInformation in this document applies to any platform.
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:
- Launch <P6 version>\database\migrate.bat.
- Select to perform a SQL Server to SQL Server Migration.
- Enter the source and target database information.
- Observe migration process fails with the reported error in the 3rd Step.
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 |