Technote (troubleshooting)
Problem(Abstract)
If you have more than 5000 items (SKU) under a particular product and when you try to retrieve this huge amount of data which is greater than the paging limit of WebSphere Commerce Management Center, then system throws an error.
Symptom
You will notice the following error message in WebSphere Commerce Management Center user interface when you try to view that particular product under catalog tool, "The number of results returned from the search exceeded the paging limit of 5000. Refined the search expression to limit the search result".
Cause
This is caused by the maximum paging limit (5000) set in Out of the box WebSphere Commerce System.
Resolving the problem
Problem can be resolved by increasing the paging limit. To increase this paging limit (maximumPageSize), Update the wc-component.xml file under the com.ibm.commerce.catalog-ext component directory. If the wc-component.xml configuration file does not exist then you will need create one. For example,
<?xml version="1.0" encoding="UTF-8"?>
<_config:DevelopmentComponentConfiguration
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://www.ibm.com/xmlns/prod/commerce/foundation/config ../xsd/wc-component.xsd "
xmlns:_config="http://www.ibm.com/xmlns/prod/commerce/foundation/config">
<_config:dataservice
dataMediatorType="JDBC"
metadataClass="com.ibm.commerce.catalog.facade.server.metadata.CatalogMetadata"
maximumPageSize="8888">
</_config:dataservice>
</_config:DevelopmentComponentConfiguration>
Note: When you try to increase this paging limit, you also need consider the WebSphere Commerce Management Center performance as well.
Rate this page:
Copyright and trademark information
IBM, the IBM logo and ibm.com are trademarks of International Business Machines Corp., registered in many jurisdictions worldwide. Other product and service names might be trademarks of IBM or other companies. A current list of IBM trademarks is available on the Web at "Copyright and trademark information" at www.ibm.com/legal/copytrade.shtml.