IBM Support

RQM Warnings in qm.log for Display Result Set Size

Technote (FAQ)


Question

You observe warnings in your IBM Rational Quality Manager (RQM) qm.log similar to the example below. What do these warnings mean?

Example:
2014-03-04 11:42:28,990 [http-bio-9080-exec-58834 @@ 11:42 rqmadmin /jazz/service/com.ibm.team.reports.common.internal.service.IReportRestService/renderReport]
WARN com.ibm.team.reports - User rqmadmin in project area Quality Manager displayed report Test cases that run a query that exceeded the result set size of 20000:
VersionedTestPlanQueryModel r = VersionedTestPlanQueryModel.ROOT;
AstQuery q = (AstQuery) IDataQuery.FACTORY.newInstance(r);
q.select(r.archived());
q.select(r.testPlan().name());
q.select(r.testCases().itemId());
q.filter(r.projectArea().projectArea().name()._in(new IString[] {"Quality Manager"})._and(r.projectArea().projectArea().archived()._eq(0)._or(r.projectArea().projectArea().archived()._isNull()))._and(r.snapshot()._eq(0)));.

Cause

Logging changes were introduced in release 4.0.5 and included in later releases.

Answer

If any SQL query run as part of a out-of-the-box BIRT report returns a result set exceeding a certain value, a message is written to the log giving information about the report name, project and user who ran it. This can be helpful information when there are stability issues with the RQM Server to see if any large reports were being run prior to some event such as out-of-memory.

This new value is called "Large Record Count" and is configurable in the Jazz Team Server under Advanced Properties. The default value is 10000.


Leverage the Jazz Community

The Jazz based products have an active community that can provide you with additional resources. Browse and contribute to the User forums, contribute to the Team Blog and review the Team wiki.
Refer to technote 1319600 for details and links.

Related information

Which report had run a big query


Cross reference information
Segment Product Component Platform Version Edition
Software Development Rational Team Concert Team Server

Document information

More support for: Rational Quality Manager
RQM Server

Software version: 4.0.5, 4.0.6

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

Reference #: 1668221

Modified date: 25 March 2014