PI96554: REPORT EXECUTION IS DIFFERENT DEPENDING ON DISTRIBUTION OF THE ENVIRONMENT

APAR status

• Closed as suggestion for future release.

Error description

• Report execution is different depending on the distribution of
  the environment. A distribution with ATC only, CM only and
  Frontdispatcher results in an error for some reports, and high
  memory usage or out of memory errors for other reports in
  Dynamic Query Mode. A slightly different distribution, with just
  one presentation service on the front dispatcher, but not on the
  report service is allowing to execute the same reports without
  the error or the memory usage.
  
  
  The customer is expecting the error less execution and the
  execution with less memory in both cases.
  This can be reproduced in the latest of 10.2.1, 10.2.2 and
  Cognos Analytics.
  

Local fix

Problem summary

Problem conclusion

Temporary fix

Comments

• The behaviour observed is design intent.
  
  There are two Model Data Sources 'CoREx_Monatsbericht' and
  'CoREx_Monatsbericht1' which reference the same Content Manager
  Data Source 'CoREx_Monatsbericht'.
  
  The QuerySubject [Data Layer].[Umgebung] has SQL which
  references the table DUAL in the schema SYS. Since either of the
  model data sources can be used to retrieve the data for this
  querysubject if both of the model data sources are currently
  active during query execution then the planning code will return
  an error because it is unclear which Model Data Source to use.
  
  The solution is to explicitly reference the Model Data Source to
  be used in the SQL for the querysubject.
  
  This involves changing the SQL in the querysubject from:
  
      SELECT
      lower(sys_context('userenv','db_name',10)) AS Datenbank_Name
      FROM SYS.DUAL
  
  To:
  
      SELECT
      lower(sys_context('userenv','db_name',10)) AS Datenbank_Name
      FROM CoREx_Monatsbericht..SYS.DUAL
  

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

Applicable component levels