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.