8 Replies Latest reply: Jan 24, 2013 4:03 AM by 951005 RSS

    Reg:Forms Session in R12.1.3

    user259654
      Hello All,

      Recently we have implemented a fresh R12.1.3 instance.Some strange issue all the form sessions are getting disconnected that too only between 5pm -5:30pm.

      734077.1 followed this note as well but no luck.

      Checked all the profiles as well but nothing is setup.There are no scheduled jobs as well during at duration.

      We have logged an SR since 1 weak but dint get any solution till now.

      This issue is happening only in Production and not in any cloned instances.

      Any help is highly appreciated.

      Regards,
      MR
        • 1. Re: Reg:Forms Session in R12.1.3
          Hussein Sawwan-Oracle
          What is your OS? DB version?

          Your issue sounds like there is another job (OS, Storage, or Network level) running at that time and causing the forms to timeout, so have you verified if any jobs are scheduled to run then?

          What do you do to get the connection back? Do you start the application services again? If yes, do you get any errors when bringing the services up at that time?

          Can you find any coredump/log files generated at the time when the sessions time out?

          Do you have the latest patchset for forms/reports applied? -- Upgrading OracleAS 10g Forms and Reports in Oracle E-Business Suite Release 12 [ID 437878.1]

          Thanks,
          Hussein
          • 2. Re: Reg:Forms Session in R12.1.3
            951005
            Hi Hussein,

            Even we are facing a similar kind of issue. But there is no any time frame though.

            The error message pops up while the form is still active, "Your log on session has become invalid. Kindly re-login again...."

            The ICX:Session timeout parameter is set to 120 minutes.

            There are no error messages for this and when the user relogin again then everything becomes normal.

            The forms and report version we have is 10.1.2.3.0

            This cannot be a network issue as this does not happen at the same time to all users.

            Thanks,
            KS
            • 3. Re: Reg:Forms Session in R12.1.3
              Hussein Sawwan-Oracle
              948002 wrote:
              Hi Hussein,

              Even we are facing a similar kind of issue. But there is no any time frame though.

              The error message pops up while the form is still active, "Your log on session has become invalid. Kindly re-login again...."

              The ICX:Session timeout parameter is set to 120 minutes.

              There are no error messages for this and when the user relogin again then everything becomes normal.

              The forms and report version we have is 10.1.2.3.0

              This cannot be a network issue as this does not happen at the same time to all users.

              Thanks,
              KS
              Can you find any errors in the database log file and in the application.log?

              Do you have the patches in these docs applied?

              Connection Leak On Login [ID 1462034.1]
              Connection Leak: Find LeakedConnectionException Reported in AOLJ Database Connection Pool Test [ID 1177093.1]
              Connection Leaks From fndgfm (fndgfm.java, fndgfm.jsp, _fndgfm.java) [ID 1231393.1]

              Thanks,
              Hussein
              • 4. Re: Reg:Forms Session in R12.1.3
                Carlo den Otter
                Hello MR,

                You might try a continuous 'ping' from some clients to the application server to check for network issues at the time of the forms disconnects.

                Regards, Carlo.
                • 5. Re: Reg:Forms Session in R12.1.3
                  951005
                  Hi Hussein,


                  Thanks for your reply.


                  I noticed the following error in application.log but there is no error in database log file.


                  13/01/16 16:12:48.774 formsweb: Forms session <319> aborted: unable to communicate with runtime process.
                  13/01/16 16:12:48.774 formsweb: Forms session <319> exception stack trace:
                  java.io.IOException: FRM-93000: Unexpected internal error.
                  Details : No HTTP headers received from runform
                  at oracle.forms.servlet.ListenerServlet.forwardResponseFromRunform(Unknown Source)
                  at oracle.forms.servlet.ListenerServlet.doPost(Unknown Source)
                  at javax.servlet.http.HttpServlet.service(HttpServlet.java:763)
                  at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
                  at com.evermind[Oracle Containers for J2EE 10g (10.1.3.4.0) ].server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:713)
                  at com.evermind[Oracle Containers for J2EE 10g (10.1.3.4.0) ].server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:370)
                  at com.evermind[Oracle Containers for J2EE 10g (10.1.3.4.0) ].server.http.HttpRequestHandler.doProcessRequest(HttpRequestHandler.java:871)
                  at com.evermind[Oracle Containers for J2EE 10g (10.1.3.4.0) ].server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:453)
                  at com.evermind[Oracle Containers for J2EE 10g (10.1.3.4.0) ].server.http.AJPRequestHandler.run(AJPRequestHandler.java:313)
                  at com.evermind[Oracle Containers for J2EE 10g (10.1.3.4.0) ].server.http.AJPRequestHandler.run(AJPRequestHandler.java:199)
                  at oracle.oc4j.network.ServerSocketReadHandler$SafeRunnable.run(ServerSocketReadHandler.java:260)
                  at com.evermind[Oracle Containers for J2EE 10g (10.1.3.4.0) ].util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:303)
                  at java.lang.Thread.run(Thread.java:619)


                  But when i checked for FRM-93000 error , the solution was related to windows platform and not for unix.

                  We followed the note-id (1306678.1) which describes a similar issue. Compiled forms and flexfields as well. But no luck



                  Regards,
                  Sri
                  • 6. Re: Reg:Forms Session in R12.1.3
                    Hussein Sawwan-Oracle
                    13/01/16 16:12:48.774 formsweb: Forms session <319> aborted: unable to communicate with runtime process.
                    13/01/16 16:12:48.774 formsweb: Forms session <319> exception stack trace:
                    java.io.IOException: FRM-93000: Unexpected internal error.
                    Details : No HTTP headers received from runform
                    at oracle.forms.servlet.ListenerServlet.forwardResponseFromRunform(Unknown Source)
                    at oracle.forms.servlet.ListenerServlet.doPost(Unknown Source)
                    at javax.servlet.http.HttpServlet.service(HttpServlet.java:763)
                    at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
                    at com.evermind[Oracle Containers for J2EE 10g (10.1.3.4.0) ].server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:713)
                    at com.evermind[Oracle Containers for J2EE 10g (10.1.3.4.0) ].server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:370)
                    at com.evermind[Oracle Containers for J2EE 10g (10.1.3.4.0) ].server.http.HttpRequestHandler.doProcessRequest(HttpRequestHandler.java:871)
                    at com.evermind[Oracle Containers for J2EE 10g (10.1.3.4.0) ].server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:453)
                    at com.evermind[Oracle Containers for J2EE 10g (10.1.3.4.0) ].server.http.AJPRequestHandler.run(AJPRequestHandler.java:313)
                    at com.evermind[Oracle Containers for J2EE 10g (10.1.3.4.0) ].server.http.AJPRequestHandler.run(AJPRequestHandler.java:199)
                    at oracle.oc4j.network.ServerSocketReadHandler$SafeRunnable.run(ServerSocketReadHandler.java:260)
                    at com.evermind[Oracle Containers for J2EE 10g (10.1.3.4.0) ].util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:303)
                    at java.lang.Thread.run(Thread.java:619)


                    But when i checked for FRM-93000 error , the solution was related to windows platform and not for unix.

                    We followed the note-id (1306678.1) which describes a similar issue. Compiled forms and flexfields as well. But no luck
                    What about these docs?

                    R12: "FRM-92101: There was failure in the Forms Server during startup" Error While Submitting Concurrent Requests [ID 867501.1]
                    R12: "FRM-92101: There Was a Failure in the Forms Server During Startup" Error When Executing EXECUTE_QUERY in Forms [ID 1111113.1]

                    Thanks,
                    Hussein
                    • 7. Re: Reg:Forms Session in R12.1.3
                      951005
                      Hi Hussein,

                      This issue is not related with any of the two documents. Because there is no any specific navigation to reproduce this error.
                      The "session log out" message appears at any point of time and also there is no any time interval.

                      the frm_dmp shows the following message


                      [Wed Jan 23 15:27:25 2013 SGT]::Client Status [ConnId=0, PID=6591]
                      >> Network connection to client failed: timeout on connection
                      Possible causes include a network failure or client termination


                      We also performed the network test and everything seems to be fine.

                      We are not able to find any information in the form trace.

                      Regards,
                      Srinath
                      • 8. Re: Reg:Forms Session in R12.1.3
                        951005
                        Hi Hussein,

                        Will this note id work for us?

                        Intermittent FRM-92101,FRM-93000 At Runtime Causing Forms Session To Crash [ID 434895.1]

                        Regards,
                        Srinath