U00011021 Host 'DB Service Agent' is not active!

Products

• CA Automic Workload Automation - Automation Engine

Issue/Introduction

A Database Connector object (SQL CONN) has been created. When the validity of the referenced database is checked though the button 'Test Connection', the test aborts and returns the error message: 

U00011021 Host 'DB Service Agent' is not active!

 

Cause

The Database Service is not started on the is One Automation System.

 

Environment

Release:
Component: AAUTEN

Resolution

The solution is to start the Database Service over the Service Manager Dialog.

The Database Service must be started with this kind of command : 

java -jar -Xmx256M <path to SQL agent>\bin\ucxjsqlx.jar -service -i<path to SQL agent>\bin\ucsrv.ini

If a similar Service is not created already in the Service Manager Dialog it must be added.