Customer is getting CAUAJM_E_112531 when installing 12.0 against SQL Server

Products

• CA Workload Automation AE - Scheduler (AutoSys)

Issue/Introduction

Customer is getting CAUAJM_E_112531 when installing 12.0 against SQL Server

 

cawa_installer.log shows below info: 
 
 2021-03-16 11:27:35,574 [Thread-17044] DEBUG com.ca.autosys.db.helper.SystemUtil - Exception occured while get value of :IA_AE_USE_CUSTOM_DB_PROP
 2021-03-16 11:27:35,574 [Thread-17044] DEBUG com.ca.autosys.db.helper.SystemUtil - val: null
 2021-03-16 11:27:35,574 [Thread-17044] INFO  com.ca.autosys.db.utils.DatabaseProperties - loading from resources
 2021-03-16 11:27:35,590 [Thread-17044] DEBUG com.ca.autosys.db.connection.DBOperations - Running query: SELECT  CAST(SERVERPROPERTY(?) AS varchar) as value
 2021-03-16 11:27:35,684 [Thread-17044] DEBUG com.ca.autosys.db.connection.DBOperations - Query params:
 2021-03-16 11:27:35,699 [Thread-17044] DEBUG com.ca.autosys.db.connection.DBOperations - [1 : InstanceName]
 2021-03-16 11:27:35,746 [Thread-17044] DEBUG com.ca.wla.ae.installer.database.MSSQLHelper - Found instance name = AUTOSYS
 2021-03-16 11:27:35,746 [Thread-17044] ERROR com.ca.wla.ae.installer.logger.LogHelper - [CAUAJM_E_112531] The MSSQL server instance name "AUTOSYS" detected from the database does not match with the specified value. Correct the instance name and retry.

 

Environment

Release : 12.0

Component : CA Workload Automation AE (AutoSys)

Cause

Customer setup SQL Server Named Instance called AUTOSYS, against which he was attempting the install.

During the install, on the DB server option, customer provided the value as SQLServerHostname. As customer is using a SQL Server Named Instance called AUTOSYS, the format of this should be like SQLServerHostName\InstanceName     (for this use case, it would be RealSQLServerHostName\AUTOSYS )

Once this was done, the installer passed

Resolution

As SQL Server Named Instance is being used, the Database Server value should be in the format of  SQLServerHostName\InstanceName     (for this use case, it would be RealSQLServerHostName\AUTOSYS )

 

Additional Information

https://techdocs.broadcom.com/us/en/ca-enterprise-software/intelligent-automation/autosys-workload-automation/12-0/messages/error-messages/cauajm-e-112531.html