Clarity Jaspersoft Reports fail with error: Timeout Pool empty. Unable to fetch a connection in 45 seconds.
In the Jaspersoft logs, the following warning message is generated:
16-Apr-2019 00:40:12.359 WARNING [Tomcat JDBC Pool Cleaner[....]] org.apache.tomcat.jdbc.pool.ConnectionPool.abandon Connection has been abandoned PooledConnection[oracle.jdbc.driver.T4CConnection@11zzzzz]:java.lang.Exception
This situation arises when the connection pool is Jaspersoft is exhausted. There could be a number of other reasons including long-running reports
A restart of the Jaspersoft services can release the connections. If you are unable to restart the services, run the below commands
admin update jasperParameter
admin jaspersoft syncPPMContext -userName <username> -password <password>
To resolve issues permanently, ensure you use Jaspersoft servers for reporting and not data extraction