Saving A Modified Network System Throws The Error Java.sql.SQLIntegrityConstraintViolationExcepti (Doc ID 2060851.1)

Last updated on SEPTEMBER 29, 2015

Applies to:

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

Symptoms

On : 6.2.1 version, Engineering

Saving this modified network system throws the error java.sql.SQLIntegrityConstraintViolationExcepti


ERROR
-----------------------

error java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (ASAP.PK_NS_CON_LABEL_CKT) violated.




STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1. Create a EWO order with one LAG circuit and two Unassignable Bandwidth circuits

2. Assign the Parent LAG circuit and the child unassignable bandwidth circuit in the network and save the network system.

3. Now again open the same network system and unassociate the child unassignable bandwidth from the parent LAG.

4. Assign a different child unassignable bandwidth circuit.

5. Save the Network System and while saving the network system, the above reported constraint error occurs


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot design circuits or systems of circuits.

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