wcc_config to change database credentials fails with a null pointer exception

Products

• Autosys Workload Automation

Issue/Introduction

change database credentials fails with a null pointer exception, /opt/CA/WorkloadAutomationAE/wcc/log/application/cli/wcc_config.log shows below error:

[ <main> [[]] ] ERROR 2025-05-15 11:28:38,063  com.ca.wcc.config.command.cli.ConfigurationCommand(1846) null java.lang.NullPointerException
    at com.ca.wcc.config.command.cli.ConfigurationCommand.getDBParams(Unknown Source)
    at com.ca.wcc.config.command.cli.ConfigurationCommand.getNonApplicableProperties(Unknown Source)
    at com.ca.wcc.config.command.cli.ConfigurationCommand.removeNonApplicableProperties(Unknown Source)
    at com.ca.wcc.config.command.cli.ConfigurationCommand.doValidateDBChanges(Unknown Source)
    at com.ca.wcc.config.command.cli.ConfigurationCommand.doValidateDBChanges(Unknown Source)
    at com.ca.wcc.config.command.cli.ConfigurationCommand.main(Unknown Source)

 

Database is being accessed via password authentication option (wallet authentication is not being used)

Environment

Workload Automation AutoSys

Cause

 Below two parameters are missing from the main WCC (WCC_INSTALL_LOCATION/data/config/application/config/resources/connection.properties) and  Collector (WCC_INSTALL_LOCATION/collectors/WCC_COLLECTOR/data/config/application/config/resources/connection.properties)  connection.properties files

wcc.database.accessmode=PASSWORD
reporting.database.accessmode=PASSWORD

 

Resolution

Below steps are valid only for password based authentication to access WCC database schema.

1) Backup the WCC (WCC_INSTALL_LOCATION/data/config/application/config/resources/connection.properties) and Collector (WCC_INSTALL_LOCATION/collectors/WCC_COLLECTOR/data/config/application/config/resources/connection.properties)  connection.properties 

2) Edit the original files and add below entries:

wcc.database.accessmode=PASSWORD
reporting.database.accessmode=PASSWORD

Note: The value of the above attribute is the string PASSWORD itself, do not change it to a real password of any user.

3) Save the files

4) Retry the wcc_config command again