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.
Release : 12.0
Component : WORKLOAD CONTROL CENTER
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.