I have been struggling with this for days now.
We are running a report that can, at times, take about 60 seconds to run (this is all query time to MySQL). When run on a short date range, I can get the report to return to our web application - as long as the MySQL query takes under 30 seconds. Anything more than that, and I get a 500 error - however, the query does keep on running after the browser has "given up" - I can see it on the server.
Running the report via the Jasperserver Web UI works all the time, no matter the length of the query.
I have changed httpd.conf settings to try to keep the conneciton alive, tried changing server.xml settings in tomcat - no result.
Has anyone lese experienced this problem? I feel like I am at my wits end here. Any help would be appreciated. Thanks!