Sunday, October 16, 2011

Session timeout at Apache 2.2

I have Oracle BI Publisher 10.1.3.4 deployed over Apache Tomcat 7 using it as a reporting tool.
At other hand, there's Apache web server 2.2 used as proxy server and it redirects the reporting requests to Tomcat.


Today I finished building some new report, actually it consumes much time to execute, when try it from BI Publisher that deployed at Tomcat it works perfectly, but when try to access it via the redirector (httpd 2.2) it gives this error:

Proxy Error

The proxy server received an invalid response from an upstream server.
The proxy server could not handle the request GET /xmlpserver///Dialup_Reports/Geographical_Total_Calls/Geographical_Total_Calls.xdo.
Reason: Error reading from remote server

Apache/2.2.3 (CentOS) Server at 31.193.78.197 Port 80
 
Actually that was because of the session timeout of Apache server 2.2 (by default it's 120 seconds) :


So the problem sovled by increasing the "Timeout" value to 600 (5 minutes) and adding "ProxyTimeout 600" directive.
Finally restart the httpd service and it should work well.