My Oracle Support Banner

Error 'Error in Run SQL Script sspm_ins_aux.sql: DatabaseToolException (The ALTER TABLE statement conflicted with the FOREIGN KEY constraint "fk_obsproj_obs")' When Running Migrate.bat (Doc ID 2482716.1)

Last updated on JULY 25, 2019

Applies to:

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

Symptoms

When migrating a P6 database using the migrate.bat database utility, the following errors is observed:

Error in Run SQL Script sspm_ins_aux.sql: DatabaseToolException ( The ALTER TABLE statement conflicted with the FOREIGN KEY constraint "fk_obsproj_obs". The conflict occurred in database "PMDB", table dbo.OBS", column 'obs_id'.)
for query:: ALTER TABLE OBSPROJ
ADD CONSTRAINT fk_obsproj_obs FOREIGN KEY (obs_id)
REFERENCE OBS(obs_id) ON DELETE CASCADE

 

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. Migration process fails with the reported error.

Changes

 

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
Changes
Cause
Solution
References

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