IBM Support

PI16451: SQL CONVERTED QUERIES CREATED IN THE RPC CLEARQUEST CLIENT WILL NOT DISPLAY ANY RESULTS IN CLEARCASE EXPLORER W/ UCM INTEGRATION

Fixes are available

Rational ClearQuest Fix Pack 6 (8.0.1.6) for 8.0.1
Rational ClearQuest Fix Pack 13 (8.0.0.13) for 8.0
Rational ClearQuest Fix Pack 14 (8.0.0.14) for 8.0
Rational ClearQuest Fix Pack 7 (8.0.1.7) for 8.0.1
Rational ClearQuest Fix Pack 15 (8.0.0.15) for 8.0
Rational ClearQuest Fix Pack 8 (8.0.1.8) for 8.0.1
Rational ClearQuest Fix Pack 16 (8.0.0.16) for 8.0
Rational ClearQuest Fix Pack 9 (8.0.1.9) for 8.0.1
Rational ClearQuest Fix Pack 17 (8.0.0.17) for 8.0
Rational ClearQuest Fix Pack 10 (8.0.1.10) for 8.0.1
Rational ClearQuest Fix Pack 18 (8.0.0.18) for 8.0
Rational ClearQuest Fix Pack 11 (8.0.1.11) for 8.0.1
Rational ClearQuest Fix Pack 19 (8.0.0.19) for 8.0
Rational ClearQuest Fix Pack 12 (8.0.1.12) for 8.0.1
Rational ClearQuest Fix Pack 20 (8.0.0.20) for 8.0
Rational ClearQuest Fix Pack 13 (8.0.1.13) for 8.0.1
Rational ClearQuest Fix Pack 21 (8.0.0.21) for 8.0
Rational ClearQuest Fix Pack 14 (8.0.1.14) for 8.0.1
Rational ClearQuest Fix Pack 15 (8.0.1.15) for 8.0.1
Rational ClearQuest Fix Pack 16 (8.0.1.16) for 8.0.1
Rational ClearQuest Fix Pack 17 (8.0.1.17) for 8.0.1
Rational ClearQuest Fix Pack 18 (8.0.1.18) for 8.0.1
Rational ClearQuest Fix Pack 19 (8.0.1.19) for 8.0.1
Rational ClearQuest Fix Pack 20 (8.0.1.20) for 8.0.1
Rational ClearQuest Fix Pack 21 (8.0.1.21) for 8.0.1
Rational ClearQuest Fix Pack 22 (8.0.1.22) for 8.0.1
Rational ClearQuest Fix Pack 23 (8.0.1.23) for 8.0.1
Rational ClearQuest Fix Pack 24 (8.0.1.24) for 8.0.1
Rational ClearQuest Fix Pack 25 (8.0.1.25) for 8.0.1

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • SQL converted queries created in the RPC ClearQuest Client
    will not display any results in ClearCase explorer
     The same query created but not converted to SQL will display
    the results correctly
    
    
    Steps to reproduce:
    
    1.) Using ClearQuest Eclispe Client, create a public or personal
    query
    2.) Click the query created and convert to SQL
    3.) Open ClearCase explorer
    4.) Create a file and added to source control
    5.) Checked out the file and created the activity as a defect in
    ClearQuest database
    6.) Checkin the file
    
    7.) In the next checkout, from the activity window, select
    browse and a list of queries will be displayed
    8.) Select the normal "All defects" query and click "run". It
    will show the results with all queries including the new one
    recently created
    9.) Close this window and click browse again to list the queries
    one more time
    10.) Select theSQL converted version of the same query. Click
    "run" and no content will be displayed
    11.) This will happen for Personal and Public SQL converted
    queries
    
    This could be reproduced in ClearCase UCM/ClearQuest integration
    8.0 and 7.1.2 versions
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * ClearQuest UCM Integration                                   *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * When using the Rational ClearCase/ClearQuest UCM             *
    * Integration, SQL-converted queries created in the ClearQuest *
    * Eclipse RCP Client will not display any results in ClearCase *
    * Explorer.                                                    *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    

Problem conclusion

  • A fix is available in ClearQuest 8.0.0.13 and 8.0.1.6.
    When using the ClearCase/ClearQuest UCM integration, a "SQL
    queries are not supported" warning message is now displayed if
    customers try to run SQL queries in ClearCase Explorer.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PI16451

  • Reported component name

    CLEARCASE WIN

  • Reported component ID

    5724G2900

  • Reported release

    800

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2014-04-21

  • Closed date

    2014-12-16

  • Last modified date

    2014-12-16

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

Fix information

  • Fixed component name

    CLEARQUEST WIN

  • Fixed component ID

    5724G3600

Applicable component levels

  • R800 PSY

       UP

  • R801 PSY

       UP

[{"Business Unit":{"code":"BU053","label":"Cloud \u0026 Data Platform"},"Product":{"code":"SSSH5A","label":"Rational ClearQuest"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"8.0.0.0","Line of Business":{"code":"LOB36","label":"IBM Automation"}}]

Document Information

Modified date:
14 October 2021