How to resolve ORA-12899 related error.
Article ID: KB0083938
Updated On:
| Products | Versions |
|---|---|
| TIBCO API Exchange Gateway | - |
Description
Error:
>>>>
Message: java.lang.RuntimeException: java.sql.SQLException: ORA-12899: value too large for column "ASG_TRANSACTIONS"."TRN_ERROR_MESSAGE"(actual: 2267, maximum: 2048)
<<<<
This error is being reported as the error message is too big for the TRN_ERROR_MESSAGE column.
In APIX, the Oracle script creates this column with a size of 2048 and data-type as VARCHAR2:
TRN_ERROR_MESSAGE VARCHAR2(2048),
To resolve, increase the column size.
>>>>
Message: java.lang.RuntimeException: java.sql.SQLException: ORA-12899: value too large for column "ASG_TRANSACTIONS"."TRN_ERROR_MESSAGE"(actual: 2267, maximum: 2048)
<<<<
This error is being reported as the error message is too big for the TRN_ERROR_MESSAGE column.
In APIX, the Oracle script creates this column with a size of 2048 and data-type as VARCHAR2:
TRN_ERROR_MESSAGE VARCHAR2(2048),
To resolve, increase the column size.
Issue/Introduction
When reporting central logger related error, APIX throws a DB related error as the complete error is not being logged due to short column size of TRN_ERROR_MESSAGE.
Environment
All
Resolution
The size of the VARCHAR2 column can be set up to 4000. You can increase TRN_ERROR_MESSAGE VARCHAR2 up to 4000. Increasing the TRN_ERROR_MESSAGE column size resolves this issue.
Additional Information
http://stackoverflow.com/questions/9156019/ora-01461-can-bind-a-long-value-only-for-insert-into-a-long-column-occurs-when
Feedback
Yes
No
Powered by
