When saving Changes after Removing Node From SONET Module an Error pops up stating a Child Assignment exists and throws SQLIntegrityConstraintViolationException: ORA-02292 error (Doc ID 2282862.1)

Last updated on JULY 03, 2017

Applies to:

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

Symptoms

PROBLEM STATEMENT

MSS Release: 6.2.1.b495 version, Engineering

Users are unable to remove node from SONET network system.

When saving a network system after removing a node, an error pops up stating a child assignment exists.
All associated equipment and circuits have been removed from service.
User is unable to delete the node and remove the system from service.

ERROR

sqlerror:1 java.sql.SQLIntegrityConstraintViolationException: ORA-02292

java.sql.SQLIntegrityConstraintViolationException:
ORA-02292: integrity constraint (ASAP.FK_PO_AD__NS_CO) violated - child record 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