JR43610: CMVC 223902 - MITIGATE PERFORMANCE ISSUE WHEN CATALOGNAVIGATION VIEWTYPE IS USED TO FETCH ATTRIBUTE DICTIONARY ATTRIBUTE

JR47273 - WebSphere Commerce Search cumulative Interim Fix in V7.0 Feature Pack 5

APAR status

• Closed as program error.

Error description

• The existing CatalogNavigationView storefront service retrieves
  all defining attribute allowed values for a given product from
  database and filter out the ones not used by SKUs.  This can
  cause performance issues if a particular attribute has a very
  large number of allowed values.
  

Local fix

Problem summary

• USERS AFFECTED:
  All WebSphere Commerce 7.0 FEP4 users leveraging the
  CatalogNavigationView service call with a large number of
  attribute values
  
  PROBLEM ABSTRACT:
  Performance issues occur with the CatalogNavigationView service
  call when the Attribute Dictionary contains a large number of
  attribute values for a given attribute.
  
  BUSINESS IMPACT:
  Low-Moderate: The issue will most likely become apparent during
  early testing/development phases at which point steps can be
  taken to acquire and install the fix.
  
  RECOMMENDATION:
  

Problem conclusion

• The query was modified in the wc-query-CatalogEntry-get-fep.tpl
  file and the
  SearchCatalogEntryViewAttributesAllowedValueResultFilter filter
  was removed from wc-search.xml since it is no longer necessary
  to filter out the unused values in the business logic.
  
  
  -------------------------------------------------------------
  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