Oracle Wallet configuration attempt in WCC gives an error E190664 - Cannot connect to database. Changes will not be applied. See log for full exception.

Products

• Autosys Workload Automation

Issue/Introduction

Attempts to configure Oracle Wallets in WCC gives an error:

 

./wcc_config.sh -u ejmcommander -p ejmcommander -dbtruststoretype SSO  --dbtruststorepath /home/autosys/wallet/newWallet/cwallet.sso  --dbtnsname wallet19 --dbtnspath /oracle/product/19.3.0/db_1/network/admin --dbschemauser wccadmin
Logging in as 'ejmcommander' - SUCCESS

Validating tomcat DB details... 
Cannot validate the database using the connection properties below:
Host Name: null
Port: null
Database instance name: null
Path to the trust store: /home/autosys/wallet/newWallet/cwallet.sso
Trust store type: SSO
Schema User: wccadmin
Platform: ORACLE

Note: For the certificate authentication with Oracle database, keep in mind that the correct version of Oracle PKI libraries is used. Please, make sure that the oraclepki.jar, osdt_core.jar and osdt_cert.jar files are taken from the Oracle DB version you are trying to connect to and that they are placed in the following WCC directories:
WCC_ROOT_DIRECTORY/bin/lib
E190664 - Cannot connect to database. Changes will not be applied. See log for full exception.

 

<wcc>/log/applicaiton/cli/wcc_config.log has an exception:

[ <main> [[]] ] ERROR 2026-01-22 19:52:16,304  com.ca.wcc.config.command.cli.ConfigurationCommand(575) Cannot connect to DB java.lang.NullPointerException
        at java.util.Hashtable.put(Hashtable.java:460)
        at java.util.Properties.setProperty(Properties.java:166)
        at com.ca.wcc.dbresource.datasource.UnlockingDatasource.setOraclePKISpecificProperties(Unknown Source)
        at com.ca.wcc.dbresource.datasource.UnlockingDatasource.setParameters(Unknown Source)
        at com.ca.wcc.config.command.cli.ConfigurationCommand.validateDB(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)

Resolution

Add  --dbserverdnmatch=false  to the wcc_config syntax (or if a value of true is required, set it to true appropriately per your DB requirement)

Example:

./wcc_config.sh -u ejmcommander -p ejmcommander -dbtruststoretype SSO  --dbtruststorepath /home/autosys/wallet/newWallet/cwallet.sso  --dbtnsname wallet19 --dbtnspath /oracle/product/19.3.0/db_1/network/admin --dbschemauser wccadmin --dbserverdnmatch=false