JR44864: CMVC 224843 - This fix is to improve the performance of retrieving attribute data from Solr

JR47273 - WebSphere Commerce Search cumulative Interim Fix in V7.0 Feature Pack 5
JR46013 - Slow Performance/OOM during synonym expansion

APAR status

• Closed as program error.

Error description

• If the catalog data contains a large number of attributes and
  attribute values and search-based navigation is being used,
  navigating the catalog could be slow and lead to high memory
  usage possibly resulting in an OutOfMemoryError similar to the
  following in the logs:
  
  [9/24/12 9:30:43:250 EDT] 0000005b LocalExceptio E   CNTR0020E:
  EJB threw an unexpected (non-declared) exception during
  invocation of method "getCatalogNavigationView" on bean
  "BeanId(WC#Catalog-Server.jar#Catalog, null)". Exception data:
  java.lang.OutOfMemoryError
   at com.ibm.db2.jcc.am.lc.a(lc.java:2351)
   at com.ibm.db2.jcc.am.lc.p(lc.java:523)
   at com.ibm.db2.jcc.am.lc.Z(lc.java:2232)
   at com.ibm.db2.jcc.am.tn.f(tn.java:1416)
   at com.ibm.db2.jcc.am.tn.getObject(tn.java:1391)
   at
  com.ibm.ws.rsadapter.jdbc.WSJdbcResultSet.getObject(WSJdbcResult
  Set.java:1920)
   at
  com.ibm.commerce.foundation.server.services.dataaccess.JDBCQuery
  Service.executeQuery(JDBCQueryService.java:864)
   at
  com.ibm.commerce.catalog.facade.server.services.search.metadata.
  solr.SolrFacetEntryViewImageAndSequenceResultFilter.fetchAttribu
  teValueImageAndSequence(SolrFacetEntryViewImageAndSequenceResult
  Filter.java:259)
  

Local fix

Problem summary

• USERS AFFECTED:
  WebSphere Commerce v7.0 users with Feature Pack 5 installed and
  using search-based navigation
  
  PROBLEM ABSTRACT:
  Navigating the catalog on the storefront is slow or results in
  an OutOfMemoryError when using search based navigation and the
  catalog has a large number of attributes and attribute values.
  
  BUSINESS IMPACT:
  Impacts performance of storefront browsing
  
  RECOMMENDATION:
  

Problem conclusion

• The query used to retrieve the attribute data has been changed
  to improve the performance.
  -------------------------------------------------------------
  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