JDBC error "Connection reset" on 64 bit Linux while trying to upgrade/install Clarity or Jaspersoft

Products

• Clarity PPM On Premise

Issue/Introduction

JDBC error "Connection Reset" on 64 bit System Linux System while trying to upgrade/install Clarity or Jaspersoft fails with the below errors:

Clarity Install/Upgrade Error:

(ExecTask) java.sql.SQLNonTransientConnectionException: [CA Clarity][Oracle JDBC Driver]Connection reset

Jaspersoft Install/Upgrade Error

JaspersoftInstall/buildomatic/bin/app-server.xml:60: java.sql.SQLRecoverableException: IO Error: Connection reset

Environment

Release: All Supported Clarity & Jaspersoft version

Cause

To reduce latency using JVM option

Resolution

1. Modify the security file of JAVA
2. Access the Java folder on application server
   • Java 8 - $JAVA_HOME/lib/security/java.security
   • Java 11 - $JAVA_HOME/conf/security/java.security
3. Take a backup of file java.security and change to
   • securerandom.source=file:/dev/urandom instead of securerandom.source=file:/dev/random
4. Save the file and rerun the install/upgrade