JasperReport Server crashing

Document ID : KB000072614
Last Modified Date : 06/03/2018
Show Technical Document Details
Issue:
The Jaspersoft server keeps going down and we need to restart the server in order to access the Reporting.
The error message in the logs is: 
"Cannot get a connection, pool error Timeout waiting for idle object" in the error which means that there is some misconfiguration in context.xml or your network is not always responsive to get repository database connections.
Resolution:
Under context.xml setting if testOnBorrow set to true but without the validation query this setting does nothing. When the connection is borrowed from the pool it is not validated because no validation query is defined.

Please specify the validationQuery property like this: 
validationQuery="select 1 from dual" 

Add this to the connection pool definition in {JRS WAR}/META-INF/context.xml file to the jdbc/jasperserver resource