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.
Autosys 12.X
WORKLOAD CONTROL CENTER
WCC
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.