PM52112: COGNOS NEEDS TO BE CYCLED WHENEVER NETEZZA IS CYCLED

APAR status

• Closed as program error.

Error description

• When the Netezza reporting database server becomes temporarily
  unavailable, then comes back online, the Cognos service needs to
  be recycled before any further reports can be run against it.
  The BIBus processes never time out as they should, and new
  reports error out with:  RQP-DEF-0177 An error occurred while
  performing operation 'sqlOpenResult' status='-28'. UDA-SQL-0114
  The cursor supplied to the operation "sqlOpenResult" is
  inactive. UDA-SQL-0107 A general exception has occurred during
  the operation "openresult". ERROR:  Transaction rolled back due
  to restart or failover UDA-SQL-0532 Data Source is not
  accessible: 'invalid datasource'. Communication link failure
  </message> RSV-SRV-0066 A soap fault has been returned.
  RQP-DEF-0177 An error occurred while performing operation
  'sqlPrepareWithOptions' status='-123'. UDA-SQL-0532 Data Source
  is not accessible: "invalid data source". Communication link
  failure
  

Local fix

• restart cognos OR kill all bibus
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All Users                                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See error description.                                       *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to IBM Cognos 8 Business Intelligence 8.4.1 Fix Pack *
  * 5                                                            *
  ****************************************************************
  

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

  COG8 BI COG CON

• Fixed component ID

  5724W12CC

Applicable component levels

• R841 PSN

     UP