Error Message: results returned exceed the paging limit, refine the search expression to limit search result

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:

(0 users)Average rating

Add comments

Document information


More support for:

WebSphere Commerce Enterprise

Software version:

7.0

Operating system(s):

AIX, IBM i, Linux, Solaris, Windows, i5/OS

Reference #:

1625732

Modified date:

2013-02-18

Translate my page

Machine Translation

Content navigation