JR47069: CMVC 229146 - Improvement needed for the performance of dialog activities which contain shopping cart targets

7.0.0-WS-WCServer-FP009
WebSphere Commerce Version 7.0.0.8 Fix Pack
WebSphere Commerce Version 7.0.0.9 Fix Pack

APAR status

• Closed as program error.

Error description

• When there are multiple dialog activities associated with the
  same event, it is observed that the same database queries are
  performed multiple times against order and catalog related
  database tables when the dialog activities contain Shopping Cart
  targets.
  
  For example, 40 dialog activities are created with the format:
  Wait for Event (OrderItemAdd) -> Shopping Cart target (contains
  products from category X) -> Add to Customer Segment (add to
  segment Y). The same database queries (ORDERITEMS, ORDIADJST,
  CATGPENREL, CATENTREL)  are done 40 times.
  

Local fix

Problem summary

• USERS AFFECTED:
   WebSphere Commerce users on v7.0 using Management Center dialog
  activities
  
   PROBLEM ABSTRACT:
   Improvement needed for the performance of dialog activities
  which contain shopping cart targets
  
   BUSINESS IMPACT:
   Poor storefront performance when running dialog activities
  
   RECOMMENDATION:
  

Problem conclusion

• The marketing dialog activity code was changed to share database
   query results with all dialog activities associated with the
  same event.
  
   -------------------------------------------------------------
   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