Unix agent does not start and remains inactive in AWI

Products

CA Automic Workload Automation - Automation Engine

Issue/Introduction

The Unix agent cannot be started and remains inactive in the AWI.

The log file ends with these lines:

20210128/215112.734 - U02000134 Thread 'AGENT/CCM' started.
20210128/215112.735 - U02003056 Start of agent process 'LISTENER' with PID='216740' has been initiated.
20210128/215112.739 - U02003057 Agent process 'LISTENER' with PID='216740' is up and running.
20210128/215112.739 - U02000134 Thread 'LISTENER/CCM' started.
20210128/215112.739 - U02000146 Allowed address '' for non-secured connections has been added.
20210128/215112.739 - U02000072 Connection to system 'AUTOMIC' initiated.
20210128/215112.743 - U02000011 Connection to Server 'fqdn:2222' initiated.
20210128/215112.744 - U02000348 Connection to 'fqdn:2222(ID=3)' initiated.
20210128/215112.746 - U02002036 Could not receive anything from partner '*ID3'. Error code '111(Connection refused),S(10(ID=3))'.
20210128/215112.746 - U02000010 Connection to Server '*ID3(s=10,ID=3)' terminated.
20210128/215112.746 - U02000011 Connection to Server 'fqdn:2219' initiated.
20210128/215112.747 - U02000348 Connection to 'fqdn:2219(ID=4)' initiated.
20210128/215112.748 - U02002036 Could not receive anything from partner '*ID4'. Error code '111(Connection refused),S(10(ID=4))'.
20210128/215112.748 - U02000010 Connection to Server '*ID4(s=10,ID=4)' terminated.
20210128/215112.748 - U02000011 Connection to Server 'fqdn:2218' initiated.
20210128/215112.748 - U02000348 Connection to 'fqdn:2218(ID=5)' initiated.
20210128/215112.753 - U02000004 Connection to Server 'AUTOMIC#CP002(ID=5)' successfully created.

Environment

Release : 12.3

Component : AUTOMATION ENGINE

Cause

Data integrity.

Resolution

If an Automic Agent is improperly shutdown we don't clear out the agent's record in the dbo.MQSRV table.
Until this is cleared out (or the Agent's name changed) you will not be able to start the Agent.

Delete the entry as follows (please have a DBA check this statement before running and always use caution when running delete statements):

SQL Server:
delete from mqsrv where mqsrv_name='AGENT_NAME'

Oracle:
delete from mqsrv where mqsrv_name='AGENT_NAME';
commit;

Additional Information

Once the delete statement is performed and the agent started again, the connection to the AE will be successful.

20210128/215112.753 - U02000004 Connection to Server 'AUTOMIC#CP002(ID=5)' successfully created.
20210128/215112.754 - U02000354 CP Server 'AUTOMIC#CP002' reports ranking '1'.
20210128/215112.754 - U02000073 Connection to system 'AUTOMIC' via CP Server '' successfully established.
20210128/215112.760 - U02000066 Host information: Host name='fqdn', IP address='[fe80::f816:3eff:fe50:79f0]'
20210128/215112.761 - U02000066 Host information: Host name='fqdn', IP address='ip'
20210128/215112.761 - U02000066 Host information: Host name='fqdn', IP address='ip'
20210128/215112.866 - U02000017 The check interval for 'Jobs' has been set to '60' seconds.
20210128/215112.867 - U02000017 The check interval for 'Server' has been set to '660' seconds.
20210128/215112.867 - U02000017 The check interval for 'Reconnect' has been set to '600' seconds.
20210128/215112.867 - U02000017 The check interval for 'Report' has been set to '60' seconds.
20210128/215112.867 - U02000017 The check interval for 'File Event' has been set to '60' seconds.
20210128/215112.867 - U02000017 The check interval for 'File Transfer Restart Point' has been set to '60' seconds.
20210128/215112.867 - U02000017 The check interval for 'File Transfer Statistic' has been set to '60' seconds.
20210128/215112.867 - U02000017 The check interval for 'File Transfer Report' has been set to '60' seconds.
20210128/215112.867 - U02000017 The check interval for 'unused FT connection' has been set to '300' seconds.
20210128/215112.867 - U02000017 The check interval for 'backend command' has been set to '600' seconds.
20210128/215815.817 - U02000005 Job 'JOBS.UNIX.32506466' with RunID '1705160' started.