Knowledgebase: FAQ
[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.

System.OutOfMemoryException

Solution:

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))
Helpful
Not helpful

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