How to resolve the error, "java.sql.SQLException: ORA-12899: value too large for column.." with Common-Logger(asg-cl) component.

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.

Additional Information

http://supportapps.tibco.com/jr/ASG/ASG-4190.htm
http://supportapps.tibco.com/jr/ASG/ASG-5689.htm