HTTP Server Hangs on Long Running Process
jdanielApr 20 2011 — edited Apr 21 2011Hi,
We are having an issue with our production environment where long running processes i.e. > 5 mins will cause the client application to stop responding. We notice that this is only affecting forms which has no activity during the busy period i.e. forms which call a back end DB procedure or function and waits for a response from the DB to say that the process is done.
Checking on the process itself from the DB shows that the process has completed successfully but somehow there's no response back to the client to say that it's completed. As a result, the client will be in busy status forever.
We are sure that the issue originates from the HTTP server because when we by-pass the HTTP server i.e. send the request directly to the Apps server, this behaviour is not happening.
By thew way, we are running on Oracle Forms 11g using Weblogic.
Changes made so far but to no effect:
maxBlockTime=1800000 (web.xml)
keepAlive=Off (httpd.conf)
Timeout=1800 (httpd.conf)
FORMS_TIMEOUT=60 (formsweb.cfg)
heartbeat=4 (formsweb.cfg)
Session-Timeout=30 (web.xml)
Can this be related to network configuration? If yes, what are the things to look for?
Thanks.