My Oracle Support Banner

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:

Primavera P6 Professional Project Management - Version 8.4.0.0 and later
Information 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:

  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

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.