JDE agent is unable to connect to MSSQL database.

Products

• CA Automic Workload Automation - Automation Engine

Issue/Introduction

When trying to start the JDE agent and the agent log returns

20210921/102917.777 - U02000106 Reading content of connection object 'CONN.JDEDWARDSAGENT.JDEDWARDSCONNECTION.JDEPY'.
20210921/102917.794 - U02000107 Connection object 'CONN.JDEDWARDSAGENT.JDEDWARDSCONNECTION.JDEPY' with time stamp '1630490525000' was successfully transferred to the Agent.
20210921/102917.883 - Internal Error
20210921/102917.883 - JDBCConnection createConnection: CONN.JDEDWARDSAGENT.JDEPY
20210921/102917.883 - U00003620 Routine 'UCEX_R' forces trace because of error.

The forced trace shows the following error:

java.lang.ClassNotFoundException: net.sourceforge.jtds.jdbc.Driver 

Environment

Release : 12.3

Component : RA JD EDWARDS

Resolution

The JD Edwards Agent uses a different library for MSSQL instead of the Official MSSQL.
Please download the JTDS library from http://jtds.sourceforge.net/ and place it in the agent's lib folder.
Then restart the Agent.