PM41614: REPORT WRITING TO EXCEL 2007 WITH OVER 1,000,000 CELLS FAILS WITH CCLOutOfMemoryError and RSV-SRV-0040

APAR status

• Closed as program error.

Error description

• Report with over 1,000,000 cells fails with CCLOutOfMemoryError
  when run as Excel2007.  Please note that the same report renders
  when run as PDF.    CCLOutOfMemoryErrorRSV-SRV-0040 - An
  application error has occurred. Contact your Administrator.
  CCLOutOfMemoryError:0:Fatal: RSV-SRV-0042 Trace
  back:RSReportService.cpp(797): CCLOutOfMemoryError: CCL_CAUGHT:
  RSReportService::process()RSReportServiceMethod.cpp(265):
  CCLOutOfMemoryError: CCL_RETHROW:
  RSReportServiceMethod::process():
  asynchWait_RequestRSASyncExecutionThread.cpp(788):
  CCLOutOfMemoryError:
  RSASyncExecutionThread::checkExceptionRSASyncExecutionThread.cpp
  (224):
  CCLOutOfMemoryError: CCL_CAUGHT: RSASyncExecutionThread::run():
  asynchRunSpecification_RequestRSASyncExecutionThread.cpp(838):
  CCLOutOfMemoryError: CCL_RETHROW:
  RSASyncExecutionThread::processCommand():
  asynchRunSpecification_RequestExecution/RSRenderExecution.cpp(61
  3):
  CCLOutOfMemoryError: CCL_RETHROW:
  RSRenderExecution::executeExecution/RSRenderExecution.cpp(1075):
  CCLOutOfMemoryError: CCL_RETHROW:
  RSRenderExecution::processActiveDocumentsRSXls2007OutputDispatch
  .cpp(463):
  CCLOutOfMemoryError: CCL_RETHROW: CCLFixedMemoryPool.cpp(208):
  CCLOutOfMemoryError: CCL_THROW:     As per discussion with Luc
  Bertin, this problem needs to be addressed.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All Users                                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See error description.                                       *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to IBM Cognos Business Intelligence 10.1 Refresh     *
  * 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

  COG8 BI REPORT

• Fixed component ID

  5724W12RS

Applicable component levels

• RA11 PSN

     UP