PM25336: RQP-DEF-0177 error when exporting to Excel or PDF after installing 8.4.29.1284.

APAR status

• Closed as program error.

Error description

• Customer Environment????Windows Server 2003 Standard Edition
  SP2??Cognos 8.4 FP2 with the Fix file
  up_c8bisrvr_win32_8.4.29.1284_ml.tar.gz from Defect number
  COGCQ00262321??32 bits??Database: SQL Server 2000????After
  customer installs the Fix
  up_c8bisrvr_win32_8.4.29.1284_ml.tar.gz when it try to export a
  especfic report to Excel or PDF file the system shows the error
  below:????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-0236 Left table attribute is not a
  key.RSV-SRV-0042 Trace back:RSReportService.cpp(758):
  QFException: CCL_CAUGHT:
  RSReportService::process()RSReportServiceMethod.cpp(252):
  QFException: CCL_RETHROW: RSReportServiceMethod::process():
  reportRender_RequestRSASyncExecutionThread.cpp(774):
  QFException:
  RSASyncExecutionThread::checkExceptionRSASyncExecutionThread.cpp
  (211):
  QFException: CCL_CAUGHT: RSASyncExecutionThread::run():
  reportRender_RequestRSASyncExecutionThread.cpp(824):
  QFException: CCL_RETHROW:
  RSASyncExecutionThread::processCommand():
  reportRender_RequestExecution/RSRenderExecution.cpp(593):
  QFException: CCL_RETHROW:
  RSRenderExecution::executeAssembly/RSDocAssemblyDispatch.cpp(264
  ):
  QFException: CCL_RETHROW:
  RSDocAssemblyDispatch::dispatchAssemblyAssembly/RSLayoutAssembly
  .cpp(64):
  QFException: CCL_RETHROW:
  RSLayoutAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(331
  ):
  QFException: CCL_RETHROW:
  RSDocAssemblyDispatch::dispatchChildrenAssemblyForwardAssembly/R
  SReportPagesAssembly.cpp(163):
  QFException: CCL_RETHROW:
  RSReportPagesAssembly::assembleAssembly/RSDocAssemblyDispatch.cp
  p(281):
  QFException: CCL_RETHROW:
  RSDocAssemblyDispatch::dispatchAssemblyAssembly/RSPageAssembly.c
  pp(287):
  QFException: CCL_RETHROW:
  RSPageAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(281):
  QFException: CCL_RETHROW:
  RSDocAssemblyDispatch::dispatchAssemblyAssembly/RSTableRowAssemb
  ly.cpp(160):
  QFException: CCL_RETHROW:
  RSTableRowAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(2
  81):
  QFException: CCL_RETHROW:
  RSDocAssemblyDispatch::dispatchAssemblyAssembly/RSTableCellAssem
  bly.cpp(122):
  QFException: CCL_RETHROW:
  RSTableCellAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(
  331):
  QFException: CCL_RETHROW:
  RSDocAssemblyDispatch::dispatchChildrenAssemblyForwardRSResultSe
  tIterator.cpp(1652):
  QFException: CCL_RETHROW:
  RSResultSetIterator::retrieveDataQFSPartialDataset.cpp(67):
  QFException: CCL_RETHROW:
  QFSPartialDataset::GetEdgeIteratorSource/QEDmResultSet.cpp(68):
  QFException: CCL_THROW: QE????
  

Local fix

Problem summary

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

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 REPORT

• Fixed component ID

  5724W12RS

Applicable component levels

• RA10 PSN

     UP