WCS on WLS - java.sql.SQLException: Connection has been administratively destroyed. Reconnect. (Doc ID 1530765.1)

Last updated on JULY 31, 2023

Applies to:

Symptoms

The following errors are littered in sites.log:

"

java.sql.SQLRecoverableException: No more data to read from socket
    at oracle.jdbc.driver.T4CMAREngine.unmarshalUB1(T4CMAREngine.java:1157)
    at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:290)
    at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:192)
    at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)
    at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:207)
    at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1044)
    at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1199)
    at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1289)
    at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3593)
    at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3694)
    at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1378)
    at weblogic.jdbc.wrapper.PreparedStatement.execute(PreparedStatement.java:99)
    at COM.FutureTense.Servlet.JDBCConn.executeStatement_trans(JDBCConn.java:477)
    at COM.FutureTense.Servlet.JDBCConn.executeStatement(JDBCConn.java:318)
    at COM.FutureTense.CatalogManager.CatalogEngine._executePreparedStmt(CatalogEngine.java:5143)
    at COM.FutureTense.CatalogManager.CatalogEngine.executeStatement(CatalogEngine.java:5078)
    at COM.FutureTense.Common.CS.SQL(CS.java:1164)
    at com.fatwire.queue.PersistentAssetQueueRegistry.getQueues(PersistentAssetQueueRegistry.java:344)
    at com.fatwire.search.util.AssetQueueIndexSourceUtil._processAll(AssetQueueIndexSourceUtil.java:81)
    at com.fatwire.search.util.AssetQueueIndexSourceUtil.access$000(AssetQueueIndexSourceUtil.java:35)
    at com.fatwire.search.util.AssetQueueIndexSourceUtil$indexingRunnable.run(AssetQueueIndexSourceUtil.java:51)
    at java.lang.Thread.run(Thread.java:662)

java.sql.SQLException: Connection has been administratively destroyed. Reconnect.
    at weblogic.jdbc.common.internal.ConnectionEnv.checkIfEnabled(ConnectionEnv.java:1024)
    at weblogic.jdbc.wrapper.PoolConnection.checkConnection(PoolConnection.java:63)
    at weblogic.jdbc.wrapper.Connection.preInvocationHandler(Connection.java:100)
    at weblogic.jdbc.wrapper.Connection.prepareStatement(Connection.java:573)
    at COM.FutureTense.Servlet.JDBCTable.executeQuery_trans_logic(JDBCTable.java:1620)
    at COM.FutureTense.Servlet.JDBCTable.executeQuery_trans(JDBCTable.java:1590)
    at COM.FutureTense.Servlet.JDBCTable.executeQuery(JDBCTable.java:1430)
    at COM.FutureTense.Servlet.JDBCTable.SelectRow(JDBCTable.java:1025)
    at COM.FutureTense.Common.ftDBTable.selectTo(ftDBTable.java:2229)
    at COM.FutureTense.ContentServer.SiteCatalog.get(SiteCatalog.java:287)
    at COM.FutureTense.Common.ContentServer.getPageData(ContentServer.java:919)
    at COM.FutureTense.Common.ContentServer.execute(ContentServer.java:441)
    at COM.FutureTense.Servlet.FTServlet.execute(FTServlet.java:129)
    at COM.FutureTense.Servlet.FTServlet.doPost(FTServlet.java:61)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
    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:56)
    at com.fatwire.auth.RequestAuthenticationFilter.doFilter(RequestAuthenticationFilter.java:192)
    at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
    at com.fatwire.wem.sso.cas.filter.CASFilter.doFilter(CASFilter.java:695)
    at com.fatwire.wem.sso.SSOFilter.doFilter(SSOFilter.java:51)
    at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
    at com.fatwire.cs.ui.framework.UIFilter.doFilter(UIFilter.java:108)
    at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
    at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3730)
    at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3696)
    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:2273)
    at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2179)
    at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1490)
    at weblogic.work.ExecuteThread.execute(ExecuteThread.java:256)
    at weblogic.work.ExecuteThread.run(ExecuteThread.java:221)

weblogic.jdbc.extensions.PoolDisabledSQLException: weblogic.common.resourcepool.ResourceDisabledException: Pool csDataSource is Suspended, cannot allocate resources to applications..
    at weblogic.jdbc.common.internal.JDBCUtil.wrapAndThrowResourceException(JDBCUtil.java:251)
    at weblogic.jdbc.pool.Driver.connect(Driver.java:142)
    at weblogic.jdbc.jts.Driver.getNonTxConnection(Driver.java:658)
    at weblogic.jdbc.jts.Driver.connect(Driver.java:127)
    at weblogic.jdbc.common.internal.RmiDataSource.getConnectionInternal(RmiDataSource.java:533)
    at weblogic.jdbc.common.internal.RmiDataSource.getConnection(RmiDataSource.java:498)
    at weblogic.jdbc.common.internal.RmiDataSource.getConnection(RmiDataSource.java:491)
    at com.fatwire.cs.core.db.DataSourceBackedPool.acquire(DataSourceBackedPool.java:47)
    at COM.FutureTense.Servlet.JDBCTable.executeUpdate_trans_logic(JDBCTable.java:1355)
    at COM.FutureTense.Servlet.JDBCTable.executeUpdate_trans(JDBCTable.java:1337)
    at COM.FutureTense.Servlet.JDBCTable.executeUpdate(JDBCTable.java:1211)
    at COM.FutureTense.Servlet.JDBCTable.AddRow(JDBCTable.java:943)
    at COM.FutureTense.Common.ftDBTable.insertRow(ftDBTable.java:1272)
    at COM.FutureTense.Cache.EHCacheInvalidationMemory.addInvalidation(EHCacheInvalidationMemory.java:162)
    at COM.FutureTense.Cache.EHCacheInvalidationMemory.deleteInvalidationsBefore(EHCacheInvalidationMemory.java:249)
    at COM.FutureTense.Common.CacheServer._purgeInvalidationmemory(CacheServer.java:209)
    at COM.FutureTense.Common.CacheServer.flushPages(CacheServer.java:192)
    at COM.FutureTense.Common.CacheServer.execute(CacheServer.java:79)
    at COM.FutureTense.Servlet.FTServlet.execute(FTServlet.java:129)
    at COM.FutureTense.Servlet.FTServlet.doPost(FTServlet.java:61)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
    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:56)
    at com.fatwire.auth.RequestAuthenticationFilter.doFilter(RequestAuthenticationFilter.java:192)
    at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
    at com.fatwire.wem.sso.cas.filter.CASFilter.doFilter(CASFilter.java:695)
    at com.fatwire.wem.sso.SSOFilter.doFilter(SSOFilter.java:51)
    at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
    at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3730)
    at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3696)
    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:2273)
    at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2179)
    at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1490)
    at weblogic.work.ExecuteThread.execute(ExecuteThread.java:256)
    at weblogic.work.ExecuteThread.run(ExecuteThread.java:221)

"
No particular activities on the server when the issue occurs.

Changes

Cause

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