Hello,
I am trying to export large number of entity data to excel file, around 100k records on 1 click. While doing that i am getting connection timeout error. The server action is inside separate service module and I am calling that action in end user module inside web block. I have increased the server timeout to 60s for the end user module.
I want suggestions on how to overcome this issue.
Hi,
To add more detail to what Kilian correctly suggest as an answer I have some suggestions on how to solve this.
Use the timer to process the data and generate the excel. Choose to store the generated excel in the OutSystems database and make a screen where the user can downloaded the generated file.
Alternatively you could use an external file storage like AWS S3 buckets, Azure Blob, SharePoint, OneDrive, Google drive or old school FTP server where you save the generated file.
For all the external file storage i mentioned prebuild OutSystems connectors are available in the OutSystems Forge.
Regards,
Daniel
Hi Daniel, Thank you for the more detailed information. It really helped. For now I am storing the generated file inside Outsystems database. Later on I will try saving those files to an external storage.
Good luck!
Hi Kunal,
If the time-outs are indeed caused by creating the Excel, then I'd advise you to create it by a timer, then let the user download it via a download screen or the like.
Hi Kilian, Thanks for the immediate response. Your suggestion worked for me. Instead of processing all the data and exporting it in one go, I used timer and created a separate screen where user can download the excel file.
Great you got it solved! Happy coding!
@Kunal Khedekar hello am also facing the same issue in a entity i have 6 lack records can you share a oml file for a better understanding of the proccess