Experiencing any of the below symptoms with the error:
Error in app-ca/bg-ca log:
ERROR 2021-03-10 00:13:36,700 [https-jsse-nio2-8444-exec-27] niku.security (clarity:unknown:xxxxxx:none) UserSessionCache.get:PMD error
com.niku.union.persistence.PersistenceException: Error getting a DB connection
at com.niku.union.persistence.PersistenceController.doProcessRequest(PersistenceController.java:620)
at com.niku.union.persistence.PersistenceController.processRequest(PersistenceController.java:311)
Caused by: org.apache.tomcat.jdbc.pool.PoolExhaustedException: [https-jsse-nio2-8444-exec-27]Timeout: Pool empty. Unable to fetch a connection in 30 seconds, none available[size:1000; busy:1000; idle:0; lastwait:30000].
Note: This article is also applicable if you experience a number of fast growing connections in the database and the DBA kills them before they hit the 1000 limit.
Release : Any
Component : CA PPM INTEGRATIONS & INSTALLATIONS
To remedy the problem, restart the services, this should free up the connections.
Consider gathering the below information before restarting in order to be able to determine the root cause. Or plan to do this if you have already restarted if this happens again:
Manual heap dump for application hanging or slow performance
http://SERVERNAME:PORT/niku/apache