Jaspersoft Reports fail with error: 'Timeout Pool empty...'

Products

• Clarity PPM SaaS
• Clarity PPM On Premise

Issue/Introduction

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

Cause

This situation arises when the connection pool is Jaspersoft is exhausted. There could be a number of other reasons including long-running reports

Resolution

 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