Error “ORA-02291: integrity constraint In Network Intelligence Application (Doc ID 2004930.1)

Last updated on FEBRUARY 26, 2019

Applies to:

Symptoms

The error “ORA-02291: integrity constraint (NI_CORE.PORT_EQUIP_HOLDER_FK) violated - parent key not found” is encountered during a delete operation.

The following sequence of events occurred:

The equipment TERMAAAA/AAA64/001 is the z point of the trail CCCCCCCC/TERMAAAA/S4T/000001 and the trail TERMAAAA/VVVVVVV/S4T/000001, these trails utilize two different ports of the same equipment. These trails have all the channels available and they are in Pending Add status.
In the inventory system, for these trails there were the following changes:
• The status changed from “Pending Add” to “In Effect”;
• Deletion of the trail CCCCCCCC/TERMAAAA/S4T/000001 that was routed on the port A.E.09.A1/37-01; T/10G/001 of the equipment TERMAAAA/AAA64/001;
• Routing change of the trail TERMAAAA/VVVVVVV/S4T/000001 replacing the utilized port TERMAAAA/AAA64/001; A.E.09.A1/21-01;T/10G/001 with the port TERMAAAA/AAA64/001; A.E.09.A1/37-01; T/10G/001;
• Deletion of the port TERMAAAA/AAA64/001; A.E.09.A1/21-01;T/10G/001 ;

During the delta data loader, This was what happened on NL:
• Status change for the trail TERMAAAA/VVVVVVV/S4T/000001;
• Deletion of the trail CCCCCCCC/TERMAAAA/S4T/000001;
• Routing change of the trail TERMAAAA/VVVVVVV/S4T/000001 replacing the port TERMAAAA/AAA64/001; A.E.09.A1/21-01;T/10G/001 with the port TERMAAAA/AAA64/001; A.E.09.A1/37-01; T/10G/001;
• The deletion of the port TERMAAAA/AAA64/001; A.E.09.A1/21-01;T/10G/001 has not been done with an error on the table ERR$_PORT;”

Changes

Cause

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