PM57559: LOOKUP FUNCTION FAILS WITH UDA-SQL-0013 INVALID NATIVE SQL ON SUNOS 5.10

APAR status

• Closed as unreproducible in next release.

Error description

• Operating System: SunOS 5.10?Sybase IQ version: Adaptive Server
  Enterprise/15.0.1/EBF 13819, data store-Sybase
  IQ/12.7.0/070906/P/ESD 3)?Sybase IQ ODBC driver: 12.7?Cognos
  version: 10.1.1??When executing a jobstream which contains a
  Condition Node which contains a LOOKUP function, it fails
  with??DM-DBM-0400 UDA driver reported the following on
  connection (name):   ?UDA-SQL-0013 Invalid native SQL was
  detected in the select list.       ??The connection is an ODBC
  connection to a Sybase IQ database with DBMS Type set to Sybase
  IQ.??The problem does not occur with 10.1.1 under Linux or
  Windows.?The problem does not occur with 10.1.0 fp1 on SunOS
  5.10
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All Users                                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See error description.                                       *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to Cognos Business Intelligence 10.2.0               *
  ****************************************************************
  

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

  COG8 BI DATA MG

• Fixed component ID

  5724W12DM

Applicable component levels