PM84089: NATIVE SQL FAILS WITH ORA-32039: RECURSIVE WITH CLAUSE MUST HAVE COLUMN ALIAS LIST (DQM)

APAR status

• Closed as program error.

Error description

• Validating or testing Native SQL fails in Framework Manager if
  the Query Subject has the same name as the underlying table and
  the WITH clause is enabled in the project governors.??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
  "prepare".?ORA-32039: recursive WITH clause must have column
  alias list??This defect is specific to a DQM model type.??This
  is similar to APAR#PM81158
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to IBM Cognos Business Intelligence 10.2.1 Fix Pack  *
  * 1 or IBM Cognos Business Intelligence 10.2 Fix Pack 2 or     *
  * 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

• Fixed component name

  COG FRAMEWRK MG

• Fixed component ID

  5724W12FM

Applicable component levels

• RA20 PSN

     UP