Skip to Main Content

Integration

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

HTTP Server Hangs on Long Running Process

jdanielApr 20 2011 — edited Apr 21 2011
Hi,

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.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 19 2011
Added on Apr 20 2011
6 comments
2,279 views