My Oracle Support Banner

Removing Inline Cross-Phase Jumper on Fuse Results in Multiple Active Rows in ALIAS_MAPPING Table (Doc ID 2962474.1)

Last updated on JULY 26, 2023

Applies to:

Oracle Utilities Network Management System - Version 2.5.0.2.0 to 2.6.0.0.0 [Release 2.5 to 2.6]
Oracle Network Management for Utilities - DMS - Version 2.5.0.2.0 to 2.6.0.0.0 [Release 2.5 to 2.6]
Information in this document applies to any platform.

Symptoms

On : 2.5.0.0.0 version, NMS Infrastructure

We have four fuses in our model with active model edit flag set in the ALIAS_MAPPING table.

The particular fuses each have a pair of records in the ALIAS_MAPPING table, the most recent patch record has a ACTIVE column value of 'Y'; the prior patch record has an ACTIVE columns value of 'A'.

Removing an inline jumper from a fuse results in 2 rows in ALIAS_MAPPING - one active = 'Y' and one active = 'A'

EXPECTED BEHAVIOR
-----------------------
Only one active row should be in any core modeling table at a given time


The issue can be reproduced at will with the following steps:
1. Place an inline-cross-phase jumper on a fuse
2. Remove the jumper
3. Check the ALIAS_MAPPING table for rows for the fuse there will be two active rows.


Changes

 

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
Changes
Cause
Solution
 Fix Description
 Migration
References


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