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 13, 2023
Applies to:
Oracle Life Sciences InForm - Version 4.6.0 and laterInformation 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
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 |