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

Products

• CA Automic Workload Automation - Automation Engine

Issue/Introduction

Error Message :
N/A

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>.
 

Environment

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

Cause

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

Resolution

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.