Model Config Generator Creates SSM SQL File with Square Braces ("[") in the SYMB_STATE_CLASS Number
Last updated on MARCH 02, 2017
Applies to:Oracle Network Management for Utilities - DMS - Version 126.96.36.199.0 to 188.8.131.52.0 [Release 2.3]
Oracle Utilities Network Management System - Version 184.108.40.206.0 to 220.127.116.11.0 [Release 2.3]
Information in this document applies to any platform.
On : 18.104.22.168.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:
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
Million Knowledge Articles and hundreds of Community platforms