Data Relationship Management (DRM) Restoring Version From Backup File Error: "ORA-02291: integrity constraint (#####.FK_SECNODE03) violated - parent key not found" (Doc ID 2221574.1)

Last updated on JANUARY 17, 2017

Applies to:

Hyperion Data Relationship Management - Version 11.1.2.3.504 and later
Information in this document applies to any platform.

Symptoms

While restoring a version from a back up file the following error occurred:

DRM-11501: An error occurred in the following action: Insert command. This occurred during an array insert operation on table RM_Access_Group_Prop_Local. Number of rows processed 0. Error details:
ArrayIndex: 0; Message:ORA-24381: error(s) in array DML

ArrayIndex: 1; Message:ORA-02291: integrity constraint (DRM_DB.FK_SECNODE03) violated - parent key not found

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