PM25171: REPORTS RETURNING NO DATA AFTER UPGRADE TO COGNOS 8.4.1

APAR status

• Closed as program error.

Error description

• The Environment has been upgraded from Cognos BI 8.2 to 8.4.1.
  Two reports are not retrieving data in 8.4.1, all others reports
  run properly. The database is MS SQL 2005. ????The SQL being
  generated is different for the reports in 8.2 than when run in
  8.4.1from one environment to the other.   ????All data source
  connections test successfully.  Model verifies successsfully.
  No error messages appear when running the report in 8.4.1.
  Recreating the report in 8.4.1 successfully returns data.
  Removing filters on reports in question returns no data.
  

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                                                       *
  ****************************************************************
  

Problem conclusion

• Code Fix
  

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 COG CON

• Fixed component ID

  5724W12CC

Applicable component levels

• RA11 PSN

     UP