FRM-92102 Network error on forms client in AS10g

Recently, I got a complaint from my AS10g users, that they are facing frequent disconnection with the server. May be due to network distruption.

The error stack was:

FRM-92102: A network error has occurred.The Forms Client has attempted to reestablish its connection to the Server 5 time(s) without success.Please check the network connection and try again later.Details...Java Exception:oracle.forms.net.ConnectionException:500at oracle.forms.net.ConnectionException.createConnectionException(Unknown Source)at oracle.forms.net.HTTPNStream.getResponse(Unknown Source)at oracle.forms.net.HTTPNStream.doFlush(Unknown Source)at oracle.forms.net.HTTPNStream.flush(Unknown Source)at java.io.DataOutputStream.flush(Unknown Source)at oracle.forms.net.StreamMessageWriter.run(Unknown Source)

I got an usefull hint on forums.oracle.com for the same problem.

It suggested to change the ping timeout to a higher value.

I had to do the following changes to opmn.xml under $ORACLE_HOME/opmn/conf

Find the process-type tag with id="OC4J_BI_FORMS" module-id="OC4J". Under this process-type tag, go to the category tag with the id="urlping-parameters". Replace the line

data id="/reports/rwservlet/pingserver?start=auto" value="200"

with

data id="/forms90/l90servlet" value="200"

Then, under the line

restart timeout="720" retry="2"

add:

ping timeout="300" interval="20" (as xml tag)

After doing the changes, restart the opmn.

I got this hint in

http://forums.oracle.com/forums/thread.jspa?threadID=323306&start=15&tstart=0

But, they have provided this solution for forms 9i. We have to change a few parameters according to AS10g environment.

Post your suggestions/feedback.

1 comment:

  1. sir, as per your suggestion and from the link provided i did follow all the steps mentioned as i also face the same error message when i use oracle 10g with forms and reports 9i in linux environment. But i am not able to resolve it and the same error still persits. could you pl help me out

    thanks in advance

    ReplyDelete

Kindly make your valuable and progressive comments here.
Junks will be deleted without notice :-)

  Find below few useful scripts for  Performance  Management:: # Important MOS notes for TRACING: There are several ways to trace a particul...