PM32062: AFTER UPGRADE FROM 8.4.1 FP1 TO 8.4.1 FP3, COUNT AGGREGATION WILL HAVE DIFFERENT SQL, WHICH LEADS TO FALSE RESULTS

APAR status

• Closed as program error.

Error description

• After upgrade from 8.4.1 FP1 to 8.4.1 FP3, a simple count
  aggregation on a data item, results in a different sql that is
  send to the database. This change in sql leads to a false result
  in the report output.?For example when the count should result
  in 0, an empty result is shown.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All Users                                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See error description.                                       *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to IBM Cognos Business Intelligence 10.1 Refresh     *
  * Pack 1 or Upgrade to IBM Cognos 8 Business Intelligence      *
  * 8.4.1 Fix Pack 4                                             *
  *                                                              *
  * Update:                                                      *
  * Client upgrade from 8.4.0 to C10 RP1 and has encountered     *
  * this issue.                                                  *
  * Client removes [--having count(*)>0] and the report works as *
  * it should.                                                   *
  * This scenario reflects the same conditions as stated in this *
  * APAR hence the reopen.                                       *
  *                                                              *
  *                                                              *
  *                                                              *
  * or Upgrade to Cognos Business Intelligence 8.4.1 Fix Pack 4  *
  ****************************************************************
  

Problem conclusion

• The new behavior is a result of a bug fix to ensure consistency
  when counting is used with an empty restful set context. Sincere
   there are no rows returned, the count yields no results.
  
  See detail for recommended solutions.
  

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

  COG8 BI REPORT

• Fixed component ID

  5724W12RS

Applicable component levels

• R841 PSN

     UP