IBM Support

The query limit of 100 was exceeded for this report format

Technote (troubleshooting)


Attempts to run Associated Requirement Changes report for DOORS-Change package in IBM Rational Change results in the error "The query limit of 100 was exceeded for this report format".


The query does not display the associated requirements changes and reports the above error.


The default limit set is 100 in the doors_cs_template.cfg configuration file.

Resolving the problem

The number of Requirement Changes displayed in an RCR depends on a specific setting in the package template configuration file in Rational Change.

The configuration file holds the query limit under the CCM_REPORT section and is a hard set limit for that package.

Steps to edit the query limit:

  1. Edit the configuration file is located in <CS_HOME>/cs_app/webapps/synergy/WEB-INF/package_templates/doors_cs_template<version>/wsconfig directory

    In this case, the file name is doors_cs_template.cfg or the name of the custom package template.

  2. Under the CCM_REPORT section, locate the number hard coded which limits the query output to 100.

  3. Making suitable modifications to the CCM_REPORT section to exceed the originally set query limit.

  4. After making the changes in the configuration file, re-generate the process package using the updated package template and re-install the package for the changes to take effect.

Document information

More support for: Rational Change
General Information

Software version: 4.7, 5.0, 5.1, 5.2,

Operating system(s): AIX, Linux, Solaris, Windows

Reference #: 1432010

Modified date: 27 May 2010

Translate this page: