When executing workflows containing RA jobs as tasks, entries in the EV table are not removed during deactivation and remain in the database forever.
This can be detected by the following query:
select * from EV where ev_AH_idnr not in (select eh.EH_AH_Idnr from eh);
Release : 12.3
Component : AUTOMATION ENGINE
You would need to delete these orphan records from the tables manually with the regular safety measures:
1. Backup the impacted table EV
2. Run the delete statement (example for Oracle):
delete from EV where ev_AH_idnr not in (select eh.EH_AH_Idnr from eh);
commit;
Update to a fix version listed below or a newer version if available.
Fix version:
Component(s): Automation.Engine
Automation.Engine 12.2.9 - Available
Automation.Engine 12.3.6 - Available