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

STEPS

The issue can be reproduced with the following steps:

  1. Remove all associated equipment and circuits from the SONET network system.
  2. Right-click a component and choose Delete option
  3. MSS throws the error message 3 times.

BUSINESS IMPACT

Users are unable to remove network system from service, and cannot re-use the same system ID.


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