Error "Error in Run SQL Script orppm_ins_aux.sql : DatabaseToolException (ORA-02298:cannot validate (ADMUSER.FK_XXX_XXX) - parent keys not found) " When Migrating A P6 EPPM Database Using The P6 PPM Migrate.bat Utility (Doc ID 1399709.1)

Last updated on JUNE 29, 2016

Applies to:

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

Symptoms

When attempting to migrate a P6 EPPM database using the migrate.bat utility, the following error occurs:

ERROR
-----------------------
Error in Run SQL Script orppm_ins_aux.sql : DatabaseToolException (ORA-02298:cannot validate (ADMUSER2.FK_JOBLOG_JOBSVC) - parent keys not found)

Note the script called: orPPM_xxx.sql.

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