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.