Values Entered into TXTF_EMERG_SW_ORDER in EVENT_DETAILS Is Too Large
(Doc ID 2390601.1)
Last updated on MARCH 26, 2019
Applies to:Oracle Utilities Network Management System - Version 220.127.116.11 to 18.104.22.168.0 [Release 1.12 to 2.3]
Oracle Network Management for Utilities - DMS - Version 22.214.171.124 to 126.96.36.199.0 [Release 1.12 to 2.3]
Information in this document applies to any platform.
Values entered into TXTF_EMERG_SW_ORDER in EVENT_DETAILS is too large
A user is trying to update an event that had 5 switching sheets ran against it. When the user tries to update the event, it gives an error.
A jbot_report shows the values in the DS_EVENT_DETAILS of ",,EMERG_SW_ORDER_TEXT,,java.lang.String,Emer 15036,Emer 15038,Emer 15040,Emer 15037,Emer 15039",
but the PICKLIST_INFO_UP_TR table has nothing saved in the EMERG_SW_ORDER_TEXT field
04/17/18 13:01:15: JMService 0x7fde99a86700,ctp=0x57a156b8,"JMService::updateEventData" *ERROR* - sql failed:
result=-1 error='ORA-12899: value too large for column "NMS"."PICKLIST_INFO_UPD_TR"."EMERG_SW_ORDER_TEXT" (actual: 54, maximum: 32)
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