R12 Forms Slow performance / Freezes / Hangs for large # Record details using View -> Last -> Record
(Doc ID 1369830.1)
Last updated on JANUARY 02, 2025
Applies to:
Oracle E-Business Suite Technology Stack - Version 12.1.3 to 12.2 [Release 12.1 to 12.2]Information in this document applies to any platform.
Symptoms
E-Business Suite R12 Applications Technology Stack, Forms for Applications Technology related issues
Intermittently forms connections to E-Business Suite applications hang for the user community.
Only forms users are reporting the issue, and it can include any of the following forms:
OEXOEORD , ARXCWMAI , GLXJIRUN , INVIDITM , INVTOTRX , BOMFQBIN , WIPDJMDF , IEUSEUWQ , POXPOEPO
User may receive error 'FRM-30457' initially, and the following errors are reported in the application server log files at that time.
FILENAME = error_log.1310601600 and error_log.1310688000
>>>> Last entry in error_log.1310601600 is
[Fri Jul 15 07:25:47 2011] [error] [client ] [ecid: 131::3905:0:9643,0] File does not exist: TEST/apps/apps_st/comn/java/classes/oracle/forms/engine/RunformBundle_zh.properties
>>>> FIRST entry in the next error_log error_log.1310688000 starts AFTER the issue was reported.
[Fri Jul 15 12:55:11 2011] [warn] Found ohs process id 0 in scoreboard, skip this entry
>>>> HOWEVER the access_log does show entries for 2011/07/15 10:27:00
FILENAME = access_log.1310688000
- - [15/Jul/2011:10:27:00 +0800] "POST /forms/lservlet;jsessionid=203701007fb42c558645fa6c988316fe95251308a6249e490340b8d7a2ec3f6e.e34Ob3iSah8Pbi0Lbx0PbN0PbhyQe0 HTTP/1.1" 200 379 1 "-" "Mozilla/4.0 (Windows XP 5.1) Java/1.6.0_07"
- - [15/Jul/2011:10:27:00 +0800] "POST /forms/lservlet;jsessionid=31eb8b77604a9439e61309dfd6ff5bd86e4cc3b3b15e70ad170fca326b56b147.e34Ob3iSah8Pbi0Lbx0PbN0PbhyQe0 HTTP/1.1" 200 3112 1 "-" "Mozilla/4.0 (Windows XP 5.1) Java/1.6.0_07"
- - [15/Jul/2011:10:27:00 +0800] "POST /forms/lservlet;jsessionid=31eb8b77604a9439e61309dfd6ff5bd86e4cc3b3b15e70ad170fca326b56b147.e34Ob3iSah8Pbi0Lbx0PbN0PbhyQe0 HTTP/1.1" 200 2 0 "-" "Mozilla/4.0 (Windows XP 5.1) Java/1.6.0_07"
- - [15/Jul/2011:10:27:00 +0800] "POST /forms/lservlet;jsessionid=8ae64e5a19363b34a2b030c6d191dabb5bd174791d17a47a5f433a84249faddc.e34Ob3iSah8Pbi0Lbx0PbN0PbhyLe0 HTTP/1.1" 200 2 0 "-" "Mozilla/4.0 (Windows XP 5.1) Java/1.6.0_07"
- - [15/Jul/2011:10:27:00 +0800] "POST /forms/lservlet;jsessionid=20b1881bbc31bdaba56119620d95e81c9bdfc78c5a7abc3598e94dab700a9bfd.e34Ob3iSah8Pbi0Lbx0PbN0PbhyLe0 HTTP/1.1" 200 2 0 "-" "Mozilla/4.0 (Windows XP 5.1) Java/1.6.0_07"
- - [15/Jul/2011:10:27:00 +0800] "POST /forms/lservlet;jsessionid=eaaf95cdbcae15d7ab6fdc9ba8ac79b1106159632ad5b95ad5590d53fd2e3279.e34Ob3iSah8Pbi0Lbx0PbN0PbhyNe0 HTTP/1.1" 200 2 0 "-" "Mozilla/4.0 (Windows XP 5.1) Java/1.6.0_07"
- - [15/Jul/2011:10:27:00 +0800] "POST /forms/lservlet;jsessionid=c526eb5547aa4e550d46c544244b324687f13fa4e0e4cf01632707415effff8c.e34Ob3iSah8Pbi0Lbx0PbN0PbhyQe0 HTTP/1.1" 200 2 0 "-" "Mozilla/4.0 (Windows XP 5.1) Java/1.6.0_07"
- - [15/Jul/2011:10:27:
>>>>> These forms requests are successful so need to look at the JVM logs.
FILENAME = forms_default_group_4 >> application.log
>>>> The time of the last reported issue ties into the following error message.
11/07/15 10:28:42.397 formsweb: Servlet error
java.io.IOException: Broken pipe (errno:32)
at sun.nio.ch.FileDispatcher.write0(Native Method)
at sun.nio.ch.SocketDispatcher.write(SocketDispatcher.java:29)
at sun.nio.ch.IOUtil.writeFromNativeBuffer(IOUtil.java:104)
at sun.nio.ch.IOUtil.write(IOUtil.java:75)
at sun.nio.ch.SocketChannelImpl.write(SocketChannelImpl.java:334)
at java.nio.channels.Channels.write(Channels.java:60)
at java.nio.channels.Channels.access$000(Channels.java:47)
at java.nio.channels.Channels$1.write(Channels.java:134)
at com.evermind.server.http.AJPOutputStream.endRequest(AJPOutputStream.java:117)
at com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:317)
at com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:199)
at oracle.oc4j.network.ServerSocketReadHandler$SafeRunnable.run(ServerSocketReadHandler.java:260)
at com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:303)
at java.lang.Thread.run(Thread.java:619)
11/07/15 10:28:55.741 formsweb: Forms session <100> aborted: unable to communicate with runtime process.
11/07/15 10:28:55.741 formsweb: Forms session <100> exception stack trace:
java.net.SocketException: Connection reset
at java.net.SocketInputStream.read(SocketInputStream.java:173)
at java.io.BufferedInputStream.fill(BufferedInputStream.java:218)
at java.io.BufferedInputStream.read(BufferedInputStream.java:237)
at java.io.DataInputStream.readLine(DataInputStream.java:496)
at oracle.forms.net.HTTPHeaderTool.parseResponseHeader(Unknown Source)
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 oracle.oc4j.network.ServerSocketAcceptHandler.procClientSocket(ServerSocketAcceptHandler.java:234)
at oracle.oc4j.network.ServerSocketAcceptHandler.access$700(ServerSocketAcceptHandler.java:29)
at oracle.oc4j.network.ServerSocketAcceptHandler$AcceptHandlerHorse.run(ServerSocketAcceptHandler.java:879)
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)
>>>> At the same time we get these errors we see the following being reported by opmn
FILENAME = opmn.log
11/07/15 10:27:50 [libopmnohs] Process Ping Failed: HTTP_Server~HTTP_Server~HTTP_Server~1 (1605705582:6007) [The connection receive timed out]
11/07/15 10:28:40 [libopmnohs] Process Ping Failed: HTTP_Server~HTTP_Server~HTTP_Server~1 (1605705582:6007) [The connection receive timed out]
11/07/15 10:28:40 [libopmnohs] Process Unreachable: HTTP_Server~HTTP_Server~HTTP_Server~1 (1605705582:6007)
11/07/15 10:28:41 [pm-process] Stopping Process: HTTP_Server~HTTP_Server~HTTP_Server~1 (1605705582:6007)
11/07/15 10:28:43 [pm-process] Starting Process: HTTP_Server~HTTP_Server~HTTP_Server~1 (1605705582:0)
11/07/15 10:28:45 [pm-process] Process Alive: HTTP_Server~HTTP_Server~HTTP_Server~1 (1605705582:2497)
FILENAME = forms_default_group_4 > formsstd.out
11/07/15 10:28:55 Forms session <100> aborted: unable to communicate with runtime process.
11/07/15 10:52:42 Forms session <107> aborted: unable to communicate with runtime process.
NOTE:- OACORE does not seem to report and errors during the same period the error_log is written to
The issue can be reproduced at will with the following steps:
1. Login and access a navigation path which uses Forms View -> Last -> Record functionality
2. Attempt to access a large # Record details using View -> Last -> Record which then hangs
3. Some or All users logged into forms will then begin to be effected
4. Next it not possible for users to connect to log in a new session.
Issue can be seen in any form with View -> Last -> Record functionality (For example the Material Transactions Form (INVTVTXN)).
Changes
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |