10 Replies Latest reply: Oct 19, 2012 2:47 AM by sank_nk RSS

    FRM-92102

    sank_nk
      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
          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
            Hi, Once i made the changes in the web.xml my oc4j is crashing
            • 3. Re: FRM-92102
              Fabian
              Can You post your web.xml file out here
              • 4. Re: FRM-92102
                sank_nk
                <?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
                  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
                    can u pls tell me the path for the files in the 2nd and 3rd step
                    • 7. Re: FRM-92102
                      Fabian
                      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
                        Even now my oc4j is crashing :(
                        • 9. Re: FRM-92102
                          Fabian
                          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
                            Yes i copied from the page and pasted it