[QXL-ALL] Troubleshooting - QXL Error System.OutOfMemoryException
Posted by Jack - QODBC Support on 06 April 2017 12:12 PM
Troubleshooting - QXL Error System.OutOfMemoryException
I am trying to export data from QXL. I have selected Transaction & other tables from the "Table Setting" tab. After that, I clicked on the QXL export button I got the below error message after export.
You will get the above error if your table contains extensive data.
As your table contains many records, You need to put limits on your query & export data.
So it would be best if you executed the query through a custom query.
You need to write the table name in the Custom Table Name box & write the query in the Custom Query box. After writing the table name & query, click on the "Add or Update" button to add the query.
Same way, You can add the query for the different date periods.
After adding the query, Please try to export again.