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 / Xsystem
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
[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSTSF6","label":"Cognos Analytics"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"A20","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
04 September 2024