IBM Support

PI44086: CQRPC PROCESS ABORTS WHEN RUNNING A VERY LARGE QUERY

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • When a CQWeb user runs certain very large or complex queries the
    CQRPC process crashes.  If the query is too complex, CQ Web
    should fail more gracefully and should not crash the cqrpc
    process.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * ClearQuest Web                                               *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * Running Oracle queries that contain extremely long SQL       *
    * statements can crash Clearquest processes (clearquest,.exe,  *
    * cqrpc.exe...) and/or irreversibly sever the Oracle           *
    * connection.                                                  *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    

Problem conclusion

  • A fix is available in ClearQuest 8.0.1.12 and 9.0.0.2
    If a lengthy SQL query is run in ClearQuest against Oracle, it
    will no longer crash the process regardless of its size.  If the
    query is large enough that it causes an "Oracle Connection is
    Dead" server error, the user will be warned appropriately and
    the database connection will be re-established.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PI44086

  • Reported component name

    CQ&CQ MSITE WIN

  • Reported component ID

    5724G3800

  • Reported release

    801

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2015-06-30

  • Closed date

    2016-09-22

  • Last modified date

    2016-09-22

  • 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

    CQ&CQ MSITE WIN

  • Fixed component ID

    5724G3800

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:
15 October 2021