PM78482: COGNOS 10.2 - NULLS IN DB2 TABLE BREAKS REPORT IN EXCEL 2007 DATA FORMAT ONLY WITH ERROR

APAR status

• Closed as program error.

Error description

• Cognos 10.2 - Nulls in DB2 table breaks report in Excel 2007
  Data format ONLY with error:??"RSV-SRV-0040 ?      The report
  server encountered an internal error. Check additional
  information associated with this error message. If cause of
  problem cannot be ascertained, increase the logging level in the
  IBM Cognos administration tool and reproduce the conditions that
  caused the error. If the problem persists, see the problem
  determination information on the IBM Cognos Support Portal page
  at
  http://www-947.ibm.com/support/entry/portal/Overview/Software/In
  formation_Management/Cognos_Business_Intelligence.
  ?     Details ?CCLAssertError:0:Fatal: CCL_ASSERT(iter !=
  m_subStringsMap->end(m_memMgr));RSV-SRV-0042 Trace
  back:RSReportService.cpp(766): CCLAssertError: CCL_CAUGHT:
  RSReportService::process()RSReportServiceMethod.cpp(263):
  CCLAssertError: CCL_RETHROW: RSReportServiceMethod::process():
  reportRender_RequestRSASyncExecutionThread.cpp(828):
  CCLAssertError:
  RSASyncExecutionThread::checkExceptionRSASyncExecutionThread.cpp
  (277):
  CCLAssertError: CCL_CAUGHT: RSASyncExecutionThread::runImpl():
  reportRender_RequestRSASyncExecutionThread.cpp(884):
  CCLAssertError: CCL_RETHROW:
  RSASyncExecutionThread::processCommand():
  reportRender_RequestExecution/RSRenderExecution.cpp(670):
  CCLAssertError: CCL_RETHROW:
  RSRenderExecution::executeExecution/RSRenderExecution.cpp(734):
  CCLAssertError: CCL_RETHROW:
  RSRenderExecution::executeRSXlsEngineImpl/RSXLSESharedStrings.cp
  p(214):
  CCLAssertError: CCL_THROW:" ??HTML, PDF, CSV, Excel 2007 normal
  formats work fine. Issue is particular to the "Excel Data
  format".
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All Users                                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See error description.                                       *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to IBM Cognos Business Intelligence 10.2 Refresh     *
  * Pack 1                                                       *
  * or IBM Cognos Business Intelligence 10.2 Fix Pack 2          *
  ****************************************************************
  

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 ADMINISTRAT

• Fixed component ID

  5724W12AD

Applicable component levels

• RA20 PSN

     UP