Entries in XAO Table for non-existent clients

Products

• CA Automic Workload Automation - Automation Engine

Issue/Introduction

Investigating our revision reporting process we encountered strange issue. 

In the XAO tables we can find entries marked for a client which does not exist (XAO_Client). The issue seems to be present since many versions we have entries ranging from 2009 to 2023. 

It mostly seems to be for HOST and  USER XAO_OType. 

We ran for example:

select  count(*)
from XAO
WHERE XAO_Client NOT IN (SELECT DISTINCT OH_Client FROM OH)

This returned around 4000. 

 

Where do those entries come from? How to get rid of them? 

Environment

Release : 12.3.4 - 21.0.9

Cause

If you try to log on to a non-existing client, an XAO record is written for that client. But since the non-existing client is not reorganized this orphan record persists.

Resolution

Solution:

Update to a fix version listed below or a newer version if available.

Fix version:

Component(s): Automation Engine

Automation.Engine 21.0.10 - Planned release May 2024

Additional Information

This corresponds to the following fix: AE-31018