JR42808: CMVC 222368 - IMPROVE SEARCH RESULTS, BY REDUCING THE NUMBER OF CONTRACTS RELATED QUERIES TO THE DATABASE
Direct links to fixes
Closed as program error.
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.
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:
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
Reported component name
WC BUS EDITION
Reported component ID
Last modified date
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fixed component name
WC BUS EDITION
Fixed component ID
Applicable component levels