Installer Fails to Create AEDB Schema

Products

• CA Workload Automation AE - Business Agents (AutoSys)
• CA Workload Automation AE - System Agent (AutoSys)
• CA Workload Automation AE - Scheduler (AutoSys)
• Workload Automation Agent
• CA Workload Automation AE

Issue/Introduction

While installing CA WAAE, creation of AEDB failed with below error.

sqlcmd -U sa -P ****** -S XXXXX-XXXXX,XXXX-m 11 -e -i chk_trans_level.sql 2>&1
'XX:' is not recognized as an internal or external command,
operable program or batch file.

Environment

Release : All Supported version of Workload Automation AE (AutoSys)

Resolution

This issue occurs if the SA password has special characters as & or %.

For example, if the password of SA is m08ug&SB. Then it will failed with below error.

sqlcmd -U sa -P ****** -S XXXXX-XXXXX,XXXX-m 11 -e -i chk_trans_level.sql 2>&1
'SB:' is not recognized as an internal or external command,
operable program or batch file.

Additional Information

If the issue persists, please raise case with support.