My Oracle Support Banner

"nms-setup" and ODLoad do not Update Fields if New or Previous Values are Null (Doc ID 2926296.1)

Last updated on FEBRUARY 06, 2023

Applies to:

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

Symptoms

On : 2.5.0.1.0 version, NMS Infrastructure

It was noticed that after adding non-zero text to an existing attribute, running nms-post-setup did not populate the ATTRIBUTES.NON_ZERO_TEXT field.
Running ODLoad directly did not populate the field either.

It was discovered that this behavior could happen in a number of spots in the sql files that are run by the nms-post-setup script.

nms-post-setup should be updating all fields correctly, regardless of whether the existing or new values are null.


The issue can be reproduced at will with the following steps, on any OPAL model:

  1. Create a new file ~/sql/OPAL_attributes.dat, and add a new attribute to it:
    test_attribute 54 2 0 Test Attribute
  2. Run ODLoad to add the attribute
    ODLoad -a OPAL_attributes.dat
  3. Update the attributes table
    nms-post-setup
  4. Check the ATTRIBUTES table
    entry is added
  5. Edit ~/sql/OPAL_attributes.dat and add non_zero_text and zero_text
    test_attribute 54 2 0 Test Attribute|TEST1|TEST2
  6. Run ODLoad to update the zero and non-zero text:
    ODLoad -a OPAL_attributes.dat
  7. Update the attributes table
    nms-post-setup
  8. Check the ATTRIBUTES table
    zero_text and non_zero_text fields are not updated

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.