Jaspersoft install script fails with Error "Invalid connection string format..."

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

Jaspersoft 7.8 upgrade/install fails with error "Invalid connection string format, a valid format is: "host:port:sid" "

Install.log:

BUILD FAILED
/proj/clarity/installs/js713/install.xml:332: The following error occurred while executing this line:
/proj/clarity/installs/js713/install.xml:718: Unable to connect Jasper Database
  ERROR: java.sql.SQLRecoverableException: IO Error: Invalid connection string format, a valid format is: "host:port:sid"

Environment

Clarity 15.9.2 and Jaspersoft 7.8

Cause

DB configuration parameters (Host name, Port or SID/service name) are not provided correctly to the install script.

Resolution

Check the oracle DB host name to see if there is a trailing space (this can happen if you copy/paste the password from somewhere such as from MS excel to the command prompt/terminal)

Note: The trailing extra space may go unnoticed watch out for something such as the following in orange in the install log:

Select Oracle Database Type
 1) Oracle Standalone
 2) Oracle Cluster(RAC)

Choose option [2]: 

Enter Oracle Database Hostname [DBHOSTNAME.com  ]

Additional Information

See also: Jaspersoft / reports known issues with Clarity