My Oracle Support Banner

Oracle Data Import Failing With Error: ORA-02298: cannot validate (<SchemaName>.R_152) - parent keys not found (Doc ID 2484410.1)

Last updated on JULY 11, 2019

Applies to:

Oracle Health Sciences InForm - Version 4.6.0 and later
Information in this document applies to any platform.

Symptoms

Oracle data dump import failing with below errors:

ORA-02298: cannot validate (<SchemaName>.R_152) - parent keys not found
Failing sql is:
ALTER TABLE "<SchemaName>"."PF_CONTEXTSTATEHISTORY" ADD CONSTRAINT "R_152" FOREIGN KEY ("CONTEXTID", "CONTEXTREVISIONNUMBER") REFERENCES "<SchemaName>"."PF_REVISIONHISTORY" ("DBUID", "REVISIONNUMBER") ENABLE
ORA-39083: Object type REF_CONSTRAINT failed to create with error:
ORA-02298: cannot validate (<SchemaName>.R_153) - parent keys not found
Failing sql is:
ALTER TABLE "<SchemaName>"."PF_SVECPSTATEHISTORY" ADD CONSTRAINT "R_153" FOREIGN KEY ("PAGEHISTORYID", "PAGEHISTORYREVISIONNUMBER") REFERENCES "<SchemaName>"."PF_REVISIONHISTORY" ("DBUID", "REVISIONNUMBER") ENABLE
ORA-39083: Object type REF_CONSTRAINT failed to create with error:
ORA-02298: cannot validate (<SchemaName>.R_180) - parent keys not found
Failing sql is:
ALTER TABLE "<SchemaName>"."PF_CONTROLDATA" ADD CONSTRAINT "R_180" FOREIGN KEY ("CONTEXTID", "AUDITORDER", "INVALIDATINGREVISIONNUMBER") REFERENCES "<SchemaName>"."PF_ITEMDATA" ("CONTEXTID", "AUDITORDER", "INVALIDATINGREVISIONNUMBER") ENABLE
Processing object type SCHEMA_EXPORT/TABLE/TRIGGER

 

Changes

 Data export was taken from the trial while the study was running and active for UI access

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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.