U00011021 Host 'DB Service Agent' is not active!

[Mohit__9840]

Hello Sir/Madam,

I have installed DB Agent in linux for MySql as per the instructions given in the link 

https://docs.automic.com/documentation/webhelp/english/AWA/12.1/DOCU/12.1/AWA%20Guides/help.htm#Installation_Manual/InstallAgents/InstallAgentDatabase_JobsEvents.htm%3FTocPath%3DInstallation%2520Guide%7CNew%2520Installation%7CInstallation%2520Types%7CManual%2520Installation%7CInstalling%2520the%2520Agents%7CInstalling%2520the%2520Agent%2520for%2520Databases%7C_____1

and started the DB Agent with the command 
java -jar -Xrs -Xmx256M ucxjsqlx.jar 

The agent is visible in the AWI at Administration -> Agents 

I have created the SQL connection in the AWI and given the details like Database Type , Server:Port ,Database Name and Login Details. When we test the connection using Test button.I got the error as

U00011021 Host 'DB Service Agent' is not active!

Please let me know if I am missing anything as per the configuration of DB Agent.

Thanks & Regards
    Mohit

[Michael Pirson]

The DB Service Agent is the one for variables and not for jobs:

https://docs.automic.com/documentation/webhelp/english/AWA/12.1/DOCU/12.1/AWA%20Guides/help.htm#Installation_Manual/InstallAgents/InstallAgentDatabase_Variables.htm

[Legacy User]

The DB service agent is also responsible for the connection objects of type SQL.

Here's an example on how to start the DB Service Agent:

Command:

java -jar /opt/automic/v11/agents/vwaf1lnx01_db_service/bin/ucxjsqlx.jar -i/opt/automic/v11/automationengine/bin/ucsrv.ini -service

[Kailash Reddy Sowreddy]

We have tried to start dbagent by using above jar command. But still getting same error.Can anyone help ASAP.

[LuuLe]

We have tried to start dbagent by using above jar command. But still getting same error.Can anyone help ASAP.

So is both the DB Agent & DB Services Agent  running/active in your "Administrative" perspective --> "Agents & group" view? If there only one, can you confirm that it is really the DB Services Agent and not the DB Agent... Can you show us a screenshot of the active Agents?

 

The error message "U00011021 Host 'DB Service Agent' is not active!" Normally mean that the DB Services agent is not running...  (please note that DB Agent (for MySQL, MSSQL, Oracle etc...) is a little different then a DB Services Agent). Also for the DB Services Agent - it also need to be configured in the AutomationEngine's INI file

[Mohit__9840]

Thanks for the valuable inputs.