My Oracle Support Banner

ORA-02292: IntegrityConstraintViolationException on Deleting Element from Network Elements. (Doc ID 2392006.1)

Last updated on MAY 24, 2022

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 screen and gives the below ERROR, 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. 



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

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