IBM Support

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

Troubleshooting


Problem

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.

[{"Product":{"code":"SSSH5A","label":"Rational ClearQuest"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"Reporting","Platform":[{"code":"PF033","label":"Windows"}],"Version":"7.1;7.1.0.1;7.1.0.2","Edition":"","Line of Business":{"code":"LOB45","label":"Automation"}},{"Product":{"code":"SSSH5A","label":"Rational ClearQuest"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"Web Client (7.1)","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"LOB45","label":"Automation"}}]

Document Information

Modified date:
16 June 2018

UID

swg21386179