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

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.0.0.7 Fix Pack
WebSphere Commerce Version 7.0.0.9 Fix Pack
JR42808: CMVC 222368 - REDUCE QUERIES TO THE DATABASE RELATED TO CONTRACTS

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 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