R12 Forms Slow performance / Freezes / Hangs for large # Record details using View -> Last -> Record (Doc ID 1369830.1)

Last updated on NOVEMBER 23, 2016

Applies to:

Oracle Applications Technology Stack - Version 12.0.6 to 12.1.3 [Release 12.0 to 12.1]
Information in this document applies to any platform.
OEXOEORD , ARXCWMAI , GLXJIRUN , INVIDITM , INVTOTRX , BOMFQBIN , WIPDJMDF , IEUSEUWQ , POXPOEPO
Checked for relevance on 27-JUL-2013


Symptoms

Intermittently any or all connections to the E-Business suite hang. However at the time only forms users are reporting the issue.

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 dated "Fri Jul 15 07:25:47 2011"

[Fri Jul 15 07:25:47 2011] [error] [client ] [ecid: 1310685947::3905:0:9643,0] File does not exist: /r12_ap/PROD/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=33effcce100f13e0c1426ac8939af1ec2b4aad51ce6756c3b2665ea11e5fa36d.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=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.387 formsweb: Broken pipe (errno:32)
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:00 [libopmnohs] Process Ping Failed: HTTP_Server~HTTP_Server~HTTP_Server~1 (1605705582:6007) [The connection receive timed out]
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 including Material Transactions Form (INVTVTXN).

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms