APAR status
Closed as program error.
Error description
The customer is unable to migrate to Cognos BI 10.1 RP1 version. ?The query subject in the project (based on Netezza 6.0.3 db) has defined promptmany() function in filter. The same query subject works in previous versions of Cognos BI.:) When the test sample was run the error occurs:??********************************?This query contains an error and can not be executed.?It is recommended that you view the query feedback on the "Query Information" tab.??RQP-DEF-0177 An error occurred while performing operation 'sqlPrepareWithOptions' status='-9'.?UDA-SQL-0107 A general exception has occurred during the operation "prepare".?Prepared statement not a cursor specification?********************************??When the simple query subject is created: ?select table1.column1 from table1 ?it works (test sample ends with success)?When the simple query subject with promptmany function is defined on SQL 2008 db it works.?
Local fix
NA
Problem summary
**************************************************************** * USERS AFFECTED: * * all users * **************************************************************** * PROBLEM DESCRIPTION: * * See error description. * **************************************************************** * RECOMMENDATION: * * Upgrade to IBM Cognos 10 Business Intelligence 10.1.1 Fix * * Pack 1 * ****************************************************************
Problem conclusion
Code Fix
Temporary fix
Comments
APAR Information
APAR number
PM50831
Reported component name
COG BI FRAMEWK
Reported component ID
5724W12FM
Reported release
A11
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2011-10-25
Closed date
2012-07-24
Last modified date
2012-07-24
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 BI FRAMEWK
Fixed component ID
5724W12FM
Applicable component levels
RA11 PSN
UP
[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSCHNWR","label":"Framework and Map Manager v11x"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"A11","Edition":"","Line of Business":{"code":"","label":""}}]
Document Information
Modified date:
24 July 2012