PH54462: EXCEPTION PERSISTING BATCH COM.IBM.WS.SIB.MSGSTORE.PERSISTENCEEXCEPTION: CWSIS1501E: THE DATA SOUR

APAR status

• Closed as program error.

Error description

• Two SIB threads are making the DB queries and leading to the
  deadlock in the SIB Database tables and Transactions are rolled
  back and throwing
  
  
  Batch.	(com.ibm.ws.sib.msgstore.persistence.dispatcher.Batch)
  [EPHSIBus:SIB.006-EPHSIBus/96c48888] Exception persisting batch
  
  com.ibm.ws.sib.msgstore.PersistenceException: CWSIS1501E: The
  data source has produced an unexpected exception:
  com.ibm.db2.jcc.am.BatchUpdateException:
  [jcc][t4][102][10040][3.72.54] Batch failure.  The batch was
  submitted, but at least one exception occurred on an individual
  member of the batch.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:  Users of IBM WebSphere Application Server   *
  *                  using an SIBus Messaging Engine backed by   *
  *                  a datastore.                                *
  ****************************************************************
  * PROBLEM DESCRIPTION: SIB make conflicting updates in its     *
  *                      datastore DB, leading to deadlock       *
  *                      detection in the DB and rollback of     *
  *                      Transactions.                           *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  Two SIB threads are making the DB
  queries and leading to the
  deadlock in the SIB Database tables
  and Transactions are rolled
  back and throwing
  Batch.	(com.ibm.ws.sib.msgstore.persist
  ence.dispatcher.Batch)
  [EPHSIBus:SIB.006-EPHSIBus/96c48888]
  Exception persisting batch
  com.ibm.ws.sib.msgstore.PersistenceExce
  ption: CWSIS1501E: The
  data source has produced an
  unexpected exception:
  com.ibm.db2.jcc.am.BatchUpdateException
  :
  [jcc][t4][102][10040][3.72.54] Batch
  failure.  The batch was
  submitted, but at least one exception
  occurred on an individual
  member of the batch.
  

Problem conclusion

• The logic in
  com.ibm.ws.sib.msgstore.persistence.dispatcher.PersistentDispatc
  her.inDispatchableWithConflict()
  was modified to consider every task in a Dispatch Unit for
  conflicts, eliminating the invalid optimisation that caused
  the risk of conflicting dispatch units being simultaneously
  dispatched.
  
  The fix for this APAR is targeted for inclusion in fix packs
  8.5.5.26 and 9.0.5.21.
  For more information, see 'Recommended Updates for WebSphere
  Application Server':
  https://www.ibm.com/support/pages/node/715553
  

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

  WEBS APP SERV N

• Fixed component ID

  5724H8800

Applicable component levels