AWA: Orphaned records in the ESTP table: Leftovers after Job deactivation

Products

• CA Automic Workload Automation - Automation Engine
• CA Automic One Automation
• CA Automic Operations Manager
• CA Automic Oracle

Issue/Introduction

Orphaned records in the ESTP table i.e., row in the EH table for the Job is already deleted, but a record in the ESTP table is left back.

The following kind of errors may appear on the WP logs until the ESTP table is cleaned:

20200929/112157.774 -  U00003631 Dump caused by: 
20200929/112157.774 -  U00000002 EXISTS
20200929/112157.774 -  U00011801 Error in Server routine 'JPEXEC_R', Server: 'EUP4#WP008' AE system: 'EUP4'.

 

To check if the issue is occurring, the following query is useful:

select * from ESTP where estp_AH_idnr not in (select eh.EH_AH_Idnr from EH);

Cause

A problem has been fixed where some orphaned records were left in the ESTP table.

By deactivating a job, the Automation Engine did not delete the record of the job from the ESTP Table. This happened sporadically, depending on the order of messages processed by the Automation Engine.

Environment

Release : 12.1, 12.2 and 12.3

Component : AUTOMATION ENGINE

Resolution

First, you will need to remove the orphan records from ESTP that appear with the result of the query:

select * from ESTP where estp_AH_idnr not in (select eh.EH_AH_Idnr from eh);

 

Then, update to a fix version listed below or a newer version if available so that the issue will not reoccur in the future.

Fix version:

Component(s): Automation.Engine

Automation Engine 12.3.2 - available 

Automation Engine 12.2.6 - available 

Automation Engine 12.1.8 - available