Knowledgebase: QXL Support
[QXL-ALL] Troubleshooting - QXL Error System.OutOfMemoryException
Posted by Jack - QODBC Support on 06 April 2017 12:12 PM

Troubleshooting - QXL Error System.OutOfMemoryException

Problem Description:

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.

For Example:
select * from Transaction where TxnDate >= {d '2016-10-01'} AND TxnDate <= {d '2016-11-01'}

Same way, You can add the query for the different date periods.

After adding the query, Please try to export again.


(0 vote(s))
Not helpful

Comments (0)
Post a new comment
Full Name:
CAPTCHA Verification 
Please complete the captcha below (we use this to prevent automated submissions).