PM79523: XQE-PLN-0084 ERROR WHEN RUNNING COGNOS 10.2 BI REPORT AGAINST INFORMIX DQM PACKAGE

APAR status

• Closed as fixed if next.

Error description

• Report works ok in Conventional Query Mode, but fails in Dynamic
  Query Mode with error:?---?XQE-PLN-0084 SQL cannot be generated,
  because the filter condition '[xxxxx xxxx]>0' could not be
  applied to the following fact stream which does not contain a
  fact projection:(x_xxxl_index).?---??Filter 'Application'
  property is set 'Before Auto Aggregation' for filter
  '[Meetplaats Index Aantal]>0' in one of the prompt queries. In a
  DQM when setting filter to be applied after aggregation, report
  works. ??Tested with IBM Cognos 10.2 64bit against Informix 1170
  xc6 via 3.70 Native and JDBC clients.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All Users                                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See error description.                                       *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to IBM Cognos Business Intelligence 10.2 Refresh     *
  * Pack 1                                                       *
  ****************************************************************
  

Problem conclusion

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

Applicable component levels

• RA21 PSN

     UP