Error: 'SQL Script orppm_ins_aux.sql : DatabaseToolException (ORA-02298:cannot validate admuser.FK_XXXX_XXXX) - parent keys not found)' When Migrating A Database To Oracle (Doc ID 1507136.1)

Last updated on JUNE 29, 2016

Applies to:

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

Symptoms

When attempting to migrate a P6 database to Oracle, the following error occurs.

ERROR
-----------------------
SQL Script orppm_ins_aux.sql :  DatabaseToolException (ORA-02298:cannot validate admuser.FK_XXXX_XXXX) - parent keys not found)

The error message will be specific to an actual constraint the migration process failed on.

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