PM61021: UDA-SQL-0564 [MICROSOFT OLE DB PROVIDER FOR SQL SERVER]THE MULTI-PART IDENTIFIER "W1.C1" COULD NOT BE BOUND.

APAR status

• Closed as program error.

Error description

• The native SQL expression that has a column reference is no
  longer valid after the query was flattened in UDA.????SQL>
  prepare r1001 from "??SQL>??SQL> select W1.C1??SQL> from (
  select T1.COUNTRY C1 from dbo.COUNTRY T1 ) W1??SQL> where
  {W1.C1} = 'Canada'??SQL>??SQL> " in t1001 macrovaluecallback,
  collate "en", disable metadata cache, limited local, avoid zero
  division;??Error in sqlPrepareWithOptions????UDA-SQL-0115
  Inappropriate SQL request.??UDA-SQL-0564 [Microsoft OLE DB
  Provider for SQL Server]Deferred prepare could not be
  completed.??UDA-SQL-0564 [Microsoft OLE DB Provider for SQL
  Server]Statement(s) could not be prepared. ??UDA-SQL-0564
  [Microsoft OLE DB Provider for SQL Server]The multi-part
  identifier "W1.C1" could not be bound.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All Users                                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See error description.                                       *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to Cognos BI Server 10.2                             *
  *  or  Upgrade to IBM Cognos Business Intelligence 10.1.1 Fix  *
  * Pack 2                                                       *
  ****************************************************************
  

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

• RA11 PSN

     UP