ORA-02292: IntegrityConstraintViolationException on Deleting Element from Network Elements.

(Doc ID 2392006.1)

Last updated on APRIL 27, 2018

Applies to:

Oracle Communications MetaSolv Solution - Version 6.2.1 and later
Information in this document applies to any platform.

Symptoms


Unable to delete Element from Network Elements. It throws ORA-02292: IntegrityConstraintViolationException

Below screenshot is an example of an Element that can’t be deleted from Network Elements even though the associated circuit has been disconnected. In the Connection Summary screen, no elements are shown in the Network System section but the NS_CONNECTION table still show NS_COMP_ID_PARENT and NS_COMP_ID_CHILD populated that’s preventing the Element to be deleted.


 

Changes

 

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