PM19872: UNABLE TO TEST DATA ITEMS FROM MULTIPLE QUERY SUBJECTS WITH NO DIRECT JOIN WHEN UNION IS USED

APAR status

• Closed as program error.

Error description

• When a union is used to build a database query to bring data
  into a query subject and there is no direct join to another
  query subject you can not test the two query subjects together.
  If you remove the union the issue goes away. The error from
  framework manager is: ????This query contains an error and can
  not be executed.????It is recommended that you view the query
  feedback on the "Query Information" tab.????RQP-DEF-0177 An
  error occurred while performing operation
  'sqlPrepareWithOptions' status='-9'.??UDA-SQL-0107 A general
  exception has occurred during the operation
  "sqlPrepareWithOptions".????Reproducible on all versions of 8.4
  and 8.4.1????See testcase for logs, cmplst, databases exports
  and FM model and how to reproduce
  

Local fix

Problem summary

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

• RA21 PSN

     UP