Model Config Generator Creates SSM SQL File with Square Braces ("[") in the SYMB_STATE_CLASS Number (Doc ID 2236942.1)

Last updated on MARCH 02, 2017

Applies to:

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

Symptoms

On : 2.3.0.0.0 version, Data Model

If the Distribution Model Model Workbook (*_NMS_Distribution_Model.xlsm) has a nested DB Code lookup in the Symbology Enumerator column in any of these worksheets - Devices, Conditions, Customer & Service, Structures, Landbase, Annotation, Core Nodes -- the generated ssm.sql file will have a bad character in the symb_state_class value.

 

For example, the Symbology Enumerator column has following defined:

302[%symid.[BREAKER_SUB_TYPE]][%phase_num.[%phase_map.[^RWB^[PHASE]]]]

In this section, "[%symid.[BREAKER_SUB_TYPE]]", [BREAKER_SUB_TYPE] is the nested lookup.

The generated ssm.sql file contained this:



Changes

 

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms