ORA-02292: IntegrityConstraintViolationException on Deleting Element from Network Elements.
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.
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.
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