Connection Leaks From fndgfm (fndgfm.java, fndgfm.jsp, _fndgfm.java) (Doc ID 1231393.1)

Last updated on OCTOBER 05, 2016

Applies to:

Oracle Application Object Library - Version 12.1.2 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.

Symptoms

While troubleshooting OACore JVM performance via "System Administration / AOL J Database Connection Pool Status" it can be determined that fndgfm.jsp is leaking connections:

Example stack trace:

oracle.apps.fnd.security.LeakedConnectionException 3, 0x6cfb93, 2010-09-09+07:01:13.641-0700, Thread[AJPRequestHandler-HTTPThreadGroup-78,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.cache.GenericCacheLoader.load(GenericCacheLoader.java:170)
at oracle.apps.fnd.profiles.Profiles.getProfileOption(Profiles.java:1500)
at oracle.apps.fnd.profiles.Profiles.getProfile(Profiles.java:362)
at oracle.apps.fnd.profiles.ExtendedProfileStore.getSpecificProfileFromDB(ExtendedProfileStore.java:211)
at oracle.apps.fnd.profiles.ExtendedProfileStore.getSpecificProfile(ExtendedProfileStore.java:171)
at oracle.apps.fnd.profiles.ExtendedProfileStore.getProfile(ExtendedProfileStore.java:148)
at oracle.apps.fnd.common.logging.DebugEventManager.configureUsingDatabaseValues(DebugEventManager.java:1294)
at oracle.apps.fnd.common.logging.DebugEventManager.configureLogging(DebugEventManager.java:1149)
at oracle.apps.fnd.common.logging.DebugEventManager.internalReinit(DebugEventManager.java:1118)
at oracle.apps.fnd.common.logging.DebugEventManager.reInitialize(DebugEventManager.java:1085)
at oracle.apps.fnd.common.logging.DebugEventManager.reInitialize(DebugEventManager.java:1072)
at oracle.apps.fnd.common.AppsLog.reInitialize(AppsLog.java:595)
at oracle.apps.fnd.common.AppsContext.initLog(AppsContext.java:593)
at oracle.apps.fnd.common.AppsContext.initializeContext(AppsContext.java:570)
at oracle.apps.fnd.common.AppsContext.initializeContext(AppsContext.java:524)
at oracle.apps.fnd.common.WebAppsContext.(WebAppsContext.java:1140)
at oracle.apps.fnd.common.WebRequestUtil.validateContext(WebRequestUtil.java:225)
at _fndgfm.getWebAppsContext(_fndgfm.java:75)
at _fndgfm._jspService(_fndgfm.java:538)
at com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:59)
at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:379)
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:621)
at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:370)
at com.evermind.server.http.HttpRequestHandler.doProcessRequest(HttpRequestHandler.java:871)
at com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:453)
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 com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:303)
at java.lang.Thread.run(Thread.java:619)



Version used on the customer site:

> strings -a $FND_TOP/html/fndgfm.jsp | grep '$Header'
$Header fndgfm.jsp 120.17.12010000.6 2009/08/13 05:31:52 nchiring ship $

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