PM50831: UNABLE TO MIGRATE PROJECT TO 10.1 RP1 BAZED ON NETEZZA DB

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 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