DB_SERVICE agent won't start after upgrading to 21 NullPointerException


Article ID: 241995


Updated On:


CA Automic Workload Automation - Automation Engine CA Automic One Automation


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

20220429/113707.534 - U02000153 The JVM Option HeapDumpOnOutOfMemoryError is enabled.
20220429/113707.831 - U02000072 Connection to system 'AUTOMIC' initiated.
 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)


Release : 21.0.2



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 from client 0's administration perspective in the Agents section.