IT25762: THE MAILBOX ADD SERVICE COMPLETES SUCCESSFULLY BUT NEVER ACTUALLY ADDS A RECORD TO THE MBX_MESSAGE TABLE

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