My Oracle Support Banner

nms-setup Does not Process nms_mycentricity.sql Correctly if Service Alert Sql Files Contain Ampersands (Doc ID 2857644.1)

Last updated on MARCH 22, 2022

Applies to:

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

Symptoms

On : 2.5.0.1.0 version,

Data from nms_mycentricity.sql is not populating correctly in the database.

It looks like when the nms_mycentricity.sql is applied as part of the setup, it is not processing the and characters correctly.

There should be no non-ascii characters in the MYC_CLIENT_TYPES_1 table.

The issue can be reproduced at will with the following steps:

1. Log into Service Alert Admin Tool.
2. Navigate to the Utility Customers tab.
3. Click on the Add Customer button (+ icon).
4. Select a customer in the Add Account dialog and press OK button.
5. Click on the Edit Customer button (pencil icon).
6. Open Client Type drop down list.

Expected result: Values that contain '&' character are displayed correctly.

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
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.