PI07720: Reports fail with error RQP-DEF-0103 even with governor and all queries set to "Cross Product Allow"

APAR status

• Closed as fixed if next.

Error description

• Upgraded reports that used to work in 8.4.1 now fail in 10.2.1
  FP1 with the following error:??RQP-DEF-0103 Cross joins (between
  query subjects: CurrentMonthDates,RecordablesSectionQuery,
  TestData) are not permitted for the user who has the identity
  '*'??Error occurs even with all queries set with the property
  "Cross Product Allow" set to allow as well as the package
  governor set to Allow cross product joins
  

Local fix

Problem summary

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

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

• RA22 PSN

     UP