Memory error when processing a spreadsheet in ERM


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.  


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.


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.

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