No sub expressions error when running a report in ClearQuest Web 7.1
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.
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
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 126.96.36.199. Upgrade to the latest version of ClearQuest to resolve this issue.
- Open ClearQuest for Windows client. (Run clearquest from Start > Run)
- Right-click the affected query and Edit it.
- Under Query Editor tab, add a new filter condition to the AND or OR filters. For example, add the 'id' field.
- Delete the top-level AND or OR filters which will delete all conditions.
- Save the query.
Run the report from ClearQuest Web. The error should no longer appear.
|Software Development||Rational ClearQuest||Web Client (7.1)|