JR49283: BatchUpdateException appears in the logs

7.0.0.9 for Developer Express
7.0.0.9 for Developer Professional
7.0.0.9 for Developer Enterprise
7.0.0-WS-WCServer-FP009

APAR status

• Closed as program error.

Error description

• The following exception appears in the SystemOut logs
  
  com.ibm.db2.jcc.am.BatchUpdateException.[jcc][t4][102][10040][4.
  14.122] Batch failure.  The batch was submitted, but at least
  one exception occurred on an individual member of the batch.
  Use getNextException() to retrieve the exceptions for specific
  batched elements. ERRORCODE=-4229, SQLSTATE=null
        at com.ibm.db2.jcc.am.ed.a(ed.java:405)
        at
  com.ibm.db2.jcc.am.Agent.endBatchedReadChain(Agent.java:400)
        at com.ibm.db2.jcc.am.po.a(po.java:5157)
        at com.ibm.db2.jcc.am.po.c(po.java:4743)
        at com.ibm.db2.jcc.am.po.executeBatch(po.java:2995)
        at
  com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.pmiExecuteBatc
  h(WSJdbcPreparedStatement.java:1012)
        at
  com.ibm.ws.rsadapter.jdbc.WSJdbcStatement.executeBatch(WSJdbcSta
  tement.java:822)
        at
  com.ibm.commerce.foundation.server.services.dataaccess.JDBCQuery
  Service.executeBatchUpdate(JDBCQueryService.java:760)
        at
  com.ibm.commerce.marketing.runtime.engine.MarketingEngineCache.f
  lushUserBehaviorBatchUpdateCache(MarketingEngineCache.java:2544)
  
  The exception appears intermittently in the logs. This situation
  can occur where there are web or dialog activities that require
  persisting user behavior information to the database (for
  example catalog browsing behavior, experiments, non repeatable
  activities).
  

Local fix

• Increase the size of the DM_UserCache
  

Problem summary

• USERS AFFECTED:
  WebSphere Commerce users on v7.0 who use Management Center
  marketing activities that track user behavior
  
  PROBLEM ABSTRACT:
  BatchUpdateException appears in the logs
  
  BUSINESS IMPACT:
  Customers may not get the correct results from web and dialog
  activities
  
  RECOMMENDATION:
  

Problem conclusion

• This problem occurs when:
    - user behavior information needs to be recorded for the very
  first time for a customer, and
    - the corresponding record in the DM_UserCache is LRU evicted
  before the user behavior information has been persisted, and
    - then the user behavior information needs to be updated for
  the customer
  
  The marketing code was fixed to ensure all user behavior records
  are persisted correctly.
  -------------------------------------------------------------
  The latest available maintenance information can be obtained
  from the Recommended Fixes for WebSphere Commerce technote:
  http://www.ibm.com/support/docview.wss?rs=3046&uid=swg21261296
  

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

  WC BUS DEV ED W

• Fixed component ID

  5724I3900

Applicable component levels

• R700 PSY

     UP