Support Article
PRPC fails to start with "Connection has already been closed"
SA-6349
Summary
Using Tomcat 7, when trying to start the PRPC application, the server startup fails.
Error Messages
java.sql.SQLException: Connection has already been closed.
at org.apache.tomcat.jdbc.pool.ProxyConnection.invoke(ProxyConnection.java:117)
Steps to Reproduce
Not applicable
Root Cause
The root cause of this problem is the database performance issue causing the tomcat connection pool abandons certain seemingly idle connections.
Resolution
Address the database performance with tje DBA (in this case recycling the database server) and adjust the removeAbandonedTimeout value in the PegaRULES datasource definition to a higher value (e.g., from the current 300 seconds to 600 seconds).
Published January 31, 2016 - Updated October 8, 2020
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.