Error "java.sql.SQLRecoverableException: The connection is closed Error Code: 31" When Attempting to Login to the Team Member Web Application (Doc ID 2954320.1)

Last updated on JULY 09, 2023

Applies to:

Symptoms

When users attempt to log into Team Member, the following error occurs:

Error displayed in the Team Member application:

Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.4.v20190115-ad5b7c6b2a): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLRecoverableException: The connection is closed Error Code: 31

The following is observed in the <Oracle Middleware home>\user_projects\domains\<P6 EPPM domain>\servers\tmweb\logs\TeamMember.out log file:

<TIMESTAMP> <Error> <HTTP> <BEA-101020>
<[ServletContext@2089422197[app:p6tm module:p6tmweb path:null spec-version:3.1 version:21.12.6.0]] Servlet failed with an Exception javax.persistence.PersistenceException: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.4.v20190115-ad5b7c6b2a): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLRecoverableException: The connection is closed Error Code: 31
Call: DELETE FROM usession WHERE ((((USER_ID = ?) AND (SESSION_ID = ?)) AND (APP_NAME = ?)) AND (FORCE_LOGOUT_FLAG = ?)) bind => [1504, 33754517, Team Member, Y] Query: DeleteAllQuery(referenceClass=UserSession sql="DELETE FROM usession WHERE ((((USER_ID = ?) AND (SESSION_ID = ?)) AND (APP_NAME = ?)) AND (FORCE_LOGOUT_FLAG = ?))")
at org.eclipse.persistence.internal.jpa.QueryImpl.executeUpdate(QueryImpl.java:312)
at com.primavera.pr.dao.impl.UserSessionDaoImpl.deleteSessionForForceLogoutFlag(UserSessionDaoImpl.java:26)

The issue can be reproduced at will with the following steps:
1. Access the Team Member login page.
2. Enter username and password.
3. Select "Sign In".
4. Observe reported error.

Changes

Cause