After upgrade to 12..1 SP1, AutoSys server fails to connect to SQL Server Database "CAUAJM_E_18601 SQLSTATE: IM008, Native error: 0, Message: [Microsoft][ODBC Driver Manager] Dialog failed"

Products

• Autosys Workload Automation

Issue/Introduction

After upgrade of AutoSys from R12.1 to R12.1 SP1, the AutoSys Application Server and Scheduler fail to connect to the database. The as_server and event_demon logs show the following error:

[09/27/2024 17:08:18]     CAUAJM_I_40275 Log Rollover level set to <MIDNIGHT,SIZE(100),PURGE(7)>.
[09/27/2024 17:08:18]     CAUAJM_I_40244 EnableIPCaching value set to <1>.
[09/27/2024 17:08:18]     CAUAJM_I_40244 LogMaxEndLines value set to <2,000>.
[09/27/2024 17:08:18]     CAUAJM_I_10655 System is running in single server mode.  Event server:  <hostname>.<example>.com,1433:<databasename>
[09/27/2024 17:08:18]     CAUAJM_E_18600 Database function call <SQLDriverConnect> failed in <connect SQLDriverConnect Failed> with return code: -1
[09/27/2024 17:08:18]     CAUAJM_E_18601 SQLSTATE: IM008, Native error: 0, Message: [Microsoft][ODBC Driver Manager] Dialog failed
[09/27/2024 17:08:18]     CAUAJM_E_10649 Server <hostname>.<example>.com,1433:<databasename> was not available during connection operation.

Environment

AutoSys 12.x

Cause

A change to the MSSQLDriverConnString section of the AutoSys config file is needed.

Resolution

• Backup the file %AUTOUSER%\config.<INSTANCEID>
  
  
• Edit the original file and look for MSSQLDriverConnString in that file and change it:

From:
MSSQLDriverConnString={ODBC Driver 17 for SQL Server}

To:
MSSQLDriverConnString=DRIVER={ODBC Driver 17 for SQL Server};

• Save the file
• Restart AutoSys and verify the startup

Additional Information

Below are additional tags that can be used to help deal with SSL configuration issues.
MSSQLDriverConnString=DRIVER={ODBC Driver 17 for SQL Server};TrustServerCertificate=No;Encrypt=No

 

 

The AutoSys WebServer may encounter similar errors and need configuration setting adjustments.

See C:\Program Files\CA\WorkloadAutomationAE\autosys\config\connection.properties

Example:

msql.driver.class.name=com.microsoft.sqlserver.jdbc.SQLServerDriver
msql.connection.string=jdbc:sqlserver://${servername}:${port};databasename=${dbname};trustServerCertificate=true;encrypt=true

msql_trusted.driver.class.name=com.microsoft.sqlserver.jdbc.SQLServerDriver
msql_trusted.connection.string=jdbc:sqlserver://${servername}:${port};databasename=${dbname};integratedSecurity=true;trustServerCertificate=true;encrypt=true