Error: The ALTER TABLE statement conflicted with the FOREIGN KEY constraint "fk_actvtype_project" When Trying To Migrate A P6 EPPM 8.3 Database
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.
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'.)
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