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 to [Release 11g]
Information in this document applies to any platform.
***Checked for relevance on 05-November-2013***


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(
        at oracle.jdbc.driver.OracleStatementWrapper.executeBatch(
        at weblogic.jdbc.wrapper.PreparedStatement.executeBatch(
        at com.bea.wli.reporting.jmsprovider.runtime.MDBBatch.beforeCompletion(
        at weblogic.transaction.internal.ServerSCInfo$
        at weblogic.transaction.internal.ServerSCInfo.doBeforeCompletion(
        at weblogic.transaction.internal.ServerSCInfo.callBeforeCompletions(
        at weblogic.transaction.internal.ServerSCInfo.startPrePrepareAndChain(
        at weblogic.transaction.internal.ServerTransactionImpl.localPrePrepareAndChain(
        at weblogic.transaction.internal.ServerTransactionImpl.globalPrePrepare(
        at weblogic.transaction.internal.ServerTransactionImpl.internalCommit(
        at weblogic.transaction.internal.ServerTransactionImpl.commit(
        at weblogic.ejb.container.internal.MDListener.execute(
How to resolve this problem without changing the language environment?


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

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