Portal error "JasperReports encountered an error on context creation!" occurred due to lisa.properties property change

Products

• CA Application Test
• CA Continuous Application Insight (PathFinder)

Issue/Introduction

Getting this error when running any report from the DevTest Portal:

JasperReports encountered an error on context creation! 

java.sql.SQLNonTransientConnectionException: java.net.ConnectException : Error connecting to server localhost on port 1528 with message Connection refused.

 

Environment

All supported DevTest releases and platforms.

Cause

This property was changed in the lisa.properties file:

From:

lisadb.internal.host=0.0.0.0

To:

lisadb.internal.host=<hostname of computer running Registry>

 

This property configures the Derby database to be accessible from all network interfaces present on the machine, which is why it should never be changed.

 

Derby is not supported in a production environment, only verifying the product out of the box.

Resolution

Setting value back in the lisa.properties file to:

lisadb.internal.host=0.0.0.0

Restart Portal.

Additional Information

It is recommended to never change the lisa.properties file properties to other values.