PM06838: [UPG] AFTER UPGRADE FROM 8.2 TO 8.4.1 AN ADDITIONAL QUERY IS SEND WITHOUT WHERE CLAUSE

APAR status

• Closed as program error.

Error description

• After upgrade from Cognos 8.2 to Cognos 8.4.1, the customer is
  experiencing, that opening a analysis does takes extremely long,
  in comparism to Cognos 8.2. The analysis contains a crosstab
  with several context filters.
  The UDA traces showed that in front of all the queries that were
  send to the database in C8.2, there is an additional query in
  8.4.1 which requests all data and is not limited by the where
  clauses.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All Users                                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See error description.                                       *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to IBM Cognos Business Intelligence 10.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 ANALY S

• Fixed component ID

  5724W12AS

Applicable component levels

• RA10 PSN

     UP