ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

Executing task ends with U00054518 Task ... will be restarted as soon as a Database Service Agent is active again or the previous error has been corrected.

book

Article ID: 194963

calendar_today

Updated On:

Products

CA Automic Workload Automation - Automation Engine CA Automic Workload Automation - Automation Engine CA Automic One Automation

Issue/Introduction

When attempting to run a task that references a sql variable or preview a SQL VARA object, the error message "Task with RunID '0087432160' will be restarted as soon as a Database Service Agent is active again or the previous error has been corrected" is returned.
 
The DB Service Agent appears to be available for the client and SQL jobs are able to run for the same host, connection object (and login).

The MSSQL agent is up and running on the automation engine application server and are able to execute SQL Jobs.
 

Environment

Release : 12.3

Component : AUTOMATION ENGINE

Resolution

Start agent parameter was missing '-service' in Service Manager Dialog. Without this parameter, the "DB-Service" agent is just another SQL agent.
Once the agent has been created, it needs to be deleted and recreated.