Friday 9 December 2011

BMXAA2333E - Please narrow your results down to a maximum of 200 rows to perform this action

Issue:  BMXAA2333E - Please narrow your results down to a maximum of 200 rows to perform this action.

When: When a query is executed in a Maximo application, and the results of that query are shown on the List page, there is a checkbox in the lower left corner of the form called 'Select Records' that allows you to select a number of records (checking the top box above the first record will enable you to select all of them).

If more than 200 records are displayed in the results set, the user receives the following message:

"Please narrow your results down to a maximum of 200 rows to perform this action".

Reason:  By default value of  webclient.maxselectrows = 200.

The issue was resolved with the following suggestion provided to the customer:

There is a way to change the out-of-the-box limit of 200 records.

1.      Navigate to the MAXIMO\applications\maximo\properties\ folder and open the webclient.properties file.  { This path differ from maximo version to version better search for “webclient.properties”}
  1. Using your favorite text editor, open the webclient.properties file
  2. Search for  webclient.maxselectrows”
4.      Change the webclient.maxselectrows= property entry from 200 to the desired limit.
5.      Save and rebuild EAR files for the changes to take effect.

WARNING: Setting the limit to too high a value may result in performance issues.

Any new setting should be implemented and fully tested in a test environment before making these changes in your production environment.

***************

Steps to be followed in Maximo 7.5

  1.  Login with  required administrative privilege
  2.  Navigate system configuration à Platform configuration à system properties
  3.   Search for “webclient.maxselectrows
  4.  Change the webclient.maxselectrows= property entry from 200 to the desired limit.
  5. Save and Live refresh for the changes to take effect

1 comment:

  1. webclient.maxselectrows is a system property that can be changed online, but it unfortunately is not a property that is eligible for a Live Refresh? The check box for "Live Refresh?" is greyed out in Maximo 7.5.0.4

    ReplyDelete