[DSP] Data Parsing Error ”System.OutOfMemoryException was thrown”

Issue

When processing a report, this error displays:

“" Data Parsing Error; ColumnDelimiter: ; TextQualifier: ž : Exception of type 'System.OutOfMemoryException' was thrown"”

Solution

1. Reset IIS.
2. Restart the CranSoft/DSP service.
3. Validate the CranSoft data source. On the Data Sources page in System Administration, click the Status icon (S) for the data source.
4. Clear cache by navigating to Admin > Configuration > Parameters > Clear Cache.//
   
   

Please note:

This problem will likely reappear under heavy load until the DSP is upgraded to 6.6 (or later) and switched to 64-bit mode.

Further helpful notes to consider:
Large Transform reports can create a great deal of memory pressure on the associated DSP background service. Often the first OOM error from a large Transform report will cause many more to come until the associated Service is restarted. This is because the process thread that throws the error does not seem to be disposed, locking up all the memory it was using and making future OOM errors much more likely.

Options to minimize the recurrence of this problem until the move to 64-bit can be achieved are:

1. Run fewer Transform reports simultaneously (if you are often running several at once).

2. Cut larger Transform reports into smaller ones that would run single-threaded.