J.P. Morgan Services India PVT Ltd
Last activity: 28 Sep 2017 11:01 EDT
best way to generate excel file with 40000 recrods using MSOGenerateExcel OOTB activity.
We have a requirement to generate excel sheet with 40000 records pulled from database table.
As of now we are doing it using MSOGenerateExcel OOTB activity, we are running Report definition to pull the records from DB and then copying those to pagelist property and then trying to populate those pagelist values to excel sheet.
Till 20000 records it is working fine. But for 40000 records, it is not displaying any error message on screen rather it is just displaying busy indicator for indefinite time and latter there are some thread dumps generating in log files.
We have modified max limit in report definition to 40000 and time also increased in data access tab.
We are using tomcat server.
please let me know what we can modify to get it work with 40000 records?