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.

at

1 comment:

  1. lakshminarayanNovember 1, 2011 at 9:44 AM

    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 :-)

Subscribe to: Post Comments (Atom)

 SPACE MANAGEMENT :: 1. Table space usuage: ============== SELECT tablespaces.tablespace_name,          allocated.total_alloc allocated_mb, ...

  • adapcctl.sh: exiting with status 204
    On a new VIS R12.1 installation, the OHS (oracle http server) failed to start and give status 204. Upon querying the status of opmn manage...
  • (no title)
    A nice story about RMAN.           The story begins,  when one of my associate DBAs did an RMAN restoration & recovery 2 days back...
  • 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 distrupt...