IBM Support

IT10371: ERROR IN VISIBILITY.LOG JAVA.SQL.SQLEXCEPTION: ORA-12899: VALUE TOO LARGE FOR COLUMN

Subscribe to this APAR

By subscribing, you receive periodic emails alerting you to the status of the APAR, along with a link to the fix after it becomes available. You can track this item individually or track all items by product.

Notify me when this APAR changes.

Notify me when an APAR for this component changes.

 

APAR status

  • Closed as program error.

Error description

  • V5.2.5_2
    In visibility.log the following error message is reported:
    SQL Error Code: 12899
    SQL State: 72000
    java.sql.SQLException: ORA-12899: value too large for
    column"SBI"."ACT_SESSION"."ERROR_MSG" (actual: 278, maximum:
    255)
    
    at
    oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:445)
    at
    oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
    at
    oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:879)
    at
    oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:450)
    at
    oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:192)
    at
    oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)
    at
    oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedState
    ment.java:207)
    at
    oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPrepar
    edStatem
    ent.java:1044)
    at
    oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleSt
    atement.java:1329)
    at
    oracle.jdbc.driver.OraclePreparedStatement.executeInternal(Oracl
    ePreparedStatement.java:3584)
    at
    oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OracleP
    reparedStatement.java:3665)
    at
    oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(
    OraclePreparedStatementWrapper.java:1352)
    at
    sun.reflect.GeneratedMethodAccessor137.invoke(UnknownSource)
    at
    sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethod
    AccessorImpl.java:56)
    at
    java.lang.reflect.Method.invoke(Method.java:620)
    at
    com.sterlingcommerce.woodstock.mailbox.db.SQLWrapper.forwardMeth
    od(SQLWrapper.java:51)
    at
    com.sterlingcommerce.woodstock.mailbox.db.StatementWrapper.invok
    e(StatementWrapper.java:133)
    at
    com.sun.proxy.$Proxy12.executeUpdate(Unknown Source)
    at
    com.sterlingcommerce.woodstock.dmi.visibility.db.DmiVisEventWare
    houseQueue$1.body(DmiVisEventWarehouseQueue.java:427)
    at
    com.sterlingcommerce.woodstock.mailbox.db.DatabaseOperation._run
    InTransaction(DatabaseOperation.java:335)
    at
    com.sterlingcommerce.woodstock.mailbox.db.DatabaseOperation.runI
    nTransaction(DatabaseOperation.java:144)
    at
    com.sterlingcommerce.woodstock.dmi.visibility.db.DmiVisEventWare
    houseQueue.executeStatementsAsExecutor(DmiVisEventWarehouseQueue
    .java:345)
    at
    com.sterlingcommerce.woodstock.dmi.visibility.db.DmiVisEventWare
    houseQueue.run(DmiVisEventWarehouseQueue.java:319)
    at
    java.lang.Thread.run(Thread.java:801)
    

Local fix

Problem summary

  • Users Affected:
    All
    
    Problem Description:
    An SQL exception is written to the Visibility log when the
    length of the error text field in a DMI event exceeds the size
    of the SQL column.
    
    Platforms affected:
    All
    

Problem conclusion

  • Resolution Summary:
    A code fix has been provided. Error text is truncated to avoid
    the column overflow.
    
    Delivered In:
    5020500_8
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT10371

  • Reported component name

    STR B2B INTEGRA

  • Reported component ID

    5725D0600

  • Reported release

    524

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2015-07-30

  • Closed date

    2015-08-17

  • Last modified date

    2015-08-25

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

Fix information

  • Fixed component name

    STR B2B INTEGRA

  • Fixed component ID

    5725D0600

Applicable component levels

  • R525 PSY

       UP

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SS3JSW","label":"IBM Sterling B2B Integrator"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"5.2.4","Edition":"","Line of Business":{"code":"LOB02","label":"AI Applications"}}]

Document Information

Modified date:
25 August 2015