SQL Error Code 000012899 Occurs When Updating Case Status Description With Multi-Byte Character (Doc ID 1076305.1)

Last updated on OCTOBER 18, 2016

Applies to:

Oracle Utilities Customer Care and Billing - Version: 2.2.0 and later   [Release: 2.2 and later ]
Information in this document applies to any platform.

Symptoms

When attempting to create or update a Case Status description with a Chinese (or any Multi-Byte) Character, errors similar to the following error occur:

Pop-up Error:
"SQL Error code 000012899 occurred in module CIPTCSTR:XQ100 LANG CHANGE"


Log Error:
SYSUSER - 079647-215-1 2010-03-03 11:01:59,375 [Parent Reader:Thread-24] ERROR (support.cobol.DBLocalCobolSQLProcessBackend) SQL Error encountered sql
Code=12899, sqlState=72000 (ORA-12899: value too large for column "CISADM"."CI_CASE_STATUS_L"."STATUS_LBL" (actual: 64, maximum: 60)
) with SQL:
    'UPDATE CI_CASE_STATUS_L SET DESCR254 = ?, STATUS_LBL = ?, VERSION = ?, LANGUAGE_CD = ?, CASE_STATUS_CD = ?, CASE_TYPE_CD = ? WHERE CASE_TYPE_CD
= ? AND CASE_STATUS_CD = ? AND LANGUAGE_CD = ?' with bind parameters:
Parameter 1 (String)'Use this status to indicate that a customer at this premise has diverted service in the past.'
Parameter 2 (Char)'                                                         '
Parameter 3 (Integer)'2'
Parameter 4 (Char)'ENG'
Parameter 5 (Char)'DIVERSION   '
Parameter 6 (Char)'CI_PREM_NOTE'
Parameter 7 (Char)'CI_PREM_NOTE'
Parameter 8 (Char)'DIVERSION   '
Parameter 9 (Char)'ENG'
with last row return values:

java.sql.SQLException: ORA-12899: value too large for column "CISADM"."CI_CASE_STATUS_L"."STATUS_LBL" (actual: 64, maximum: 60)

       at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70)
       at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:131)
       at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:204)
       at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)
       at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413)
       at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1034)
       at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:194)
       at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:953)
       at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1222)
       at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3387)
       at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3468)
       at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1062)
       at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:105)
       at com.splwg.base.support.cobol.DBLocalCobolSQLProcessBackend.executeSQLUpdate(DBLocalCobolSQLProcessBackend.java:828)
       at com.splwg.base.support.cobol.DBLocalCobolSQLProcessBackend.doSQLUpdate(DBLocalCobolSQLProcessBackend.java:422)
       at com.splwg.base.support.cobol.host.command.SimpleCobolSQLCommand.invoke(SimpleCobolSQLCommand.java:122)
       at com.splwg.base.support.cobol.host.PerformCommandExecuter.invoke(PerformCommandExecuter.java:68)
       at com.splwg.base.support.cobol.host.OptimizedRemoteExecuterSkel$RequestSocketReader.readRequestExecuteAndRespond(OptimizedRemoteExecuterSkel.
java:157)
       at com.splwg.base.support.cobol.host.OptimizedRemoteExecuterSkel$RequestSocketReader.run(OptimizedRemoteExecuterSkel.java:91)
       at com.splwg.base.support.cobol.host.SocketThreadPool$WrappingParentRunnable.run(SocketThreadPool.java:204)
       at EDU.oswego.cs.dl.util.concurrent.PooledExecutor$Worker.run(Unknown Source)
       at java.lang.Thread.run(Thread.java:595)
