Execution of workflows with RA jobs as task leaves orphan entries in EV table

Products

• CA Automic One Automation

Issue/Introduction

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);

Environment

Release : 12.3

Component : AUTOMATION ENGINE

Resolution

Workaround:

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;

Solution:

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