Webui 12.0.01.00 upgrade from WCC 11.4 sp7 fails at DB validation step java.sql.SQLException: ORA-01017: invalid username/password; logon denied

Products

• CA Workload Automation AE

Issue/Introduction

Attempting to upgrade WCC 11.4 SP7 to Webui 12.0.01.00  fails at the 'Database Validation' as follows:

Error:
[CAUAJM_E_112508] An error occurred while connecting to the "AUTOSYS_WCC"
database server.
java.sql.SQLException: ORA-01017: invalid username/password; logon denied

Able to connect to the same Oracle database using sqlplus with the same logon credentials.

Environment

Autosys  12.X
WORKLOAD CONTROL CENTER
WCC

 

Resolution

The problem is related to the user that is found back in $CA_WCC_INSTALL_LOCATION//data/config/application/config/resources/connection.properties.

 Line 14: reporting.database.username=c\#\#autosys_master
 Line 39: wcc.database.username=c\#\#autosys_master

It struggles with the \ sign.

We give you the encrypted user so that slash in front of hash is not required so that during the upgrade, the installer uses the correct username instead of c\#\#autosys_master.

1. Take a backup of connection.properties.

2. Modify connection.properties for the below properties

reporting.database.username=c\#\#autosys_master
wcc.database.username=c\#\#autosys_master

    to

reporting.database.username=neh1fbmbrIATN4uX9fUQxNJZX6iK/7pGFcGjp8XwfzbcVWdSxIDYC9eUGO+jYHBcrchMgpMSJ9Assl2IjDfml1au2Gausbby0ZHyBNXVlN0\=
wcc.database.username=neh1fbmbrIATN4uX9fUQxNJZX6iK/7pGFcGjp8XwfzbcVWdSxIDYC9eUGO+jYHBcrchMgpMSJ9Assl2IjDfml1au2Gausbby0ZHyBNXVlN0\=

3. save connection.properties

4. run the upgrade again

 

Note : To obtain encrypted user, please raise a case with Support.