My Oracle Support Banner

OSB 11g - How To Trim the Fault Message to Avoid ORA-12899 Exception When Using Report Action (Doc ID 1391573.1)

Last updated on JULY 30, 2018

Applies to:

Oracle Service Bus - Version 11.1.1.4.0 to 11.1.1.7.0 [Release 11g]
Information in this document applies to any platform.
***Checked for relevance on 05-November-2013***

Goal

If we are using a Report action and the language environment of OSB is not English, we may get an exception " ORA-12899: value too large" when the fault message is too long. For example:
<Jul 15, 2014 11:28:04 AM PET> <Error> <OSB-Reporting> <BEA-473518> <An error occurred while inserting data into the Reporting Table with a batch update java.sql.BatchUpdateException: ORA-12899: value too large for column "DEV_SOAINFRA"."WLI_QS_REPORT_ATTRIBUTE"."ERROR_REASON" (actual: 1025, maximum: 1024)
java.sql.BatchUpdateException: ORA-12899: value too large for column "DEV_SOAINFRA"."WLI_QS_REPORT_ATTRIBUTE"."ERROR_REASON" (actual: 1025, maximum: 1024)
        at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:13349)
        at oracle.jdbc.driver.OracleStatementWrapper.executeBatch(OracleStatementWrapper.java:248)
        at weblogic.jdbc.wrapper.PreparedStatement.executeBatch(PreparedStatement.java:210)
        at com.bea.wli.reporting.jmsprovider.runtime.MDBBatch.beforeCompletion(MDBBatch.java:122)
        at weblogic.transaction.internal.ServerSCInfo$CallBeforeCompletionsAction.run(ServerSCInfo.java:1670)
        at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:363)
        at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:146)
        at weblogic.transaction.internal.ServerSCInfo.doBeforeCompletion(ServerSCInfo.java:1240)
        at weblogic.transaction.internal.ServerSCInfo.callBeforeCompletions(ServerSCInfo.java:1219)
        at weblogic.transaction.internal.ServerSCInfo.startPrePrepareAndChain(ServerSCInfo.java:121)
        at weblogic.transaction.internal.ServerTransactionImpl.localPrePrepareAndChain(ServerTransactionImpl.java:1355)
        at weblogic.transaction.internal.ServerTransactionImpl.globalPrePrepare(ServerTransactionImpl.java:2172)
        at weblogic.transaction.internal.ServerTransactionImpl.internalCommit(ServerTransactionImpl.java:300)
        at weblogic.transaction.internal.ServerTransactionImpl.commit(ServerTransactionImpl.java:267)
        at weblogic.ejb.container.internal.MDListener.execute(MDListener.java:617)
How to resolve this problem without changing the language environment?

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.