[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 export data from QXL. I have selected Transaction & other tables from "Table Setting" tab. After that, I click on QXL export button I got below error message after export.



You will get above error if your table contains a large amount of data.

As your table contains a large number of records, You need to put limits on your query & export data.

So you need to execute query through custom query.

You need to write table name in Custom Table Name box & write the query in Custom Query box. After writing table name & query click on "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 different date period.

After adding 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).