Memory error when processing a spreadsheet in ERM

Symptom

On the Event Log tab in Account Administration in the Microsoft Prodiance Enterprise Risk Management (ERM) web portal, you receive the following error:

Exception of type 'System.OutOfMemoryException' was thrown.  

Cause

There is a 2 GB memory limitation of 32-bit Windows that is reached when the Spreadsheet Processor tries to process a large or complex workbook.

Resolution

Use one of the following solutions to avoid the 32-bit Windows operating system limitation:
  • Install Office 2010 suite 64-bit version on the ERM application server (NOTE: Operating system would have to be Windows Server 2008 64-bit)
  • Break up the Excel workbook into into smaller workbooks that can be processed individually.
Properties

Article ID: 2741546 - Last Review: 8 Mar 2013 - Revision: 1

Feedback