PM88735: UNABLE TO RETURN VALUES FROM SQL SERVER TEMP TABLES

APAR status

• Closed as program error.

Error description

• A procedure node that uses a SQL function to create a temp
  table, a second SQL function to insert a row into the temp
  table, and then a Lookup expression to return the value and
  assign it to a variable fails in DM 10.2 with the following
  error:??UDA-SQL-0564 [Microsoft SQL Server Native Client
  10.0]Invalid object name '#<temp_table_name>'. (SQLSTATE=42S02,
  SQLERRORCODE=208)??The same procedure node works fine if used in
  Data Manager 8.4.1 FP2 to FP5?
  

Local fix

Problem summary

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

  COG DATA MGR

• Fixed component ID

  5724W12DM

Applicable component levels