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

Release : 12.0

Component : WORKLOAD CONTROL CENTER

Resolution

Problem is related to 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 upgrade, installer uses correct username instead of c\#\#autosys_master.

1. Take a backup of connection.properties.

2. Modify connection.properties for 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 upgrade again

 

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