R12 E-Business Suite Applications Technology Stack JDK, JVM, JRE Login Crashes Due To Connection Leak With Error 'oracle.apps.fnd.security.LeakedConnectionException' Reported In AoljDbcPoolStatus.jsp
(Doc ID 1462034.1)
Last updated on JUNE 21, 2023
Applies to:
Oracle E-Business Suite Technology Stack - Version 12.1.2 to 12.1.3 [Release 12.1]Information in this document applies to any platform.
Symptoms
E-Business Suite R12 Applications Technology Stack, Jserv, JDK, JVM, and JRE related issues
Login to Oracle Applications 12.1.3 fails due to a connection leak on AuthenticateUser if for some reason the session creation crashes (For example calling the servlet with null username and password).
When the administrator runs the AOL/J Diagnostic Tests via AoljDbcPoolStatus.jsp, the drilldown to 'leaked connections' page shows the following:
AOL/J Diagnostic Tests
AOL/J Database Connection Pool Status
oracle.apps.fnd.security.LeakedConnectionException 1, 0x7abf66, 2012-02-14+16:05:24.043+0000, Thread[AJPRequestHandler-HTTPThreadGroup-6,5,HTTPThreadGroup]
at oracle.apps.fnd.security.CallStack.getInstance(CallStack.java:109)
at oracle.apps.fnd.security.DBConnObj.setBorrowingThread(DBConnObj.java:990)
at oracle.apps.fnd.security.DBConnObj.setBorrowingThread(DBConnObj.java:973)
at oracle.apps.fnd.common.Pool.costBasedSelection(Pool.java:1885)
at oracle.apps.fnd.common.Pool.selectObject(Pool.java:1686)
at oracle.apps.fnd.common.Pool.borrowObject(Pool.java:950)
at oracle.apps.fnd.security.DBConnObjPool.borrowObject(DBConnObjPool.java:584)
at oracle.apps.fnd.security.AppsConnectionManager.borrowConnection(AppsConnectionManager.java:301)
at oracle.apps.fnd.common.Context.borrowConnection(Context.java:1719)
at oracle.apps.fnd.common.AppsContext.getPrivateConnectionFinal(AppsContext.java:2266)
at oracle.apps.fnd.common.AppsContext.getPrivateConnection(AppsContext.java:2203)
at oracle.apps.fnd.common.AppsContext.getJDBCConnection(AppsContext.java:2061)
at oracle.apps.fnd.common.AppsContext.getJDBCConnection(AppsContext.java:1871)
at oracle.apps.fnd.common.AppsContext.getJDBCConnection(AppsContext.java:1715)
at oracle.apps.fnd.common.AppsContext.getJDBCConnection(AppsContext.java:1728)
at oracle.apps.fnd.common.Context.getJDBCConnection(Context.java:1453)
at oracle.apps.fnd.sso.Utils.getConnection(Utils.java:650)
at _AppsLocalLogin._jspService(_AppsLocalLogin.java:234)
at com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:59)
at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:473)
at oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:594)
at oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:518)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
at com.evermind.server.http.ResourceFilterChain.doFilter(ResourceFilterChain.java:64)
at oracle.apps.jtf.base.session.ReleaseResFilter.doFilter(ReleaseResFilter.java:26)
at com.evermind.server.http.EvermindFilterChain.doFilter(EvermindFilterChain.java:15)
at oracle.apps.fnd.security.AppsServletFilter.doFilter(AppsServletFilter.java:318)
at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:642)
at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:391)
at com.evermind.server.http.HttpRequestHandler.doProcessRequest(HttpRequestHandler.java:908)
at com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:458)
at com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:313)
at com.evermind.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.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:303)
at java.lang.Thread.run(Thread.java:619)
at oracle.apps.fnd.security.CallStack.getInstance(CallStack.java:109)
at oracle.apps.fnd.security.DBConnObj.setBorrowingThread(DBConnObj.java:990)
at oracle.apps.fnd.security.DBConnObj.setBorrowingThread(DBConnObj.java:973)
at oracle.apps.fnd.common.Pool.costBasedSelection(Pool.java:1885)
at oracle.apps.fnd.common.Pool.selectObject(Pool.java:1686)
at oracle.apps.fnd.common.Pool.borrowObject(Pool.java:950)
at oracle.apps.fnd.security.DBConnObjPool.borrowObject(DBConnObjPool.java:584)
at oracle.apps.fnd.security.AppsConnectionManager.borrowConnection(AppsConnectionManager.java:301)
at oracle.apps.fnd.common.Context.borrowConnection(Context.java:1719)
at oracle.apps.fnd.common.AppsContext.getPrivateConnectionFinal(AppsContext.java:2266)
at oracle.apps.fnd.common.AppsContext.getPrivateConnection(AppsContext.java:2203)
at oracle.apps.fnd.common.AppsContext.getJDBCConnection(AppsContext.java:2061)
at oracle.apps.fnd.common.AppsContext.getJDBCConnection(AppsContext.java:1871)
at oracle.apps.fnd.common.AppsContext.getJDBCConnection(AppsContext.java:1715)
at oracle.apps.fnd.common.AppsContext.getJDBCConnection(AppsContext.java:1728)
at oracle.apps.fnd.common.Context.getJDBCConnection(Context.java:1453)
at oracle.apps.fnd.sso.Utils.getConnection(Utils.java:650)
at _AppsLocalLogin._jspService(_AppsLocalLogin.java:234)
at com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:59)
at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:473)
at oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:594)
at oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:518)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
at com.evermind.server.http.ResourceFilterChain.doFilter(ResourceFilterChain.java:64)
at oracle.apps.jtf.base.session.ReleaseResFilter.doFilter(ReleaseResFilter.java:26)
at com.evermind.server.http.EvermindFilterChain.doFilter(EvermindFilterChain.java:15)
at oracle.apps.fnd.security.AppsServletFilter.doFilter(AppsServletFilter.java:318)
at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:642)
at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:391)
at com.evermind.server.http.HttpRequestHandler.doProcessRequest(HttpRequestHandler.java:908)
at com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:458)
at com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:313)
at com.evermind.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.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:303)
at java.lang.Thread.run(Thread.java:619)
Changes
Recent upgrade to 12.1.2 or 12.1.3
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 |