Friday 25 September 2009

FRM-92050: Failed to connect to the server

FRM-92050: Failed to connect to the server:/forms/lservlet-1 java.io.IOException:Server returned HTTP response code 500 for URL

or 500 Internal server error "Too many open files"

Many users received this FRM-92050: Failed to connect to the server:/forms/lservlet-1 error from yesterday. The error appeared on and off.

This error seems to be a bug.

The cause of the error is as given below

The form runtime does not release the configuration files like environment files. The config files are locked and the new connections are trying to open these files at the same time. This causes the error "Too many open files"

Solution:

Oracle suggests to set a hidden parameter(undocumented parameter) for this bug.

"Waittime" parameter sets the time in milliseconds for the Forms applet to wait before retrying with the request. The default value (500 mS) should suit most deployments. How ever if your windows server cannot cope with the load then increase the value of this parameter. eg: 5000 milliseconds(5 seconds).

Metalink reference - Doc ID: 390176.1

To set the parameter on the OAS,

1.Go to $ORACLE_HOME\j2ee\OC4J_BI_Forms\applications\formsapp\formsweb\WEB-INF\ directory and open web.xml file in notepad and add the parameter.


2. Save the file and open the formsweb.cfg file and add WaitTime=5000

3. Save and restart the OC4J_BI_FORMS on the Oracle Application Server.

No comments: