After installing AutoSys 12.1.1 or v24, on Redhat 9.5, using SQL Server database, the Scheduler / Application Server do not start. Below errors are seen in the event_demon / as_server logs:
[04/04/2025 13:34:53] CAUAJM_E_18600 Database function call <SQLDriverConnect> failed in <connect SQLDriverConnect Failed> with return code: -1
[04/04/2025 13:34:53] CAUAJM_E_18601 SQLSTATE: IM008, Native error: 0, Message: [Microsoft][ODBC Driver 18 for SQL Server]Dialog failed
[04/04/2025 13:34:53] CAUAJM_E_10649 Server <hostname>.<example>.<com>,1433:<databasename> was not available during connection operation.
AutoSys 12.X or 24.x
Redhat 9.5
Microsoft SQL server
Microsoft ODBC Driver 18
OpenSSL 3.3.2
There is a known issue with Microsoft ODBC drivers for SQL Server on Redhat 9.5 with OpenSSL 3.3.2 version present on the AutoSys servers. This combination does not seem to complete the ODBC connection, there by impacting AutoSys programs.
Microsoft is researching this towards a resolution.
Below workaround can be attempted while Microsoft clears up the issue with ODBC driver for SQL Server
Work with your system administrators to downgrade openssl to 3.0.7. An example command to downgrade:
yum downgrade openssl-3.0.7