APAR status
Closed as program error.
Error description
The Mailbox Add Service is erroneously showing a message_id was added to the mbx_message table when the identity value reaches 999999999 on the NEXT_SESS_ARC_ID column in the ACT_SESSION_GUID table with MSSQL
Local fix
RTC ID: 564457 FB/FB Circumvention: None
Problem summary
Users Affected: B2B Integrator 5.2 Problem Description: On any IBM Sterling B2B Integrator install with MSSQL DB, if the AUTOINCREMENT (identity) value of the NEXT_SESS_ARC_ID column in the ACT_SESSION_GUID table reaches max value (999999999) MSSQL throws "SQLServerException: Arithmetic overflow error" in the visibility log. Even though the Mailbox Add Service reports SUCCESS, it never actually INSERTS a record into the MBX_MESSAGES table. The Mailbox Add Service performs several database operations, all inside a Workflow transaction. One of these database operations involves generating a visibility session ID. This ID is used to associate the visibility events with a Workflow. This operation is throwing the "Arithmetic overflow error" exception, causing in the entire Workflow transaction to be rolled back. Platforms affected: Unix/Linux Windows iSeries
Problem conclusion
Resolution Summary: A code fix is provided. Delivered In: 5020603_7
Temporary fix
Comments
APAR Information
APAR number
IT25762
Reported component name
STR B2B INTEGRA
Reported component ID
5725D0600
Reported release
526
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2018-07-19
Closed date
2018-10-01
Last modified date
2018-10-17
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":"IBM Sterling B2B Integrator"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"5.2.6","Edition":"","Line of Business":{"code":"LOB02","label":"AI Applications"}}]
Document Information
Modified date:
17 October 2018