How to resolve the error, "java.sql.SQLException: ORA-12899: value too large for column.." with Common-Logger(asg-cl) component.
book
Article ID: KB0085101
calendar_today
Updated On:
Products
Versions
TIBCO API Exchange
-
Not Applicable
-
Description
Description: The common logger component for TIBCO API Exchange Gateway throws the sample error below:
Message:
java.lang.RuntimeException: java.lang.RuntimeException:
java.sql.SQLException: ORA-12899: value too large for column
"TIBCOASG"."ASG_TRANSACTIONS"."TRN_TARGET_OPERATION" (actual: 33,
maximum: 32)
or
com.tibco.cep.runtime.model.exception.impl.BEExceptionImpl:
java.lang.RuntimeException: java.lang.RuntimeException:
com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for
column 'THM_MESSAGE' at row 1
Symptoms: The transactions sent to asg-cl are not logged into the database.
Cause: The scripts shipped with TIBCO API Exchange Gateway(APIX-G) 2.x and lower versions, have smaller values for length of certain columns related to asg-cl.
Resolution
The scripts shipped with APIX-G 2.1.0 have been updated and should to be used to create Common-Logger tables. If the data is still large, the tables can be altered as required by increasing the column(s) size(s).
Issue/Introduction
How to resolve the error, "java.sql.SQLException: ORA-12899: value too large for column.." with Common-Logger(asg-cl) component.