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:

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

Jaspersoft studio connections can also fail during the same timeframe with error: 

Execute Query fail.Execute Query fail.Connection Error.Cannot get bean datasource connection: [http-nio-8089-exeс-49]

45 seconds, none available[size:16; busy:15; idle:0; lastwait: 45000] .

 

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