PM73671: UDA-SQL-0459 AMBIGUOUS COLUMN REFERENCE IS USUALLY CAUSED BY TRYING TO SELECT UNNAMED COLUMNS OR WHEN THERE ARE DUP COL NAME

APAR status

• Closed as fixed if next.

Error description

• An expression in the projection list is in-correctly decomposed
  during summary filter transformation.  The decomposed expression
  does not have any column information, and causes error
  UDA-SQL-0459 when the native SQL is generated.??Full
  error:?RQP-DEF-0177 An error occurred while performing
  operation?'sqlPrepareWithOptions' status='-459'. UDA-SQL-0459
  Ambiguous column?reference is usually caused by trying to select
  unnamed columns or when?there are duplicate column names.?
  

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  or Upgrade to IBM Cognos Business Intelligence 10.2  *
  * Fix 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