IBM Support

PI40656: CLEARCASE/CLEARQUEST V2 INTEGRATION FAILS WITH CQ WEB (CM SERVER) INTEGRATION POINT TO RETRIEVE OR VALIDATE QUERY RESULTS

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • The V2 IBM Rational ClearQuest/ClearCase integration when
    configured to work via the ClearQuest Change Management (CM)
    Server fails to return a query result set for selecting
    associations for the integration step.
    
    (The integration does not work when connected via CM server,
    only local).
    
    Details:
    From config.pl debug output:
    PostCommand: SetDisplayFieldsAndFilter for the new query
    receives a response from the CM Server with an empty querydef ID
    and DBID, which further results a
    PostCommand: ExecuteQuery that doesn't define the DBID of the
    query to run.
    
    However, the CM Server returns "Success" status to the V2
    client-side.
    
    A WebSphere Applications Server com.ibm.ratoinal.com.* trace
    yields Null Pointer Exceptions (NPE):
    [5/6/15 3:53:06:213 EDT] 0000003a SystemErr     R
    java.lang.NullPointerException
    [5/6/15 3:53:06:213 EDT] 0000003a SystemErr     R    at
    com.ibm.rational.cq.web.services.teamapi.impl.CQQueryServiceTeam
    APIImpl.updateQuery(CQQueryServiceTeamAPIImpl.java:1261)
    [5/6/15 3:53:06:213 EDT] 0000003a SystemErr     R    at
    com.ibm.rational.cq.web.controllers.BaseCCIntegController.handle
    LoadQueryDisplayAndFilterInfo(BaseCCIntegController.java:897)
    [5/6/15 3:53:06:213 EDT] 0000003a SystemErr     R    at
    com.ibm.rational.cq.web.controllers.BaseCCIntegController.handle
    Request(BaseCCIntegController.java:380)
    
    and
    
    [5/6/15 4:34:53:806 EDT] 00000024 SystemErr     R
    java.lang.NullPointerException
    [5/6/15 4:34:53:807 EDT] 00000024 SystemErr     R    at
    com.ibm.rational.cq.web.controllers.BaseCCIntegController.getRes
    ultsetRows(BaseCCIntegController.java:1666)
    [5/6/15 4:34:53:807 EDT] 00000024 SystemErr     R    at
    com.ibm.rational.cq.web.controllers.BaseCCIntegController.handle
    QueryExecution(BaseCCIntegController.java:660)
    [5/6/15 4:34:53:807 EDT] 00000024 SystemErr     R    at
    com.ibm.rational.cq.web.controllers.BaseCCIntegController.handle
    Request(BaseCCIntegController.java:388)
    
    The CM Server SystemOut.log also shows:
    [5/6/15 3:33:16:317 EDT] 00000039 CMLogger      E   CRVSV0048E
    selector is empty
    [5/6/15 3:33:16:318 EDT] 00000039 CMLogger      E   CRVSV0571I
    Exception reason code: invalid-object-selector
    [5/6/15 3:33:16:319 EDT] 00000039 CMLogger      E   CRVSV0048E
    selector is empty
    [5/6/15 3:33:16:635 EDT] 00000039 CMLogger      E   CRVSV0048E
    selector is empty
    
    Steps to reproduce:
    1) Configure a ClearCase Base V2 integration with ClearQuest
    using the ClearQuest Integration Configuration integrations
    utility with the config.pl triggers.
    2) Setup the config.pl to use:
    &SetConfigParm("CQCC_CQWEB_ONLY", "TRUE");
    3) Configure the "Standard" query within the config.pl and have
    CQ records that are within the resultset.
    4) Perform a ClearCase action such as check-in that fires the V2
    config.pl trigger.
    5) See how the "Tk" Graphical User Interface (GUI), or command
    line interface lacks any resultset, though a the same query
    constructed in a CQ client returns results.
    
    Expected result:
    Query results that can be selected for association to complete
    the integration step.
    
    Actual result:
    No results returned, no association can be made.
    
    Also does not work in V2 integration:
    1) "Type in IDs" does not validate the results and thus cannot
    be Associated.
    2) CQ server-side queries (non-local queries) do not display
    when using:
    &SetConfigParm("CQCC_QUERY_ENABLE", "CQ");
    per:
    https://www-01.ibm.com/support/knowledgecenter/SSSH27_8.0.1/com.
    ibm.rational.clearcase.cc_proj.doc/r_bcccq_pol_qryenbl.htm
    3) Unable to verify if assocation and completion of integration
    steps via CM Server integratoin point still works since initial
    selection process is not possible.
    

Local fix

  • Workarounds:
    1) Continue to use a ClearQuest 7.1.2.x CM Server until APAR is
    resolved (unsupported, but may be prudent in collaboration with
    Support).
    2) Use local client based integration, not CM server (CQ Web)
    integration point for V2 config.pl as it continues to work.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * ClearQuest/ClearCase V2 integration                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * If the ClearQuest/ClearCase V2 integration is configured to  *
    * work via the ClearQuest Change Management (CM) Server, it    *
    * fails to return a query result set for selecting             *
    * associations for the integration step.                       *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    

Problem conclusion

  • A fix is available in ClearQuest 8.0.1.8
    If the ClearQuest/ClearCase V2 integration is configured to work
    via the ClearQuest Change Management (CM) Server, it now returns
    a query result set for selecting associations for the
    integration step.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PI40656

  • Reported component name

    CLEARQUEST WIN

  • Reported component ID

    5724G3600

  • Reported release

    801

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2015-05-07

  • Closed date

    2015-06-29

  • Last modified date

    2015-06-29

  • 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

  • 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":"801","Line of Business":{"code":"LOB36","label":"IBM Automation"}}]

Document Information

Modified date:
16 October 2021