This discussion is archived
10 Replies Latest reply: Oct 19, 2012 12:47 AM by sank_nk RSS

FRM-92102

sank_nk Newbie
Currently Being Moderated
I am getting this error message when i am trying to upload data into an excel sheet. The form works fine for few records, but if the number of records is some where around 100 then i get this error FRM-92102 A network error has occured. I am running on a standalone, so the appserver opmn file changes do not apply to my case. Can some one pls help me to fix this issue.

Thanks in advance
  • 1. Re: FRM-92102
    Fabian Pro
    Currently Being Moderated
    Hi,

    FRM 92102 is a generic ERROR

    Take a backup of files before performing the below changes

    1st

    Give a try by adding the parameter maxBlockTime and session-timeout in web.xml,

    $ORACLE_HOME\j2ee\OC4J_BI_Forms\applications\formsapp\formsweb\WEB-INF\web.xml
    e.g.

    <session-config>
    <session-timeout>20</session-timeout>
    </session-config>

    (The timeout value here is in minutes - example setting 20 minutes)

    2nd

    Oracle HTTP Server - httpd.conf
    ~~~~~~~~~~~~~~~~~~~~~~~

    Timeout 1200

    (This value is in seconds rather than minutes - example setting 1200 (i.e 20 minutes)

    3rd

    Reports Server - rep_[servername].conf
    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    Increase the value for the attribute - idleTimeout

    <connection maxConnect="20" idleTimeOut="120">

    (The value is in minutes - example setting 20 minutes)

    Next

    Restart the Services after the above changes

    Regards
    Fabian
  • 2. Re: FRM-92102
    sank_nk Newbie
    Currently Being Moderated
    Hi, Once i made the changes in the web.xml my oc4j is crashing
  • 3. Re: FRM-92102
    Fabian Pro
    Currently Being Moderated
    Can You post your web.xml file out here
  • 4. Re: FRM-92102
    sank_nk Newbie
    Currently Being Moderated
    <?xml version="1.0"?>
    <!DOCTYPE web-app PUBLIC "-//Sun Microsystems, Inc.//DTD Web Application 2.2//EN" "http://java.sun.com/j2ee/dtds/web-app_2_2.dtd">
    <!-- $Id: web.xml 19-may-2005.09:25:21 supadhya Exp $
    Name
    web.xml
    Purpose
    Forms web application (WAR) configuration file
    -->

    <web-app>
    <display-name>Forms Services</display-name>
    <description>Oracle AS: Forms Services</description>

    <welcome-file-list>
    <welcome-file>lservlet</welcome-file>
    </welcome-file-list>

    <!-- Forms page generator servlet -->
    <servlet>
    <servlet-name>frmservlet</servlet-name>
    <servlet-class>oracle.forms.servlet.FormsServlet</servlet-class>
    <load-on-startup>1</load-on-startup>
    <!-- During product installation the configFileName parameter is
    specified in the orion-web.xml file as a context parameter
    override (in iDS), or as a Java system property (in iAS).
    It is set to <oracle_home>/forms/server/formsweb.cfg.
    You can override that value here by editing and uncommenting the
    following servlet parameter setting: -->
    <!--
    <init-param>
    <param-name>configFileName</param-name>
    <param-value><your configuration file name goes here></param-value>
    </init-param>
    -->
    <init-param>
    <!-- Turn on or off sensitive options on the frmservlet/admin page.
    For security reasons this should be set to false for
    production sites.
    -->
    <param-name>testMode</param-name>
    <param-value>false</param-value>
    </init-param>
    </servlet>

    <!-- Forms listener servlet -->
    <servlet>
    <servlet-name>lservlet</servlet-name>
    <servlet-class>oracle.forms.servlet.ListenerServlet</servlet-class>
              <init-param>
                   <param-name>maxBlockTime</param-name>
                   <param-value>1800000</param-value>
              </init-param>
    </servlet>

    <!-- Forms servlet mappings. Allow these paths to the servlets:
    /forms/frmservlet or /forms/frmservlet/*: FormsServlet
    /forms/lservlet or /forms/lservlet/*: ListenerServlet
    -->
    <servlet-mapping>
    <servlet-name>frmservlet</servlet-name>
    <url-pattern>/frmservlet*</url-pattern>
    </servlet-mapping>
    <servlet-mapping>
    <servlet-name>lservlet</servlet-name>
    <url-pattern>/lservlet*</url-pattern>
    </servlet-mapping>

    <!-- Define application specific security roles
    -->
    <security-role>
    <role-name>administrators</role-name>
    </security-role>

    <!-- Define security constraints to limit access to defined url to a
    particular role -->
    <security-constraint>
    <web-resource-collection>
    <web-resource-name>TraceLog</web-resource-name>
    <url-pattern>/frmservlet/trace</url-pattern>
    </web-resource-collection>
    <auth-constraint>
    <role-name>administrators</role-name>
    </auth-constraint>
    </security-constraint>

    <!-- The following context parameter is only defined here so it can be
    overriden by the (site-specific) value in the orion-web.xml file.
    -->
    <context-param>
    <param-name>configFileName</param-name>
    <param-value></param-value>
    </context-param>
    </web-app>
  • 5. Re: FRM-92102
    Fabian Pro
    Currently Being Moderated
    Update the web.xml as below
    Followed by

    2nd
    Oracle HTTP Server - httpd.conf
    ~~~~~~~~~~~~~~~~~~~~~~~
    Timeout 1200
    (This value is in seconds rather than minutes - example setting 1200 (i.e 20 minutes)

    3rd
    Reports Server - rep_[servername].conf
    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    Increase the value for the attribute - idleTimeout
    <connection maxConnect="20" idleTimeOut="120">
    (The value is in minutes - example setting 20 minutes)

    Next
    Restart the Services after the above changes



    <?xml version="1.0"?>
    <!DOCTYPE web-app PUBLIC "-//Sun Microsystems, Inc.//DTD Web Application 2.2//EN" "http://java.sun.com/j2ee/dtds/web-app_2_2.dtd">
    <!-- $Id: web.xml 19-may-2005.09:25:21 supadhya Exp $
    Name
    web.xml
    Purpose
    Forms web application (WAR) configuration file
    -->

    <web-app>
    <display-name>Forms Services</display-name>
    <description>Oracle AS: Forms Services</description>

    <welcome-file-list>
    <welcome-file>lservlet</welcome-file>
    </welcome-file-list>

    <!-- Forms page generator servlet -->
    <servlet>
    <servlet-name>frmservlet</servlet-name>
    <servlet-class>oracle.forms.servlet.FormsServlet</servlet-class>
    <load-on-startup>1</load-on-startup>
    <!-- During product installation the configFileName parameter is
    specified in the orion-web.xml file as a context parameter
    override (in iDS), or as a Java system property (in iAS).
    It is set to <oracle_home>/forms/server/formsweb.cfg.
    You can override that value here by editing and uncommenting the
    following servlet parameter setting: -->
    <!--
    <init-param>
    <param-name>configFileName</param-name>
    <param-value><your configuration file name goes here></param-value>
    </init-param>
    -->
    <init-param>
    <!-- Turn on or off sensitive options on the frmservlet/admin page.
    For security reasons this should be set to false for
    production sites.
    -->
    <param-name>testMode</param-name>
    <param-value>false</param-value>
    </init-param>
    </servlet>

    <!-- Forms listener servlet -->
    <servlet>
    <servlet-name>lservlet</servlet-name>
    <servlet-class>oracle.forms.servlet.ListenerServlet</servlet-class>
    </servlet>

    <!-- Forms servlet mappings. Allow these paths to the servlets:
    /forms/frmservlet or /forms/frmservlet/*: FormsServlet
    /forms/lservlet or /forms/lservlet/*: ListenerServlet
    -->
    <servlet-mapping>
    <servlet-name>frmservlet</servlet-name>
    <url-pattern>/frmservlet*</url-pattern>
    </servlet-mapping>
    <servlet-mapping>
    <servlet-name>lservlet</servlet-name>
    <url-pattern>/lservlet*</url-pattern>
    </servlet-mapping>

    <!-- Define application specific security roles
    -->
    <security-role>
    <role-name>administrators</role-name>
    </security-role>

    <!-- Define security constraints to limit access to defined url to a
    particular role -->
    <security-constraint>
    <web-resource-collection>
    <web-resource-name>TraceLog</web-resource-name>
    <url-pattern>/frmservlet/trace</url-pattern>
    </web-resource-collection>
    <auth-constraint>
    <role-name>administrators</role-name>
    </auth-constraint>
    </security-constraint>

    <!-- The following context parameter is only defined here so it can be
    overriden by the (site-specific) value in the orion-web.xml file.
    -->
    <context-param>
    <param-name>configFileName</param-name>
    <param-value></param-value>
    </context-param>
    <session-config>
    <session-timeout>20</session-timeout>
    </session-config>
    </web-app>
  • 6. Re: FRM-92102
    sank_nk Newbie
    Currently Being Moderated
    can u pls tell me the path for the files in the 2nd and 3rd step
  • 7. Re: FRM-92102
    Fabian Pro
    Currently Being Moderated
    Take a backup before making any changes

    ORACLE_HOME/Apache/Apache/conf/httpd.conf

    ORACLE_HOME/report/server/rep_[servername].conf
  • 8. Re: FRM-92102
    sank_nk Newbie
    Currently Being Moderated
    Even now my oc4j is crashing :(
  • 9. Re: FRM-92102
    Fabian Pro
    Currently Being Moderated
    Hi,

    Are you Using the same web.xml which i have posted as below.


    <?xml version="1.0"?>
    <!DOCTYPE web-app PUBLIC "-//Sun Microsystems, Inc.//DTD Web Application 2.2//EN" "http://java.sun.com/j2ee/dtds/web-app_2_2.dtd">
    <!-- $Id: web.xml 19-may-2005.09:25:21 supadhya Exp $
    Name
    web.xml
    Purpose
    Forms web application (WAR) configuration file
    -->

    <web-app>
    <display-name>Forms Services</display-name>
    <description>Oracle AS: Forms Services</description>

    <welcome-file-list>
    <welcome-file>lservlet</welcome-file>
    </welcome-file-list>

    <!-- Forms page generator servlet -->
    <servlet>
    <servlet-name>frmservlet</servlet-name>
    <servlet-class>oracle.forms.servlet.FormsServlet</servlet-class>
    <load-on-startup>1</load-on-startup>
    <!-- During product installation the configFileName parameter is
    specified in the orion-web.xml file as a context parameter
    override (in iDS), or as a Java system property (in iAS).
    It is set to <oracle_home>/forms/server/formsweb.cfg.
    You can override that value here by editing and uncommenting the
    following servlet parameter setting: -->
    <!--
    <init-param>
    <param-name>configFileName</param-name>
    <param-value><your configuration file name goes here></param-value>
    </init-param>
    -->
    <init-param>
    <!-- Turn on or off sensitive options on the frmservlet/admin page.
    For security reasons this should be set to false for
    production sites.
    -->
    <param-name>testMode</param-name>
    <param-value>false</param-value>
    </init-param>
    </servlet>

    <!-- Forms listener servlet -->
    <servlet>
    <servlet-name>lservlet</servlet-name>
    <servlet-class>oracle.forms.servlet.ListenerServlet</servlet-class>
    </servlet>

    <!-- Forms servlet mappings. Allow these paths to the servlets:
    /forms/frmservlet or /forms/frmservlet/*: FormsServlet
    /forms/lservlet or /forms/lservlet/*: ListenerServlet
    -->
    <servlet-mapping>
    <servlet-name>frmservlet</servlet-name>
    <url-pattern>/frmservlet*</url-pattern>
    </servlet-mapping>
    <servlet-mapping>
    <servlet-name>lservlet</servlet-name>
    <url-pattern>/lservlet*</url-pattern>
    </servlet-mapping>

    <!-- Define application specific security roles
    -->
    <security-role>
    <role-name>administrators</role-name>
    </security-role>

    <!-- Define security constraints to limit access to defined url to a
    particular role -->
    <security-constraint>
    <web-resource-collection>
    <web-resource-name>TraceLog</web-resource-name>
    <url-pattern>/frmservlet/trace</url-pattern>
    </web-resource-collection>
    <auth-constraint>
    <role-name>administrators</role-name>
    </auth-constraint>
    </security-constraint>

    <!-- The following context parameter is only defined here so it can be
    overriden by the (site-specific) value in the orion-web.xml file.
    -->
    <context-param>
    <param-name>configFileName</param-name>
    <param-value></param-value>
    </context-param>
    <session-config>
    <session-timeout>20</session-timeout>
    </session-config>
    </web-app>

    Can you paste the OC4J logs.

    Regards
    Fabian
  • 10. Re: FRM-92102
    sank_nk Newbie
    Currently Being Moderated
    Yes i copied from the page and pasted it

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points