WCC upgrade error "IO error: connect identifier was empty"

Products

• CA Workload Automation AE

Issue/Introduction

When running an upgrade from an 11.4.x server to 11.4.7, the following error is received after selecting the installer Upgrade option:

"IO error: connect identifier was empty"

Environment

Release : 11.3.6

Component : CA Workload Automation AE (AutoSys)

Cause

This issue occurs if you have installed an older 11.4.x server using the Oracle TNS option. This option leaves the following parameters empty in the $CA_WCC_INSTALL_LOCATION/data/config/application/config/resources/connection.properties file:

reporting.database.dbname=
wcc.database.dbname=

This is not an issue while running the older version as the service name is stored in the same file under these parameters:
wcc.database.tnsname=<oracle_service_name>
reporting.database.tnsname=<oracle_service_name>

However, it does cause the reported error during an upgrade.

Resolution

Edit the $CA_WCC_INSTALL_LOCATION/data/config/application/config/resources/connection.properties file and populate the following parameters with the Oracle service name:

reporting.database.dbname=<oracle_service_name>
wcc.database.dbname=<oracle_service_name>

The above should match the service name you already have in the following parameters in the same connection.properties file:

wcc.database.tnsname=<oracle_service_name>
reporting.database.tnsname=<oracle_service_name>

There is no need to restart WCC services. You may run the WCC 11.4.7 upgrade directly after this change.