PI13272: Updated data is not reflected to the report when using Dynamic Query Mode and query package

APAR status

• Closed as program error.

Error description

• As per the following description in IBM Cognos Dynamic Query
  Redbook, it appears that cached data are cleared after the idle
  timeout of data source connections when using DQM and Query
  package. ??------?Results from pure relational queries are
  retained in memory only while the data source connection remains
  open. This is different from dimensional queries, such as those
  for DMR packages, which, as of Cognos BI version 10.2, persist
  in-memory until a manual or scheduled clear cache operation
  occurs. Query service data source connections have a default
  idle timeout of 300 seconds (5 minutes), but this can be set to
  a different value using the Properties window of the query
  service in Cognos Administration. For details about modifying
  these properties, see the product information center:
  ?------??http://www.redbooks.ibm.com/redbooks/SG248121/wwhelp/ww
  himpl/js/html/wwhelp.htm?(Go
  to Chapter2. Administration --> 2.3 Cache management --> 2.3.2
  Clearing the cache --> Pure relational caching)??However,
  updated data is not reflected to the report even though data of
  data source is updated and wait in seconds set to data source
  connections idle timeout.??(Environment)?Cognos BI 10.2.1 + FP2
  -- reproduced. ?Cognos BI 10.2.0 + FP1 -- reproduced. ?
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All Users                                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See error description.                                       *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to IBM Cognos Business Intelligence 10.2.0 Fix Pack  *
  * 4 or upgrade to IBM Cognos Business Intelligence 10.2.1 Fix  *
  * Pack 5                                                       *
  ****************************************************************
  

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

  COG CONNECTION

• Fixed component ID

  5724W12CC

Applicable component levels

• RA20 PSN

     UP