DB_SERVICE agent won't start after upgrading to 21.x
search cancel

DB_SERVICE agent won't start after upgrading to 21.x

book

Article ID: 241995

calendar_today

Updated On:

Products

CA Automic Workload Automation - Automation Engine CA Automic One Automation

Issue/Introduction

After upgrading to version 21.0, the DB_SERVICE agent is not starting.  This agent worked previously.  Older 21.0 log files will show something like:

20220429/113707.534 - U02000153 The JVM Option HeapDumpOnOutOfMemoryError is enabled.
20220429/113707.831 - U02000072 Connection to system 'AUTOMIC' initiated.
java.lang.NullPointerException
 at com.uc4.ex.cp.CPConnection.openConnection(CPConnection.java:139)
 at com.uc4.ex.cp.CPConnection.<init>(CPConnection.java:132)
 at com.uc4.ex.cp.CPConnection.getValidCPConn(CPConnection.java:455)
 at com.uc4.ex.cp.CPConnection.loadCPConnection(CPConnection.java:533)
 at com.uc4.ex.cp.CPConnection.getConnection(CPConnection.java:614)
 at com.uc4.ex.cp.ServerConnectionFactory.newConnection(ServerConnectionFactory.java:28)
 at com.uc4.ex.ExecutorLifecycle.createServerConnection(ExecutorLifecycle.java:361)
 at com.uc4.ex.ExecutorLifecycle.execute(ExecutorLifecycle.java:122)
 at com.uc4.ex.sql.UCXJSQLX.main(UCXJSQLX.java:53)

Newer released of 21.0 will show something like:

20230705/151222.073 - U02000153 The JVM Option HeapDumpOnOutOfMemoryError is enabled.
20230705/151222.292 - U02000345 Unable to connect to AutomationEngine. Connection parameter missing in configuration file.
20230705/151222.292 - U02000074 Connecting to system 'AUTOMIC' is not possible.
20230705/151222.292 - com.uc4.ex.cp.InitialConnectionException: Initial connection with endpoint not possible. Please check your configuration.

The log files will show up with a name like: $$srv_log___00.txt

Within the first few lines of the log file, a message like the following showing that the ucsrv.ini file is being used will show up:

U02000037 Started Agent with INI file '/opt/Automic/ServiceManager/bin/../../AutomationEngine/bin/ucsrv.ini'.

Environment

Release : 21.0.2

Component : AUTOMATION ENGINE

Cause

12.3 used ucsrv.ini for the db service ini file and had a uc4.smd start command like:

DEFINE DATABASE-SERVICE01;java -jar -Xmx256M *OWN/../../Agents/sql_service/bin/ucxjsqlx.
jar -service -i*OWN/../../AutomationEngine/bin/ucsrv.ini;*OWN/../../Agents/sql/bin/

Version 21.0 no longer uses ucsrv.ini.

Resolution

The DB_SERVICE agent in version 21.0 does not use the ucsrv.ini file anymore.  The best course to move forward:

  1. Make sure that the DB_SERVICE agent is installed into it's own directory
  2. If you have to use an older version, you will need to make sure that agent has its own ini file in its bin directory.
  3. Update the ini file to have the name of the DB Service agent, the cp= to point to the correct cp, and the correct system= name
  4. Update the db service agent's start command in the service manager dialog to include:
    -i[full path to agent's bin directory]\ucxjsqlx.ini

The start command should look something like:

java -Xrs -Xmx1G -jar C:\automic\21.0.2\Agents\db_service\bin\ucxjsqlx.jar -service

This should allow the agent to start.  You may need to Renew the Transfer key (or Public Key) from client 0's administration perspective in the Agents section.

uc4.smd may need to be updated to something like:

DEFINE DATABASE-SERVICE01;java -Xmx1G -jar *OWN/../../Agents/sql_service/bin/ucxjsqlx.jar -service;*OWN/../../Agents/sql_service/bin/

After a restart of the service manager, it should start fine

Powered by Wolken Software