Users Cannot Save Changes to Text Fields and the Error ORA-12899: "Value Too Large For Column" Appears in DBService, TCDBService or MBDBService Logs (Doc ID 2057836.1)

Last updated on NOVEMBER 09, 2016

Applies to:

Oracle Utilities Network Management System - Version 1.11.0.4 to 1.12.0.2 [Release 1.11 to 1.12]
Oracle Network Management for Utilities - DMS - Version 1.11.0.4 to 1.12.0.2 [Release 1.11 to 1.12]
Information in this document applies to any platform.

Symptoms

After making a change to a text field in Web Workspace and pressing Save, the save fails but the operator gets no indicator as to why.

At the same time as the attempted save, the error "ORA-12899: value too large for column [database].[table name].[column name]" (actual: ###, maximum: ###)  appears in one of the DBService logs (most likely TCDBService)


ERROR
-----------------------

ORA-12899: value too large for column [database].[table name].[column name]

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