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 number
PM88735
Reported component name
COG DATA MGR
Reported component ID
5724W12DM
Reported release
A20
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2013-05-09
Closed date
2014-03-31
Last modified date
2014-03-31
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
RA20 PSN
UP
[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSCRGHB","label":"Data Manager"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"10.2","Edition":"","Line of Business":{"code":"","label":""}}]
Document Information
Modified date:
31 March 2014