[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.

System.OutOfMemoryException

Solution:

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 in 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 query for different date period.

After adding query, Please try to export again.

 

(0 vote(s))
Helpful
Not helpful

Comments (0)
Post a new comment
 
 
Full Name:
Email:
Comments:
CAPTCHA Verification 
 
Please enter the text you see in the image into the textbox below (we use this to prevent automated submissions).