IBM Support

PI83190: LIST-VIEW COMBINES RESULTS FROM TWO QUERIES

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • If a list view query takes more than a few seconds to produce a
    result set, users may start the execution of another query and
    this ends up in the combination of the output from both queries,
    using the columns that are defined in the query that finishes as
    second.
    Typically there may be two queries, one of them running slow and
    the other one being faster. Users start the slow one and then
    start the faster one. Then they get the result set produced by
    the fast query and a few seconds the results from the slow query
    appear, at the same time that the columns defined in the fast
    query are replaced by the columns defined in the slow query.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * ClearQuest Web                                               *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * If a ClearQuest Web List View Query takes more than a few    *
    * seconds to produce a result set, users may start the         *
    * execution of another query.  This could end up in a scenario *
    * where the List View output combines columns from both        *
    * queries.  The faster query results are replaced by the       *
    * columns defined in the slower query.                         *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    

Problem conclusion

  • A fix is available in ClearQuest 9.0.1.4
    In the scenario described, it is no longer possible to run a
    different ClearQuest Web List View Query query while the
    original one is still executing, thus avoiding the issue.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PI83190

  • Reported component name

    CLEARQUEST WIN

  • Reported component ID

    5724G3600

  • Reported release

    801

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2017-06-16

  • Closed date

    2018-08-14

  • Last modified date

    2018-08-14

  • 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 & Data Platform"},"Product":{"code":"SSSH5A","label":"Rational ClearQuest"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"801","Line of Business":{"code":"LOB45","label":"Automation"}}]

Document Information

Modified date:
19 October 2021