How to change database user credentials in WebUI/WCC?

Products

• Autosys Workload Automation

Issue/Introduction

Once DBA changedswcc runtime user password in postgres, unable to update it in WCC now using wcc_config command.  How to change it in WCC?

./wcc_config.sh -u XXXXX -p XXXXX --dbuser wcc --dbpassword newpass

## this seems to just hang   and wcc_config.log  shows 
[ <main> [[]] ] ERROR 2026-01-30 18:26:21,519  com.ca.wcc.dbresource.datasource.WccDataSource(295) Database not available yet. Cannot create the jdbc pool. Will retry after 3056 milliseconds org.postgresql.util.PSQLException: FATAL: password authentication failed for user "wcc"
        at org.postgresql.core.v3.ConnectionFactoryImpl.doAuthentication(ConnectionFactoryImpl.java:777)
        at org.postgresql.core.v3.ConnectionFactoryImpl.tryConnect(ConnectionFactoryImpl.java:234)
        at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:289)
        at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:57)
        at org.postgresql.jdbc.PgConnection.<init>(PgConnection.java:277)
        at org.postgresql.Driver.makeConnection(Driver.java:448)
        at org.postgresql.Driver.connect(Driver.java:298)
        at org.apache.tomcat.jdbc.pool.PooledConnection.connectUsingDriver(PooledConnection.java:346)
        at org.apache.tomcat.jdbc.pool.PooledConnection.connect(PooledConnection.java:227)

 

Oracle database might give an error like this:

[ <main> [[]] ] ERROR 2026-03-04 14:29:09,221  com.ca.wcc.dbresource.datasource.WccDataSource(295) Database not available yet. Cannot create the jdbc pool. Will retry after 6705 milliseconds java.sql.SQLException: ORA-01017: invalid username/password; logon denied

Resolution

Workaround for now:

• Backup below files:

  <wcc>/data/config/application/config/resources/connection.properties

  <wcc>/collectors/WCC_COLLECTOR/data/config/application/config/resources/connection.properties 

• Edit the original files and put clear text password values for the runtime user for below two parameters:

wcc.database.password=#########

reporting.database.password=#######   

• Change directory to  <wcc>/bin

cd <wcc>/bin

## if you have reporting enabled, you need to do 2 commands

./wcc_config.sh -u user_name -p password --dbuser db_user --dbpassword db_password --dbapp MAIN

./wcc_config.sh -u user_name -p password --dbuser db_user --dbpassword db_password --dbapp REPORTING

## -u  is the user that logs into WCC UI

• This set the passwords encrypted for us again and we could start WCC without issue
  
  
• Restart CA-wcc-services service to restart WCC and verify everything works fine now

Additional Information

This will be addressed by engineering shortly