IBM Support

No sub expressions error when running a report in ClearQuest Web 7.1

Technote (troubleshooting)


Problem(Abstract)

This technote identifies an issue that can occur in IBM Rational ClearQuest Web 7.1. Running a report results in a "No sub expressions" error.

Symptom

When running a report on ClearQuest Web 7.1, the Report Server for ClearQuest throws this error:

An unexpected error occurred during processing.
CRVAP0216E The parameters used in CqRecordType.doQuery are incorrectly specified.
CRVAP0216E (illegal-query): The parameters used in CqRecordType.doQuery are incorrectly specified.
CRVAP0221E (bad-request): Bad Request: CRVSV0078E Error from RPC server:

CRVSV0716E No sub expressions in CTG:filtering-expression Caused by: com.ibm.rational.stp.ws.schema.ErrorFault



Cause

The specified query for the report contains an "AND" or "OR" filter with no leaf conditions. This issue was identified as a product defect under APAR PK85662.

Resolving the problem

This problem is fixed starting in ClearQuest 7.1.0.2. Upgrade to the latest version of ClearQuest to resolve this issue.



WORKAROUND

  1. Open ClearQuest for Windows client. (Run clearquest from Start > Run)
  2. Right-click the affected query and Edit it.
  3. Under Query Editor tab, add a new filter condition to the AND or OR filters. For example, add the 'id' field.
  4. Delete the top-level AND or OR filters which will delete all conditions.
  5. Save the query.

Run the report from ClearQuest Web. The error should no longer appear.

Cross Reference information
Segment Product Component Platform Version Edition
Software Development Rational ClearQuest Web Client (7.1)

Document information

More support for: Rational ClearQuest
Reporting

Software version: 7.1, 7.1.0.1, 7.1.0.2

Operating system(s): Windows

Reference #: 1386179

Modified date: 25 October 2009