System.OutOfMemoryException

<< Click to Display Table of Contents >>

EQuIS 7  >>  Professional > Troubleshooting >

System.OutOfMemoryException

Affected Software/Reports/DLL(s): EQuIS Professional, EDP, EDGE, SPM

 

Affected Software Version: N/A

 

Symptoms: An Error of the type:

 

System.OutOfMemoryException: Exception of type 'System.OutOfMemoryException' was thrown...

 

May result during a number of operations such as:

 

Exporting a large dataset (Crosstab, data table or report output) to Excel in the .xlsx format (not .xls, .csv or .txt)

Opening a very large table

Performing a Find and Replace or Remap on a large dataset

Saving a large number of records to the database

 

Cause/Details: This process may be hitting an OutOfMemory exception due to a memory shortage on the system, so the process is not completed.

 

Resolution/Workaround: In order to reduce the likelihood of this error:

 

When opening tables, use the 'Table' option in the drop-down in the Open Menu, then filter for a smaller dataset. You can find more information here.

If possible, when running reports, limit location and analyte selections.

Increase system RAM.

Run EQuIS as a 64-bit process.

Export to Text (instead of Excel) and then choose the *.csv option. Exporting to *.csv uses far less memory, (and is much faster), and the file still opens in Excel (assuming you have your operating system configured to open *.csv files with Excel).