SYSUSER - 079647-215-1 2010-03-03 11:01:59,375 [Remote JVM:3 Thread 1] INFO  (COBOL.CIPTCSTR) ====================================
SYSUSER - 079647-215-1 2010-03-03 11:01:59,375 [Remote JVM:3 Thread 1] INFO  (COBOL.CIPTCSTR) SQL error in CIPTCSTR
SYSUSER - 079647-215-1 2010-03-03 11:01:59,375 [Remote JVM:3 Thread 1] INFO  (COBOL.CIPTCSTR) 2010-03-03-11.01.58  User : SYSUSER
SYSUSER - 079647-215-1 2010-03-03 11:01:59,375 [Remote JVM:3 Thread 1] INFO  (COBOL.CIPTCSTR)
SYSUSER - 079647-215-1 2010-03-03 11:01:59,375 [Remote JVM:3 Thread 1] INFO  (COBOL.CIPTCSTR) Update error: U_LANGROW
SYSUSER - 079647-215-1 2010-03-03 11:01:59,375 [Remote JVM:3 Thread 1] INFO  (COBOL.CIPTCSTR) 000012899 ->
SYSUSER - 079647-215-1 2010-03-03 11:01:59,375 [Remote JVM:3 Thread 1] INFO  (COBOL.CIPTCSTR) SQLCAID =>
SYSUSER - 079647-215-1 2010-03-03 11:01:59,375 [Remote JVM:3 Thread 1] INFO  (COBOL.CIPTCSTR) SQLCABC =>
SYSUSER - 079647-215-1 2010-03-03 11:01:59,375 [Remote JVM:3 Thread 1] INFO  (COBOL.CIPTCSTR) SQLCODE => \u0000\u00002c
SYSUSER - 079647-215-1 2010-03-03 11:01:59,375 [Remote JVM:3 Thread 1] INFO  (COBOL.CIPTCSTR) SQLERRML =>
SYSUSER - 079647-215-1 2010-03-03 11:01:59,375 [Remote JVM:3 Thread 1] INFO  (COBOL.CIPTCSTR) SQLERRMC => ORA-12899: value too large for column "CISAD
M"."CI_CASE_STATUS_L"."STA
SYSUSER - 079647-215-1 2010-03-03 11:01:59,390 [Remote JVM:3 Thread 1] INFO  (COBOL.CIPTCSTR) SQLERRP =>
SYSUSER - 079647-215-1 2010-03-03 11:01:59,390 [Remote JVM:3 Thread 1] INFO  (COBOL.CIPTCSTR) SQLERRD(1) =>
SYSUSER - 079647-215-1 2010-03-03 11:01:59,390 [Remote JVM:3 Thread 1] INFO  (COBOL.CIPTCSTR) SQLERRD(2) =>
SYSUSER - 079647-215-1 2010-03-03 11:01:59,390 [Remote JVM:3 Thread 1] INFO
SYSUSER - 079647-215-1 2010-03-03 11:01:59,390 [Remote JVM:3 Thread 1] INFO  (COBOL.CIPTCSTR) SQLERRD(3) => \u0000\u0000\u0000´ú┐
SYSUSER - 079647-215-1 2010-03-03 11:01:59,390 [Remote JVM:3 Thread 1] INFO  (COBOL.CIPTCSTR) SQLERRD(4) =>
SYSUSER - 079647-215-1 2010-03-03 11:01:59,390 [Remote JVM:3 Thread 1] INFO  (COBOL.CIPTCSTR) SQLERRD(5) =>
SYSUSER - 079647-215-1 2010-03-03 11:01:59,390 [Remote JVM:3 Thread 1] INFO  (COBOL.CIPTCSTR) SQLERRD(6) =>
SYSUSER - 079647-215-1 2010-03-03 11:01:59,390 [Remote JVM:3 Thread 1] INFO  (COBOL.CIPTCSTR) SQLWARN0 =>
SYSUSER - 079647-215-1 2010-03-03 11:01:59,390 [Remote JVM:3 Thread 1] INFO  (COBOL.CIPTCSTR) SQLWARN1 =>
SYSUSER - 079647-215-1 2010-03-03 11:01:59,390 [Remote JVM:3 Thread 1] INFO  (COBOL.CIPTCSTR) SQLWARN2 =>
SYSUSER - 079647-215-1 2010-03-03 11:01:59,390 [Remote JVM:3 Thread 1] INFO  (COBOL.CIPTCSTR) SQLWARN3 =>
SYSUSER - 079647-215-1 2010-03-03 11:01:59,390 [Remote JVM:3 Thread 1] INFO  (COBOL.CIPTCSTR) SQLWARN4 =>
SYSUSER - 079647-215-1 2010-03-03 11:01:59,390 [Remote JVM:3 Thread 1] INFO  (COBOL.CIPTCSTR) SQLWARN5 =>
SYSUSER - 079647-215-1 2010-03-03 11:01:59,390 [Remote JVM:3 Thread 1] INFO  (COBOL.CIPTCSTR) SQLWARN6 =>
SYSUSER - 079647-215-1 2010-03-03 11:01:59,390 [Remote JVM:3 Thread 1] INFO  (COBOL.CIPTCSTR) SQLWARN7 =>
SYSUSER - 079647-215-1 2010-03-03 11:01:59,406 [Remote JVM:3 Thread 1] INFO  (COBOL.CIPTCSTR) ====================================



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