JWP fails to start when using Microsoft JDBC Driver 6.0

Products

• CA Automic Workload Automation - Automation Engine

Issue/Introduction

Error Message :
U00045015 The previous error was caused by 'java.lang.NoClassDefFoundError: "javax/xml/bind/DatatypeConverter"' at 'com.microsoft.sqlserver.jdbc.SQLServerConnection.sendLogon():4098'. 

When using Microsoft JDBC Driver 6.0 for Automic's Java Worker Process (JWP), the JWP fails to start and the following errors can be found in the log file:
 

U00003545 UCUDB: Opening database ... 
U00045025 OSGI ['org.eclipse.equinox.ds']: '[SCR] Exception while activating instance [email protected] of component com.automic.kernel.impl.ServerProcess ' 
U00045014 Exception 'java.lang.reflect.InvocationTargetException: "null"' at 'sun.reflect.NativeMethodAccessorImpl.invoke0():-2'. 
U00045015 The previous error was caused by 'java.lang.NoClassDefFoundError: "javax/xml/bind/DatatypeConverter"' at 'com.microsoft.sqlserver.jdbc.SQLServerConnection.sendLogon():4098'. 
U00045015 The previous error was caused by 'java.lang.ClassNotFoundException: "javax.xml.bind.DatatypeConverter cannot be found by com.automic.database_1.0.0"' at 'org.eclipse.osgi.internal.loader.BundleLoader.findClassInternal():501'. 

Environment

OS: Windows
OS Version: N/A

Cause

Cause type:
Other
Root Cause: Must upgrade to a newer AE version to use newer Microsoft JDBC drivers.

Resolution

Update to a fix version listed below or a newer version if available in order to use the latest JDBC Drivers from Microsoft.
 

Fix Status: Released

Fix Version(s):
Automation Engine 12.0.2 - Available
Automation Engine 11.2.5 – Available

Additional Information

Workaround :
Use the old Microsoft JDBC 4 drivers which can be found here: 

4.0: https://www.microsoft.com/en-us/download/details.aspx?id=54629 
4.1: https://www.microsoft.com/en-us/download/details.aspx?id=54670 
4.2: https://www.microsoft.com/en-us/download/details.aspx?id=54671