You can specify the maximum number of price entries
a price list can contain if it is to be exported using the Catalog
Filter and Pricing tool. By specifying this maximum number, you can
avoid both out-of-memory exceptions and time-out errors caused by
overly large price lists. A price entry is a row in a price list.
About this task
By default, the limit is enabled and the maximum number of
rows is set to 100000
, meaning that a price list
can have up to 100,000 rows for the export to proceed. You can change
this maximum number to suit your site. Be aware that if you increase
the maximum number, this might cause a server crash due to an out-of-memory
error. Increasing your JVM memory might resolve problems with out-of-memory
errors. Even if an out-of-memory error does not occur after increasing
the JVM memory, the browser might still display a time-out error if
it takes too long to generate the export file.If a user tries to
export a price list that exceeds the maximum number:
- The price list is not exported.
- A message displays to let the user know of the limitation.
You can also disable the limit.
Procedure
- Navigate to the configuration file at the following path:
WC_eardir/xml/config/com.ibm.commerce.price-fep/wc-admin-component.xml
- Locate the following lines of code:
<_config:configgrouping name="PriceListExport">
<!-- Whether limit rows of price entries when export a price list. -->
<_config:property name="limitRows" value="true"/>
<!--
The maximum number of price entries when limit rows to export.
Note that if too large, it will cause an OutOfMemory exception that crash the server.
-->
<_config:property name="maximumNumber" value="100000"/>
</_config:configgrouping>
- Set the properties for your site:
Property |
Description |
limitRows |
Specifies whether you want to set a limit to
the number of rows a price list can contain if it is to be exported. The Value parameter
can be set to:
- true
- Set to
true if you want to set a limit. In this
case, you must specify a number for the maximumNumber property
(see the next row in this table).
- false
- Set to
false if you do not want to set a limit.
In this case, the maximumNumber value is ignored.
|
maximumNumber |
Specifies maximum number of number of rows a
price list can contain if it is to be exported. Set the Value parameter
to any suitable number from 1 to 500000 . |
- Save and close the file.
- To make the changes take effect, restart the WebSphere
Commerce server.