Error: The ALTER TABLE statement conflicted with the FOREIGN KEY constraint "fk_actvtype_project" When Trying To Migrate A P6 EPPM 8.3 Database (Doc ID 1593875.1)

Last updated on JUNE 29, 2016

Applies to:

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

Symptoms

Received the following error while migrating the database.
-----------------------
Error in Run SQL Script sspm_ins_aux.sql : DatabaseToolException (The ALTER TABLE statement conflicted with the FOREIGN KEY constraint "fk_actvtype_project". The conflict occurred in database "PMDB83", table "dbo.PROJECT", column 'proj_id'.)

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms