WebCenter Sites database operations failing in WebLogic due to java.sql.SQLRecoverableException: Connection has been administratively disabled. Try later. (Doc ID 1513817.1)

Last updated on JULY 31, 2023

Applies to:

Symptoms

WebCenter Sites application is inaccessible, or database operations are failing.

The following type of errors are seen in the sites.log:

[fatwire.logging.cs.db] SQLException in prepared execute on table {table name}: {query on table name}
java.sql.SQLRecoverableException: Connection has been administratively disabled. Try later.
  at weblogic.jdbc.common.internal.ConnectionEnv.checkIfEnabled(ConnectionEnv.java:1025)
  at weblogic.jdbc.wrapper.JTAConnection.checkConnection(JTAConnection.java:87)
  at weblogic.jdbc.wrapper.JTAConnection.checkConnection(JTAConnection.java:74)
  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)

This error could cause the Resultset cache for that query to be corrupted while this issue occurs.

Cause

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