In our application, we are using a SOAP service to invoke the java from websphere which will generate the excel file, and will upload to the content manager as a zip file to reduce the downloadable file size.
System generate a report with around 80 columns and 65K or more records depends on user entries. If the entries are more than 66K, xls file will not accommodate and will fail. Hence system enhancement was made to generate reports in xlsx format to increase the row count, but here we are facing many problems like time out issue, memory issues, hung thread creation, etc., we increased the SOAP response time and increased the server memory, still when we are trying for 100K records for testing its failing of memory issue and hung threads creation, application becomes fully down at this time. Can anyone please suggest any alternative way for creating this report.