Excel Export is failed with system error message

0
Hi,   I am retrieving a table using  sql because of its complexity, where many subqueries. The sql takes 2 to 3 minutes to retrieve.  It is failing while exporting to excel.   As per my observation it is getting exported where RAM is 64GB.   Kindly guide me.   Regards Sudhir  
asked
5 answers
0

Limit your data below 4000 records and try.

answered
0

Hi Ajay

 

I can't do that. It is a report. User need all data.

 

Regards

Sudhir

answered
0

Look at the execution plan and improve the query or add indexes.

answered
0

You may try this module https://marketplace.mendix.com/link/component/231011 to improve the performance of the export

answered
0

Sudhir,

 

You may try Zip module here. Generate the report in multiple files and download them as zip.

 

Iqbal.

answered