Direct links to fixes
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 / Xsystem
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
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SS3JSW","label":"Sterling B2B Integrator"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"5.2.4","Line of Business":{"code":"LOB59","label":"Sustainability Software"}}]
Document Information
Modified date:
24 August 2023