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 MARCH 22, 2022
Applies to:
Primavera P6 Professional Project Management - Version 16.1.0.0 and laterPrimavera 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:
- Launch <P6 version>\database\migrate.bat.
- Select to perform a SQL Server to SQL Server Migration.
- Enter the source and target database information.
- 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 |