Diagnostic Tests Error "Connection Has Already Been Closed" (Doc ID 2508306.1)

Last updated on JUNE 02, 2023

Applies to:

Symptoms

On : 12.2.6 version, Applications DBA

Diagnostic tests error "Connection has already been closed"
We are not able to run aplist or any other diagnostic tests


ERROR
-----------------------
Connection has already been closed.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Application diagnostic responsibility >
2. Diagnose >
3. Error is received.

Changes

Filename = trace_OAM_TCYP2I.txt
See the following error:

java.sql.SQLException: Connection has already been closed. at weblogic.jdbc.wrapper.PoolConnection.checkConnection(PoolConnection.java:69) at weblogic.jdbc.wrapper.Connection.preInvocationHandler(Connection.java:100) at weblogic.jdbc.wrapper.Connection.prepareStatement(Connection.java:553) at oracle.apps.fnd.oam.diagnostics.dao.GroupDAO.getAllGroups(GroupDAO.java:236) at oracle.apps.fnd.oam.diagnostics.bo.Application.getAllGroups(Application.java:155) at oracle.apps.fnd.oam.diagnostics.handlers.SelectTestHandler.getHGridData(SelectTestHandler.java:588) at oracle.apps.fnd.oam.diagnostics.handlers.SelectTestHandler.constructHGridData(SelectTestHandler.java:471) at oracle.apps.fnd.oam.diagnostics.handlers.SelectTestHandler.getData(SelectTestHandler.java:174) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:606) at oracle.cabo.ui.data.provider.MethodDataProvider.getDataObject(Unknown Source) at oracle.cabo.ui.data.provider.TableDataProvider.getDataObject(Unknown Source) at oracle.cabo.ui.data.provider.CachingDataProvider.getDataObject(Unknown Source) at oracle.cabo.ui.data.provider.DataProviderStack.getDataObject(Unknown Source) at oracle.cabo.ui.LogicalNodeRenderingContext.getDataObject(Unknown Source) at oracle.cabo.ui.RootRenderingContext.getDataObject(Unknown Source) at oracle.cabo.ui.LogicalNodeRenderingContext.getDataObject(Unknown Source) at oracle.cabo.ui.RootRenderingContext.getDataObject(Unknown Source) at oracle.cabo.ui.data.DataBoundValue.getValue(Unknown Source) at oracle.cabo.ui.BaseUINode.getAttributeValueImpl(Unknown Source) at oracle.cabo.ui.BaseUINode.getAttributeValue(Unknown Source) at oracle.cabo.ui.laf.base.BaseLafUtils.getLocalTextAttribute(Unknown Source) at oracle.cabo.ui.laf.base.xhtml.LinkRenderer.getDestinationAttr(Unknown Source) at oracle.cabo.ui.laf.base.xhtml.LinkRenderer.getDestination(Unknown Source) at oracle.cabo.ui.laf.base.xhtml.LinkRenderer._buildDataObject(Unknown Source) at oracle.cabo.ui.laf.base.xhtml.LinkRenderer.render(Unknown Source) at oracle.cabo.ui.BaseUINode.render(Unknown Source) at oracle.cabo.ui.BaseUINode.render(Unknown Source) at oracle.cabo.ui.laf.base.xhtml.LinkDataObject.getLinkDataList(Unknown Source) at oracle.cabo.ui.laf.swan.desktop.TabBarRenderer.prerender(Unknown Source) at oracle.cabo.ui.BaseRenderer.render(Unknown Source) at oracle.cabo.ui.laf.base.xhtml.XhtmlLafRenderer.render(Unknown Source) at oracle.cabo.ui.laf.skyros.desktop.TabBarRenderer.render(Unknown Source) at oracle.cabo.ui.BaseUINode.render(Unknown Source) at oracle.cabo.ui.BaseUINode.render(Unknown Source) at oracle.cabo.ui.composite.ContextPoppingUINode$ContextPoppingRenderer.render(Unknown Source) at oracle.cabo.ui.BaseUINode.render(Unknown Source) at oracle.cabo.ui.BaseUINode.render(Unknown Source) at oracle.cabo.ui.BaseRenderer.renderChild(Unknown Source) at oracle.cabo.ui.BaseRenderer.renderNamedChild(Unknown Source) at oracle.cabo.ui.laf.alta.desktop.PageHeaderLayoutRenderer._renderTabBar(Unknown Source) at oracle.cabo.ui.laf.alta.desktop.PageHeaderLayoutRenderer.renderUniversalGlobalHeaderContent(Unknown Source) at oracle.cabo.ui.laf.alta.desktop.PageHeaderLayoutRenderer.renderContent(Unknown Source) at oracle.cabo.ui.BaseRenderer.render(Unknown Source) at oracle.cabo.ui.laf.base.xhtml.XhtmlLafRenderer.render(Unknown Source) at oracle.cabo.ui.BaseUINode.render(Unknown Source) at oracle.cabo.ui.BaseUINode.render(Unknown Source) at oracle.cabo.ui.BaseRenderer.renderChild(Unknown Source) at oracle.cabo.ui.BaseRenderer.renderIndexedChild(Unknown Source) at oracle.cabo.ui.BaseRenderer.renderIndexedChild(Unknown Source) at oracle.cabo.ui.BaseRenderer.renderContent(Unknown Source) at oracle.cabo.ui.BaseRenderer.render(Unknown Source) at oracle.cabo.ui.laf.base.xhtml.XhtmlLafRenderer.render(Unknown Source) at oracle.cabo.ui.BaseUINode.render(Unknown Source) at oracle.cabo.ui.BaseUINode.render(Unknown Source) at oracle.cabo.ui.composite.UINodeRenderer.renderWithNode(Unknown Source) at oracle.cabo.ui.composite.UINodeRenderer.render(Unknown Source) at oracle.cabo.ui.laf.oracle.desktop.PageLayoutRenderer.render(Unknown Source) at oracle.cabo.ui.BaseUINode.render(Unknown Source) at oracle.cabo.ui.BaseUINode.render(Unknown Source) at oracle.cabo.ui.BaseRenderer.renderChild(Unknown Source) at oracle.cabo.ui.BaseRenderer.renderIndexedChild(Unknown Source) at oracle.cabo.ui.BaseRenderer.renderIndexedChild(Unknown Source) at oracle.cabo.ui.BaseRenderer.renderContent(Unknown Source) at oracle.cabo.ui.laf.base.xhtml.BodyRenderer.renderContent(Unknown Source) at oracle.cabo.ui.BaseRenderer.render(Unknown Source) at oracle.cabo.ui.BaseUINode.render(Unknown Source) at oracle.cabo.ui.BaseUINode.render(Unknown Source) at oracle.cabo.ui.BaseRenderer.renderChild(Unknown Source) at oracle.cabo.ui.BaseRenderer.renderIndexedChild(Unknown Source) at oracle.cabo.ui.BaseRenderer.renderIndexedChild(Unknown Source) at oracle.cabo.ui.BaseRenderer.renderContent(Unknown Source) at oracle.cabo.ui.laf.base.xhtml.DocumentRenderer.renderContent(Unknown Source) at oracle.cabo.ui.BaseRenderer.render(Unknown Source) at oracle.cabo.ui.laf.base.xhtml.DocumentRenderer.render(Unknown Source) at oracle.cabo.ui.BaseUINode.render(Unknown Source) at oracle.cabo.ui.BaseUINode.render(Unknown Source) at oracle.cabo.ui.BaseRenderer.renderChild(Unknown Source) at oracle.cabo.ui.BaseRenderer.renderIndexedChild(Unknown Source) at oracle.cabo.ui.BaseRenderer.renderIndexedChild(Unknown Source) at oracle.cabo.ui.BaseRenderer.renderContent(Unknown Source) at oracle.cabo.ui.laf.base.DataScopeRenderer.renderContent(Unknown Source) at oracle.cabo.ui.BaseRenderer.render(Unknown Source) at oracle.cabo.ui.BaseUINode.render(Unknown Source) at oracle.cabo.ui.BaseUINode.render(Unknown Source) at oracle.cabo.servlet.ui.UINodePageRenderer.renderPage(Unknown Source) at oracle.cabo.servlet.AbstractPageBroker.renderPage(Unknown Source) at oracle.cabo.servlet.PageBrokerHandler.handleRequest(Unknown Source) at oracle.apps.fnd.oam.servlet.ui.OAMServlet.doGet(OAMServlet.java:293) at javax.servlet.http.HttpServlet.service(HttpServlet.java:707) at javax.servlet.http.HttpServlet.service(HttpServlet.java:820) at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227) at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:125) at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:301) at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:26) at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60) at oracle.apps.fnd.security.WLFilter.doFilter(WLFilter.java:216) at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60) at oracle.apps.jtf.cabo.interceptor.JTFWrapperFilter.doFilter(JTFWrapperFilter.java:149) at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60) at oracle.apps.jtf.base.session.ReleaseResFilter.doFilter(Unknown Source) at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60) at oracle.apps.fnd.security.AppsServletFilter.doFilter(AppsServletFilter.java:501) at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60) at oracle.security.jps.ee.http.JpsAbsFilter$1.run(JpsAbsFilter.java:138) at java.security.AccessController.doPrivileged(Native Method) at oracle.security.jps.util.JpsSubject.doAsPrivileged(JpsSubject.java:324) at oracle.security.jps.ee.util.JpsPlatformUtil.runJaasMode(JpsPlatformUtil.java:464) at oracle.security.jps.ee.http.JpsAbsFilter.runJaasMode(JpsAbsFilter.java:121) at oracle.security.jps.ee.http.JpsAbsFilter.doFilter(JpsAbsFilter.java:211) at oracle.security.jps.ee.http.JpsFilter.doFilter(JpsFilter.java:71) at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60) at oracle.dms.servlet.DMSServletFilter.doFilter(DMSServletFilter.java:163) at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60) at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3748) at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3714) at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321) at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:120) at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2283) at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2182) at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1499) at weblogic.work.ExecuteThread.execute(ExecuteThread.java:263) at weblogic.work.ExecuteThread.run(ExecuteThread.java:221)

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.