Clarity Upgrade fails with "java.lang.IllegalArgumentException: Invalid JDBC properties for Oracle: host = null"

Products

• Clarity PPM On Premise

Issue/Introduction

During an upgrade, the upgrade process fails during the database connectivity test phase. The following error is observed in the install.log or console output:

(ExecTask) Exception occured when trying to construct the Database object for Tenant with id = clarity
(ExecTask) java.lang.IllegalArgumentException: Invalid JDBC properties for Oracle: host = null port = null sid = serviceName = null
(ExecTask) at com.niku.union.config.MigratableDatabaseURL.toString(MigratableDatabaseURL.java:561)
(ExecTask) at com.niku.union.config.TenantConfigurationBuilder.getTenantDatabase(TenantConfigurationBuilder.java:1150)
...
(ExecTask) Installing schema file: $CLARITY_HOME/IS_CUSTOMER_DB.xml...

 

Environment

Clarity 16.x

Cause

This is caused due to singleTenantMode setting in properties.xml being set to false.

Resolution

Make the following modification in properties.xml and initiate the upgrade. 

singleTenantMode="false" to singleTenantMode="true"

Additional Information

While it doesn't directly cause an issue, it's better to have the JDBC connection URL of PPM and DWH void of unnecessary spaces.

Correct Example :- url="jdbc:oracle:thin:@(DESCRIPTION=(CONNECT_TIMEOUT=15)(RETRY_COUNT=20)(RETRY_DELAY=3)(ADDRESS_LIST=(ADDRESS=(PROTOCOL=tcp)(HOST=example.com)(PORT=XXXX)))(CONNECT_DATA=(SERVICE_NAME=service_nm)))" host="example.com"