Running a report using PHP results in a 500 error after 30 seconds.

[clayton.cowell]

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!

[clayton.cowell]

For anyone else who runs into this issue: It turns out there is a curl timeout in the RESTRequest.php that we are using (3rd party setup).

The curl_timeout variable was set to 30; I increased to 300. Problem solved.