IBM Support

JR47320: CMVC 229872 - Discount calculation takes a long time when a large cart is used

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • For an Order level promotion, WebSphere Commerce v7 does not
    take the adjustment from the ORDER record but simply applies it
    in the same way as a Product level promotion and includes ALL
    items in the basket as qualifying items.
    From a performance point of view, where large basket sizes are
    used, this is extremely inefficient as the discount is
    calculated pro rata across all order-item records and each
    order-item is updated accordingly.
    Also, a corresponding ORDIADJUST record is created/updated for
    each order-item record.
    Updating one order-item will result in cycling through each and
    every other order-item which is inefficient.
    

Local fix

Problem summary

  • USERS AFFECTED:
    All users on WebSphere Commerce v7 that use product level
    promotions
    
    PROBLEM ABSTRACT:
    Discount calculation takes a long time when a large cart is used
    
    BUSINESS IMPACT:
    Performance impact
    
    RECOMMENDATION:
    

Problem conclusion

  • The fix involves caching of the running total for the subset of
    affected items in shop cart during the computational process of
    distributing the discount among affected items in cart.  More
    specifically, transactional cache is being employed.  The key of
     the cache is constructed using a list array of 3 values:
    ["orderID", "affected item set hash code", "monetaryValueType"].
      The value of the cache is the running subtotal for the shop
    cart: both at the item set level as well as at each individual
    item level.
    -------------------------------------------------------------
    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 number

    JR47320

  • Reported component name

    WC BUS EDITION

  • Reported component ID

    5724I3800

  • Reported release

    700

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2013-07-24

  • Closed date

    2014-05-03

  • Last modified date

    2014-05-03

  • 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"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"7.0","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
03 May 2014