We have a synced entity based records with 13,000 and 50,000 rows respectively. However when trying to export the excel from the record list without applying filters will not do anything (not downloading even a blank excel), However in some cases applying filters download the excel but sometimes not.
I looked into tomcat-stdOut.log I see this error message.
2024-03-28 17:52:52 WARNING [http-nio-8080-exec-558] com.sun.jersey.spi.container.servlet.WebComponent.filterFormParameters A servlet request, to the URI example.appiancloud.com/.../download-grid, contains form parameters in the request body but the request body has been consumed by the servlet or a servlet filter accessing the request parameters. Only resource methods using @FormParam will work as expected. Resource methods consuming the request body by other means will not work as expected.
Not sure how to resolve this or what needs to be corrected. Any ideas or suggestions?
Discussion posts and replies are publicly visible
Hi Radhika ,How did you resolve this issue? We are facing the same issue in our records now. Only workaround which we see now is to create a custom process to generate this excel. But before that we need to know if this issue can be fixed.
Hi jagadeshkumarrk362091 I did resolve the issue. The problem was with the data. There was one column which was calculating values at run time, it was not coming directly from database. The expression to calculate that column was complex plus there was lot of records which eventually broke the export to excel. What we did is once we knew that column was culprit instead of doing calculations on load or export we created a batch process to update it nightly and save the result in database. It solved the issue and it started working fine.
But the issue was not desktop specific for us. It was not consistent because sometimes after applying the filters data the column expression rule used to skip lot of conditions and worked faster.