IBM Support

Why do I get a Error 500 java.lang.IllegalArgumentException When Deleting large number of Datasets?

Question & Answer


Question

Why do I get a Error 500 java.lang.IllegalArgumentException When Deleting large number of Datasets?

I get a Error 500 java.lang.IllegalArgumentException when deleting a large number of datasets, if I select more than 10,000 rows. Since I currently have over 160,000 rows, I don't want to have to perform the deletes 10,00 rows at a time.

[ERROR ] SRVE0325E: Exceeding maximum parameters allowed per request 10,000 ,current 10,000 , cannot add more.

Answer

The default value for maxParamPerRequest is 10,000, and hence, the limit. To reset for "unlimited" in the embedded application server, do the following:

  1. Locate <installDir>\wlp\usr\servers\dmh\server.xml and and examine the webContainer element.

  2. Add a maxParamPerRequest property as follows: <webContainer deferServletLoad="true" maxParamPerRequest="-1"/>

  3. Save the file.

  4. Following the update of server.xml, the application server must be restarted for the change to take effect.

RAA Fix Pack 15 (v6.1.0.15) is planned to ship with this update to the web container property in the embedded application server.


[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSMMS4","label":"Rational Application Analyzer"},"Platform":[{"code":"PF035","label":"z\/OS"}],"Component":"","Version":"","Line of Business":{"code":"","label":""}}]

Document Information

More support for:
Rational Application Analyzer

Operating system(s):
z/OS

Document number:
6140541

Modified date:
06 June 2017

UID

dwa1379648

Manage My Notification Subscriptions