PM34680: Clearquest Choice-list hook calling BuildQuery API doesn't return full resultset if it exceeds HARD_QUERY_LIMIT

Rational ClearQuest Fix Pack 2 (8.0.1.2) for 8.0.1
Rational ClearQuest Fix Pack 4 (8.0.1.4) for 8.0.1
Rational ClearQuest Fix Pack 5 (8.0.1.5) for 8.0.1
Rational ClearQuest Fix Pack 6 (8.0.1.6) for 8.0.1
Rational ClearQuest Fix Pack 7 (8.0.1.7) for 8.0.1
Rational ClearQuest Fix Pack 8 (8.0.1.8) for 8.0.1
Rational ClearQuest Fix Pack 9 (8.0.1.9) for 8.0.1
Rational ClearQuest Fix Pack 10 (8.0.1.10) for 8.0.1
Rational ClearQuest Fix Pack 11 (8.0.1.11) for 8.0.1
Rational ClearQuest Fix Pack 12 (8.0.1.12) for 8.0.1
Rational ClearQuest Fix Pack 13 (8.0.1.13) for 8.0.1
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

APAR status

• Closed as program error.

Error description

• In CQ 7.1.*, you can set query limits like HARD_QUERY_LIMIT,
  SOFT_QUERY_LIMITT to restrict the resultset  by a query. This is
  especially useful in web to tackle stability issues. It is
  recommended that customers set up query limits to prevent
  CMserver crashes when users run huge queries. Unfortunately,
  this can affect queries using the API and called in hooks, or
  choice-list hooks referencing users etc.
  
  There should be a way to get the full restultset that exceeds
  the query hard limit if explicitly requested in a  hook.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  ClearQuest choice list hooks which call the BuildQuery API
  do not return the full result set if it exceeds the
  HARD_QUERY_LIMIT value.
  

Problem conclusion

• A fix is available in ClearQuest 8.0.1.2.
  
  The SetMaxResultSetRows() API can now be added to your
  ClearQuest choice list hook to allow the query row count to
  exceed the HARD_QUERY_LIMIT value.
  

Temporary fix

Comments

APAR Information

• 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 UNIX

• Fixed component ID

  5724G3601

Applicable component levels

• R711 PSN

     UP