JR47194: CMVC 229663 - When catalog is configured to only have category level SKU's the findProductsByCategory retunrs null response.

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

APAR status

• Closed as program error.

Error description

• The findProductsByCategory method inside ProductViewHandler
  returns null response when catalog is set to have category level
   SKU's only.
  
   Procedures/Steps to reproduce problem:
   - Have only category level SKU's rather then Products.
   - Make REST Call http://
  <hostname>/wcs/resources/store/<storeId>/productview/byCategory/
  <category_id>
  
   Observed Results: null response, from logs you will observe
  "404 status".
  
    00000035 filter        1
  com.ibm.commerce.rest.filter.RestTransactionFilter doFilter
  status=404, commitMark=null
    00000035 filter        1
  com.ibm.commerce.rest.filter.RestTransactionFilter doFilter
  rollback transaction, status=404
    00000035 ServiceLogger 1   REST transaction rollback, HTTP
  status = 404 (Not Found)
  
   Expected Results: Should return response based on ItemBean.
  

Local fix

• Following GET call can be used as a workaround. This call will
  retrieve same result as "byCategory" URL.
   http://
  <hostname>/wcs/resources/store/{storeId}/productview/bySearchTer
  m/*?categoryId={categoryId} &searchType=100
  

Problem summary

•  USERS AFFECTED:
   Customers using RESTful services to retrieve product data for
  search-based catalog navigation.
  
   PROBLEM ABSTRACT:
   When catalog is configured to only have category level SKU's
  the findProductsByCategory retunrs null response.
  
   BUSINESS IMPACT:
   Not able to use REST services.
  
   RECOMMENDATION:
  

Problem conclusion

• Adding  a generic xpath to support customer who might not have
  Product-Item structure but with category level SKU's only.  When
   search type - "searchType" is specified as a query parameter,
  the new generic xpath is used.  Here are a list of searchType
  supported and recommended to be used when needed:
  
  
  ----------------------------------------------------------------
  ------------------------------------------
                            Search Type  |         Description
  
  ----------------------------------------------------------------
  ------------------------------------------
       1.  0      |  INCLUDE products, kits, bundles
               |  EXCLUDE product level SKUs and category level
  SKUs
               |
       2.  10      |  INCLUDE products, kits, bundles, product
  level SKUs, category level SKUs
               |  EXCLUDE
               |
       3.   100      |  INCLUDE product level SKUs, category level
  SKUs
               |  EXCLUDE products, kits, bundles
               |
       4.    1000      |  INCLUDE products, kits, bundles,
  category level SKUs
                 |  EXCLUDE product level SKUs
               |
       5.  10000    |  INCLUDE category level SKUs
               |  EXCLUDE products, kits, bundles, product level
  SKUs
  
  
   -------------------------------------------------------------
   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