JR49247: Calling ProductInventoryUpdateCmdImpl under heavy shopping load can cause optimistic update failure exceptions.

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
WebSphere Commerce Version 7 Fix Pack 8 Cumulative1 interim fix
WebSphere Commerce Version 7.0.0.9 Fix Pack

APAR status

• Closed as program error.

Error description

• The ProductInventoryUpdateCmdImpl command uses optimistic
  concurrency control when it updates the INVENTORY table.
  Because rows in this table can be frequently and concurrently
  updated, the command should be changed to use pessimistic
  concurrency control.
  

Local fix

Problem summary

• USERS AFFECTED:
   WebSphere Commerce customers who use the
  ProductInventoryUpdateCmdImpl command to update the INVENTORY
  table.
  
   PROBLEM ABSTRACT:
   Calling ProductInventoryUpdateCmdImpl under heavy shopping load
  can cause optimistic update failure exceptions.
  
   BUSINESS IMPACT:
   Exceptions can be thrown when there are multiple concurrent
  requests to update the same row in the INVENTORY table.
  
   RECOMMENDATION:
  

Problem conclusion

• The ProductInventoryUpdateCmdImpl command was changed to use
  pessimistic (i.e. SELECT ... FOR UPDATE) concurrency control.
  
   -------------------------------------------------------------
   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 EDITION

• Fixed component ID

  5724I3800

Applicable component levels

• R700 PSY

     UP