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

si_52_build_5020500_interimfix_8
si_52_build_5020500_interimfix_8
si_52_build_5020500_interimfix_8

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 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