MSS 6.2.1 | Custom Attributes Are Not Honoring Dependencies When Setting Defaults (Doc ID 2978917.1)

Last updated on OCTOBER 16, 2023

Applies to:

Symptoms

MSS 6.2.1 version, Custom Attribute | Connection Design

We have a gating attribute that determines which attributes are specified for an EVC connection. If the Carrier Ethernet custom attribute is set to "Yes," many attributes are available. Most of these have defaults. But they should only be defaulted if the attributes actually exist for the connection spec, which is based on the Carrier Ethernet custom attribute being set to "Yes."

 If the Carrier Ethernet custom attribute is set to "No", there are very few attributes available. The problem is when the Carrier Ethernet attribute is set to "No", the defaults for the attributes that should only apply if Carrier Ethernet is set to "Yes" are being set and stored in the database.

These attributes do not show up on the window and do not apply unless Carrier Ethernet is set to "Yes".


This is corrupting data in our database because now we have a bunch of rows that do not apply to this connection spec that are being stored in tables ASAP.CONN_CA_VALUE and ASAP.DESIGN_CONN_CA_VALUE.  



EXPECTED BEHAVIOR :

When the CA “Carrier Ethernet” is set as “No” for a EVC type circuit only the CAs which are setup to be visible on its value (i.e No) should appear in the asap.conn_ca_value table .
Even though the unrelated CAs are not visible on the GUI , they are causing data-corruption by this behavior.


STEPS

The issue can be reproduced using  the following steps:

1. Check the CA "Carrier Name" set up in tbs_utls.exe. Notice that it will come up when the value of CA "Carrier Ethernet" is set to NO, in Connection of EVC type.
2. Make a new EVC type connection.
3-Open it in Connection design. Go to Properties >> Custom Attributes
4- See that CAs.
    Carrier Ethernet=No and Carrie Name are only appearing on the screen.
5-Save the current Issue of the EVC.
6-Log-in to DB and run the following SQL:

In the results, we see that there are many CAs values which are coming even though the Carrier Ethernet CA is Set to “NO”. They are supposed to show up when its value is set to "YES".

Cause

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