search cancel

When updating from version 8 to a higher version, inactive Agents are not shown in the System Overview.


Article ID: 88178


Updated On:


CA Automic Workload Automation - Automation Engine


Error Message :

When upgrading from version 8 some of the Agents are not visible within the System Overview.
In the past we updated the OH_isTemplate with 0 for all OH’s where oh_otype = ‘HOST’.  During the upgrade the new field is added to OH with a default value of <NULL>.  This value is changed by the system as soon as an Agent connects to the System.  All Agents that have not connected to the system since the start (after the upgrade) are not visible within the System Overview.  This is due to the query that delivers the objects to display within the System Overview is using a 0 and not <NULL>.



Cause type:
Root Cause: This is because the new column OH_IsTemplate is initially set to NULL but is expected to be 0 or 1.


Release: AUTWAB99000-11.0-Automic Workload Automation-Base Edition


This field was added on 30/03/2017. This article has not been updated yet. Refer to the "Description" or "Workaround" sections for solution information.

Fix Status: Released

Fix Version(s):
Automation Engine 11.2.1 - already available
Automation Engine 11.1.3 - already available
Automation Engine 10.0.7 - already available

Additional Information

Workaround :
Get a SQL update statement from Automic Support.