Redesigning Pending Virtual Circuits is Not Removing Rows in NS_CON_REL Table

(Doc ID 2224074.1)

Last updated on JANUARY 19, 2017

Applies to:

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

Symptoms

PROBLEM STATEMENT

The schematic redesign process for a pending virtual circuit is leaving old NS_CON_REL rows in the MSS database.

In looking at the data in the NS_CON_REL table for the redesigned pending virtual circuit, the table still shows a bandwidth facility that the virtual is no longer assigned to.
When the VC is redesigned, some but not all of the NS_CON_REL rows are removed from the database.
All rows should have been removed.

Release: MSS 621.804.b3

STEPS

1. Open a VC in Pending status that was provisioned
2. Verify in the database - table ASAP.NS_CON_REL the connections that the VC is riding
3. Go to the Schematic Diagram page

4. Hit the Redesign link
5. Save as Current Issue
6. Close and reopen VC

7. Look in the database, table ASAP.NS_CON_REL shows the VC riding the connections that are not part of its path.

EXPECTED BEHAVIOR

When we reassign the bandwidths to the virtual, the schematic design should show the proper assignments and not the ones that are no longer assigned to.
The NS_CON_REL rows in the pending assignment should be removed when a Redesign is effected.

BUSINESS IMPACT

This is impacting our Network Provisioning integration as it is pulling in extra rows that do not belong.



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