After upgrading from 12.0 SP1 to 12.0 SP2, the CA_Workload_Automaton_7599 service won't start.

Document ID : KB000007639
Last Modified Date : 14/02/2018
Show Technical Document Details
Issue:

After upgrading CA_Workload_Automaton_7599 service won't start. "Error: Java service failed to start. Aborted"

Environment:
Upgrade from DE 12.0 SP1 to DE 12.0 SP2 using a MSSQL database.
Cause:

DE 12.0 SP1 includes version 4.1 of the SQL JDBC.
Path: <cawa_install_path>\lib\sqljdbc41.jar

DE 12.0 SP2 includes version 4.2 of the SQL JDBC:
Path: <cawa_install_path>\lib\sqljdbc42.jar

The windows service properties file may not be updated to include the new <cawa_install_path>\lib\sqljdbc42.jar file in the classpath. This will cause the service not to start and terminate with error:

Error: Java service failed to start. Aborted

Resolution:

Edit the <cawa_install_path>\conf\windows.service.properties file.

Review the value for the 'classpath':

# Application related properties
classpath=<value>

It should include the path to the old <cawa_install_path>\lib\sqljdbc41.jar file.

Update this so that it points to the new file:
<cawa_install_path>\lib\sqljdbc42.jar

Save.

You will now be able to start the CA_Workload_Automaton_7599 service.