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 number
JR54955
Reported component name
WC BUS EDITION
Reported component ID
5724I3800
Reported release
700
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2015-12-10
Closed date
2016-01-07
Last modified date
2016-01-27
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
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSYSYL","label":"WebSphere Commerce Enterprise"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"7.0","Line of Business":{"code":"LOB31","label":"WCE Watson Marketing and Commerce"}}]
Document Information
Modified date:
11 December 2021