JR54955: "OptimisticUpdateFailureException" error when same pagepingModeListDataBean is used with other actions on the

APAR status

• Closed as program error.

Error description

• If calculateShippingAdjustment is set to true, then
  OrderShippingModeListDataBean triggers an UPDATE action to the
  ORDERS table to calculate shipping adjustments. This behavior is
   normal and is needed.
  
  But, even when calculateShippingAdjustment is set to false,
  OrderShippingModeListDataBean still triggers an UPDATE action to
   the ORDERS table. The UPDATE action might cause an
  "OptimisticUpdateFailureException" error when
  OrderShippingModeListDataBean is used with other actions on the
  same page, like adding an item to the cart.
  
  You might encounter messages similar to the following errors in
  your log file:
  LocalExceptio E   CNTR0019E: EJB threw an unexpected
  (non-declared) exception during invocation of method
  "findByOrderAndStore".
  Exception data: com.ibm.ws.exception.WsEJBException: nested
  exception is: com.ibm.websphere.csi.CSIException: Problem
  storing CMP
  1.x or BMP bean; nested exception is:
  	com.ibm.ejs.container.CacheFlushFailure: ; nested exception is:
  
  	com.ibm.ejs.persistence.OptimisticUpdateFailureException:
  executeUpdate returned zero rows updated
  

Local fix

Problem summary

• USERS AFFECTED:
  - WebSphere Commerce Version 7 users on Fix Pack 8.
  - WebSphere Commerce Version 8 users.
  
  PROBLEM ABSTRACT:
  "OptimisticUpdateFailureException" error when
  OrderShippingModeListDataBean is used with other actions on the
  same page
  
  BUSINESS IMPACT:
  Shopper encounters an error during checkout.
  
  RECOMMENDATION:
  

Problem conclusion

• Improved OrderShippingModeListDataBean logic to avoid UPDATE
  action when calculateShippingAdjustment is set to false.
  

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 EDITION

• Fixed component ID

  5724I3800

Applicable component levels

• R700 PSY

     UP