PM68173: PDF PRODUCES DIFFERENT OUTPUT THAN HTML - UNION + QUERY CACHING

APAR status

• Closed as program error.

Error description

• When query caching is enabled, it seems that any report
  containing a union query returns a different result set. The
  union is composed of queries containing the same items, with
  different filter criteria.  It was found that when query caching
  is disabled, the result set is coming back complete. When it is
  on, the union query only seems to bring back data from the first
  query so it is incomplete. individually the sub-queries return
  data.  This is a high profile issue and is candidate for a fix
  per prior discussions with Development on the issue.
  

Local fix

• Disable query caching at the server, package or query level
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All Users                                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See error description.                                       *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to IBM Cognos Business Intelligence 10.1.1 Fix Pack  *
  * 2                                                            *
  * or Upgrade to IBM Cognos Business Intelligence 10.2 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 REPORT

• Fixed component ID

  5724W12RS

Applicable component levels

• RA11 PSN

     UP