MS SQL job fails with:
20210629/075509.192 - U02000106 Reading content of connection object 'CONN.OBJECT'. 20210629/075509.237 - U02000107 Connection object 'CONN.OBJECT' with time stamp '1620835007000' was successfully transferred to the Agent. 20210629/075509.258 - U00029000 Report '8663026' for file 'C:\Automic\Agents\mssql\bin\..\temp\PLOG_OAASZRUY.TXT' has been started. 20210629/075509.758 - U02000009 Job 'JOBS.SQL' with RunID '8677004' ended with return code '102'. 20210629/075509.773 - U00029001 Report '8663026' ended normally. 20210629/075509.856 - U02001026 Job 'JOBS.SQL' with RunID '8677004' has been removed from the job table. 20210629/075509.884 - U00029000 Report '8661008' for file 'C:\Automic\Agents\mssql\bin\..\temp\OAASZRUY.TXT' has been started. 20210629/075509.887 - U00029001 Report '8661008' ended normally. 20210629/075953.410 - java.io.FileNotFoundException: C:\Automic\Agents\mssql\bin\..\temp\OAASZRUY.TXT (The system cannot find the file specified)
The AWI shows the following message:
Release : 12.3
Component : AUTOMATION ENGINE
Java: AdoptOpenJDK 11.0.11
Microsoft SQL JDBC driver: 4.2
Once the Microsoft JDBC driver 4.2 was replaced with the latest one 9.2.1 the job completed successfully.