My Oracle Support Banner

Redesigning Pending Virtual Circuits is Not Removing Rows in NS_CON_REL Table (Doc ID 2224074.1)

Last updated on OCTOBER 23, 2018

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

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
 PROBLEM STATEMENT
 STEPS
 EXPECTED BEHAVIOR
 BUSINESS IMPACT
Cause
Solution
 PATCH
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.