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?
Release : 12.3.4 - 21.0.9
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.
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
This corresponds to the following fix: AE-31018