Cannot start JWP | U00045028 Only DSN less connect strings are

Products

• CA Automic Workload Automation - Automation Engine

Issue/Introduction

When attempting to start JWP on a new or upgraded system, the JWP fails and the following errors are seen in the log:

20201102/152702.989 - 1      U00045028 Only DSN less connect strings are supported in if MS-SQL is used as database.
20201102/152702.989 - 1      U00003611 DB OPEN executed. Return Code = '500'
20201102/152702.989 - 1      U00032031 Error when connecting to Database
20201102/152703.020 - 52     U00045025 OSGI ['com.automic.ert']: 'FrameworkEvent ERROR'
20201102/152703.020 - 52               Unhandled Exception in thread Framework Event Dispatcher: Equinox Container: b5d549b2-1018-44b7-8ae0-f108703329f4
20201102/152703.020 - 52     U00045014 Exception 'java.lang.IllegalStateException: "The service has been unregistered"' at 'org.eclipse.osgi.internal.serviceregistry.ServiceRegistrationImpl.getReferenceImpl():285'.
20201102/152703.020 - 52     U00003620 Routine 'com.automic.kernel.impl.DefaultExceptionHandler' forces trace because of error.

Environment

Version: 12.3

Database: SQL Server

Cause

This is caused by no JDBC connection set up in the ucsrv.ini file

Resolution

Setup the JDBC connection to the database as per the documentation:

Installing the JWP

 

JDBC Connection to the database:

Define a separate database connection string for the JWP in the [JDBC] section. You can automatically generate this string by using the following command:

java -jar ucsrvjp.jar -setup

The system then verifies that the JDBC driver is available and that the database connection could be established.

The advantage here is that the connection string of the other WPs ([ODBC] section) does not need to be changed or restarted.