JR42808: CMVC 222368 - IMPROVE SEARCH RESULTS, BY REDUCING THE NUMBER OF CONTRACTS RELATED QUERIES TO THE DATABASE

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • With WC_ORDER trace enabled, the following line can be seen
    executing repeatedly for every product set associated with the
    catalog Asset store:
    
    4/05/12 0:45:09:515 EST] 0000002e WC_ORDER      3
    -40112614:13713235c2b:-7fe2
    com.ibm.commerce.price.commands.CalculateContractPricesCmdImpl.g
    etAdjustment
    catalogEntryId=32873,tcId=17504,productSetAdjustments=[(productS
    etId=213516,type=1,adjustment=0.00000,precedence=1)],entireCatal
    ogAdjustment=0.0
    
    If there are many esite stores using one catalog asset store,
    there could be a large number of product sets being queried,
    however only those product sets associated to the users account
    or contract are valid product sets for the search. In other
    words, many product sets could end up being needlessly queried,
    resulting in a longer execution time.
    

Local fix

Problem summary

  • USERS AFFECTED:
    WebSphere Commerce V7 - customers using Price Term Conditions
    with large numbers of product sets in an esite store.
    
    PROBLEM ABSTRACT:
    Search results are taking too long to display due to the time
    taken by the CalculateContractPricesCmdImpl command.
    
    BUSINESS IMPACT:
    Longer response time in production can impact customer exprience
    
    RECOMMENDATION:
    

Problem conclusion

  • The fix works to re-define the scope of the product sets queried
    by the getAdjustment method. It should check all the catentry
    related productsets in the account scope for a B2B store, and
    contract scope for a B2C store.
    
    -------------------------------------------------------------
    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

    JR42808

  • Reported component name

    WC BUS EDITION

  • Reported component ID

    5724I3800

  • Reported release

    600

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2012-05-11

  • Closed date

    2012-11-08

  • Last modified date

    2012-11-08

  • 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



Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

WebSphere Commerce Enterprise

Software version:

6.0

Reference #:

JR42808

Modified date:

2012-11-08

Translate my page

Machine Translation

Content navigation