Error in DBService Log File Running TopVal: ORA-12899: value too large for column "TV_ISLANDS"."PARTITION_NAME" (Doc ID 2297301.1)

Last updated on SEPTEMBER 06, 2017

Applies to:

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

Symptoms

Error in DBService log file running TopVal
The database table tv_islands (as defined in ces_schema_ops.sql) is partition_name varchar2(40), whereas table partitions has filename varchar2(64).

ERROR
-- ORACLE ERROR -- OCI return code from OCIStmtExecute is OCI_ERROR
while processing command 'insert into TV_ISLANDS (model_mode,group_name,partition_name,class_name,object_cls,object_idx,description) values (:model_mode,:group_name,:partition_name,:class_name,:object_cls,:object_idx,:description);'
ORA-12899: value too large for column "NMS_TST"."TV_ISLANDS"."PARTITION_NAME" (actual: 41, maximum: 40)
parse offset = 140[partition_name,:cla]
08/14/17 16:06:12: 0x8,ctp=0x0000000100206c58,"sql" sql error: (insert into TV_ISLANDS (model_mode,group_name,partition_name,class_name,object_cls,object_idx,description) values (:model_mode,:group_name,:partition_name,:class_name,:object_cls,:object_idx,:description);) from (1/101:24434.0), result=-1 ORA-12899: value too large for column "NMS_TST"."TV_ISLANDS"."PARTITION_NAME" (actual: 41, maximum: 40)

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