MS SQL job fails with return code 102.

Products

• CA Automic Workload Automation - Automation Engine

Issue/Introduction

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:

Environment

Release : 12.3

Component : AUTOMATION ENGINE

Java: AdoptOpenJDK 11.0.11

Microsoft SQL JDBC driver: 4.2

Cause

Configuration.

Resolution

Once the Microsoft JDBC driver 4.2 was replaced with the latest one 9.2.1 the job completed successfully.