PI84142: QUERY RETURNS INCORRECT RESULT SET IF CHILDRECORD.STATE IS ADDEDAS DISPLAY FIELD

Rational ClearQuest Fix Pack 5 (9.0.0.5) for 9.0
Rational ClearQuest Fix Pack 1 (9.0.1.1) for 9.0.1
Rational ClearQuest Fix Pack 2 (9.0.1.2) for 9.0.1
Rational ClearQuest Fix Pack 6 (9.0.0.6) for 9.0
Rational ClearQuest Fix Pack 3 (9.0.1.3) for 9.0.1
Rational ClearQuest Fix Pack 4 (9.0.1.4) for 9.0.1
Rational ClearQuest Fix Pack 5 (9.0.1.5) for 9.0.1
Rational ClearQuest Fix Pack 6 (9.0.1.6) for 9.0.1
Rational ClearQuest Fix Pack 7 (9.0.1.7) for 9.0.1
Rational ClearQuest Fix Pack 8 (9.0.1.8) for 9.0.1
Rational ClearQuest Fix Pack 9 (9.0.1.9) for 9.0.1

APAR status

• Closed as program error.

Error description

• A query on parent records with child references returns
  incomplete results when the child record State field is added as
  a display field.
  Parents that have no child reference (i.e. where Child.State is
  empty) are not returned.
  
  Reproduction Steps in a DefectTracking schema with
  EnhancementRequest package applied.
  
  1-- Create a new field on the Defect record called
  'EnhancementRequest' TYPE Reference to EnhancementRequest record
  type
  2-- Add a Combo Box control on the Defect Base form and set
  EnhancementRequest as Field Name
  3-- Check in schema and upgrade database
  4-- Open ClearQuest Native client and connect to the above
  repository
  5-- Submit EnhancementRequest record(s)
  6-- Add a reference to an EnhancementRequest on a Defect record
  7-- Modify the 'All Defects' query by adding
  EnhancementRequest.State as display field
  8-- Run the query
  
  Result:- The result set ONLY returns records that have an
  EnhancementRequest.State value
  
  This behaviour was fixed for Feature Level 8 schemas but appears
  again with Feature Level 9.
  

Local fix

• Please see technote#2007390 for additional information.
  http://www.ibm.com/support/docview.wss?uid=swg22007390
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * ClearQuest                                                   *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * Adding the State field of a child record to a query causes   *
  * the result set to not include any records where the child    *
  * reference field does not have a value.                       *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  

Problem conclusion

• A fix is available in ClearQuest 9.0.0.5 and 9.0.1.1
  The issue has been fixed so that the result set includes records
  with an empty child reference field.
  
  Upgrading to Feature Level 9 with this APAR fix will not cause
  the problem described to occur.
  Upgrading to Feature Levels newer than 9, when available, will
  also address this issue even if it is being encountered pre-FL8
  or in databases that were impacted that had upgraded to FL9
  previously.
  If currently at Feature Level 9 and impacted, and you do not
  wish to upgrade to a newer Feature Level when available, you may
  contact Support for a permanent fix involving a SQL statement
  for FL9.
  

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 WIN

• Fixed component ID

  5724G3600

Applicable component levels

• R801 PSY

     UP