You are currently reviewing an older revision of this page.

SP-4611 Database calls fail with "Connection has already been closed" for on-premise installations

Symptoms

Calls to the database from the app server fail after an upgrade or migration to another virtual machine or server for an on-premise installation. The following error can be seen in the application server log:

ERROR org.hibernate.transaction.JDBCTransaction - Could not toggle autocommit
java.sql.SQLException: Connection has already been closed.

Cause

Databases have a default timeout period after which idle connections are terminated, causing the app server to be unable to make calls to the database.

Action

Increase the value of  removeAbandonedTimeOut in tomcat-resources.xml.

Affected Versions

This article applies to Appian 19.1 and later.

Last Reviewed: June 2020