IBM Support

Query dates appear incorrect in ClearQuest 7.1.2 Web



Date-based queries that were created with Rational ClearQuest for Windows client, (version,,,,,, or are incorrectly converted in the ClearQuest Web client which might cause an error to be displayed when they are executed.


When you execute these queries in ClearQuest 7.1.2.x Web, the results are either invalid--based on an unexpected date far in the past--, or you receive the following error message:

CRVSV0078E Error from RPC server: CRVSV0789E The executing query failed:

CRVSV0078E Error from RPC server: CRVSV0789E The executing query failed:

If you review the query definition from CQ Web, you will notice that the dates were converted incorrectly and have very old dates:


This issue was identified as a product defect under APAR PM19849.

Resolving The Problem

This problem is fixed starting in ClearQuest and

To permanently resolve instances of this query issue in earlier versions of the ClearQuest Client for Windows, recreate or modify the query that is causing an error message or generating an incorrect result set.

  1. In any version of the ClearQuest Eclipse client or the ClearQuest Web Client, edit the query.
  2. Click on the date/time filter to update the format of the date/time filter.

    You do not need to change anything. Clicking the date/time filter flags the query as changed.
  3. Save the query to update the date/time portion of the query with the correct format.
  4. Run the query to verify that it produces correct results.

If users wish to continue using the ClearQuest Client for Windows, these hosts must be upgraded to at least versions or All new queries created or modified with ClearQuest versions or or newer will work as expected in all clients.

[{"Product":{"code":"SSSH5A","label":"Rational ClearQuest"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"Query","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"7.1.1;;;;;7.1.2;;","Edition":"All Editions","Line of Business":{"code":"LOB45","label":"Automation"}}]

Document Information

Modified date:
14 January 2020