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 to [Release 2.3]
Oracle Utilities Network Management System - Version to [Release 2.3]
Information in this document applies to any platform.


On : 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:


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

The generated ssm.sql file contained this:




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