LI77047: CMVC 224550 - TO SOLVE PROBLEM WITH OOM HAPPENING DUE TO CATEGORYDATABEAN.GETPRODUCTS() RETRIEVING ALL CATALOG DATA

7.0.0-WS-WCServer-FP009
WebSphere Commerce Version 7.0.0.7 Fix Pack
WebSphere Commerce Version 7.0.0.8 Fix Pack
WebSphere Commerce Version 7.0.0.9 Fix Pack
LI77047: CategoryDataBean pre-fetching of item catalog entries: out of memory

APAR status

• Closed as program error.

Error description

• Products and items are imported via WebSphere Commerce BOD
  Services into the database, but without category or
  category-relations.  Using the Management Center products are
  distributed to the categories, which are maintained in
  Management Center only.  On maintaining the sales catalogs,
  products are related to the categories, and WebSphere Commerce
  automatically relates the items as well to the categories.
  Having for example 50 products in a category, and 10 items per
  product then there are 550 CATGPENREL records for this category.
   Furthermore, the customer can use a catalog filter to define
  which products can be purchased under which contracts.  If the
  customer only adds products, but not the corresponding items to
  the catalog filters, then the items are not filtered.  When the
  CategoryDisplay URL command is called, the CategoryDataBean is
  used and this CategoryDataBean has an issue when accessing
  products.  The  CategoryDataBean.getProducts() method
  pre-fetches all catalog entries for the category, including all
  the items.  Note, that items are not filtered, because only
  products are contained in the contracts and catalog filters.
  Thus when there are many items in the category, calling the
  getProducts() method can lead to an out of memory condition.
  

Local fix

Problem summary

• USERS AFFECTED:
  WebSphere Commerce customers who use the
  CategoryDataBean.getProducts() method without also using the
  getItems() method.
  
  PROBLEM ABSTRACT:
  CategoryDataBean pre-fetching of item catalog entries can result
  in an out of memory condition.
  
  BUSINESS IMPACT:
  Out of memory crash due to CatalogDataBean retrieving all
  catalog data.
  
  RECOMMENDATION:
  

Problem conclusion

• The CategoryDataBean.getProducts() method was changed to not
  pre-fetch items, and the getItems() method was changed to
  not-pre-fetch  products and other kinds of catalog entries.
  
  -------------------------------------------------------------
  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

• 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 ED ILINU

• Fixed component ID

  5724I3804

Applicable component levels

• R600 PSY

     UP