Receive SIZELIMIT Exceed Message in the UI search

Troubleshooting › Receive SIZELIMIT Exceed Message in the UI search

Receive SIZELIMIT Exceed Message in the UI search

Symptom:

I see "Size Limit exceeded" messages in my web interface during searches.

Solution:

Open the LDAP slapd.conf file.
Check the size limit. The default value in the slapd.conf file is 500.
```
Sizelimit 500
```
If your database has results over 500, this could lead to a size limit exceeded message in the UI or in the LDAP log.
Change the limit to a higher value, or set it to -1. If you specify -1, the database returns all results that are available.

Symptom:

I specified a size limit option of -1 in the LDAP slapd.conf file, and I still see "Size Limit exceeded" messages in my web interface during searches.

Reason:

This message means that the number of returned results is higher than the default size limit of the interface, which is limited to displaying up to 1000 returned results.

Solution:

To change the size limit

Go to the CHORUS_HOME/config directory.
Find the file cmgr_config.xml.
- For Compliance Policy Administration, locate the configuration file in INSTALL_DIR/config:
  - cmgr_config.xml
- For Security Administration, locate the following configuration files in INSTALL_DIR/config:
  - acf2_config.xml for CA ACF2
  - tss_config.xml for CA Top Secret
Edit the configuration file. The file is in ASCII format on the mainframe and you edit it in one of two ways:
- FTP the file to your PC, edit it, and FTP it back to your LPAR.
- Use ispfedit:
  - Issue the EA ‘FILE_NAME‘ command to edit the ASCII file.
  - Issue the VA ‘FILE_NAME’ command to view the ASCII file.

Convert the file using one of the following commands:

iconv -f iso8859-1 -t ibm-1047 cmgr_config.xml > cmgr_config.xml.e
iconv -f iso8859-1 -t ibm-1047 acf2_config.xml > acf2_config.xml.e
iconv -f iso8859-1 -t ibm-1047 tss_config.xml  > tss_config.xml.e

Increase the size limit to a value equivalent to or higher than the number of entries in your database.
```
<searchRows>2500</searchRows>
```

Save the file, and then convert it back using one of the following commands:

iconv -f ibm-1047 -t iso8859-1 cmgr_config.xml.e > cmgr_config.xml
iconv -f ibm-1047 -t iso8859-1 acf2_config.xml.e > acf2_config.xml
iconv -f ibm-1047 -t iso8859-1 tss_config.xml.e  > tss_config.xml

Important! Restart JBOSS to pick up the changes.