[CAUAJM_E_112515] Unable to connect to the "hostname.example.com" database server using the database client utility. For more information, refer to the log file.

Products

• Autosys Workload Automation

Issue/Introduction

When upgrading from Autosys 12.1 to 24.0 on Windows , following error is produced when database validation is being done

[CAUAJM_E_112515] Unable to connect to the "hostname.example.com" database server using the database client utility. For more information, refer to the log file.

Environment

Autosys 12.1 - Windows OS

Cause

From "cawa_installer.log" file following can be found

2025-02-05 12:18:55,082 [Thread-10282] DEBUG com.ca.autosys.db.helper.SystemUtil(151) - val: 
2025-02-05 12:18:55,083 [Thread-10282] DEBUG com.ca.autosys.db.utils.CommandExecutor(59) - In execute Command
2025-02-05 12:18:55,137 [Thread-10303] ERROR com.ca.autosys.db.utils.CommandExecutorThread(44) - 'sqlcmd' is not recognized as an internal or external command,
2025-02-05 12:18:55,137 [Thread-10303] ERROR com.ca.autosys.db.utils.CommandExecutorThread(44) - operable program or batch file.
2025-02-05 12:18:55,140 [Thread-10282] DEBUG com.ca.autosys.db.utils.CommandExecutor(87) - Command value : 
2025-02-05 12:18:55,140 [Thread-10282] INFO  com.ca.autosys.db.utils.CommandExecutor(88) - Command return value: =1
2025-02-05 12:18:55,140 [Thread-10282] ERROR com.ca.wla.ae.installer.customaction.validate.AEValidateDBUpgradeAdminInfo(184) - Failed to connect to database using client
2025-02-05 12:18:55,140 [Thread-10282] ERROR com.ca.wla.ae.installer.logger.LogHelper(27) - [CAUAJM_E_112515] Unable to connect to the "hostname.example.com" database server using the database client utility. For more information, refer to the log file.
2025-02-05 12:18:55,140 [Thread-10282] DEBUG com.ca.wla.ae.installer.logger.LogHelper(35) - Setting the result variables:$AE_DB_UPG_ADMIN_INFO_VALIDATE_RETURN_STATUS$ to:E_AE_DB_Client_Connect_Err :$AE_DB_UPG_ADMIN_INFO_VALIDATE_RETURN_MSG$ to:[CAUAJM_E_112515] Unable to connect to the "hostname.example.com" database server using the database client utility. For more information, refer to the log file.
2025-02-05 12:18:55,140 [Thread-10282] INFO  com.ca.wla.ae.installer.customaction.validate.AEValidateDBUpgradeAdminInfo(111) - Done validating the Database admin information

sqlcmd is not found by installer

Resolution

Check if sqlcmd exists on the Windows machine.

• If not, install SQL Client utilities
• If yes, check if location of sqlcmd is added to OS environmental variable PATH.