When saving Changes after Removing Node From SONET Module an Error pops up stating a Child Assignment exists and throws SQLIntegrityConstraintViolationException: ORA-02292 error
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.
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.
sqlerror:1 java.sql.SQLIntegrityConstraintViolationException: ORA-02292
ORA-02292: integrity constraint (ASAP.FK_PO_AD__NS_CO) violated - child record found
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.
Users are unable to remove network system from service, and cannot re-use the same system ID.
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