Return
-
Title
"Out of Memory" error when exporting data. -
Description
It's possible to export returned data to a delimited text file normally without issues. However, if exporting millions of rows with hundred columns, an "Out of Memory" error is generated. Doing partial data returns is an option; however it is not efficient.
The PC has plenty of RAM memory and processing power, but still the error appears.
Error might also show when exporting using "Excel File" option from "Export Dataset" wizard.
-
Resolution
WORKAROUND 1:
In the 'Export Data' dialogue window in the Options tab, uncheck the option 'Display all results in grid'.WORKAROUND 2:
Use "Excel Instance" option instead of "Excel File" from the "Export Dataset" wizard.