SQL query intend to update table AH_ParentHir removed

book

Article ID: 84322

calendar_today

Updated On:

Products

CA Automic Workload Automation - Automation Engine AUTOMIC WORKLOAD AUTOMATION

Issue/Introduction

Error Message :
N/A

The following SQL query:
 
SELECT COUNT(*) FROM AH WHERE AH_ParentHir = ?. 
 
was removed which was intended to update the table AH_ParentHir.

The removal of this query causes the system to do a full table scan on the database causing poor performance in environments that have many statistic records in the table EH.
 
Note:
This issue can appear in all previously released versions of AE 12.1.0 HF4.  

Especially 
in 
very large environments where there are millions of entries in the AH table. Since this query was superfluous and had no effect, besides degrading the system performance, it has been removed.
 

Cause

Cause type:
Defect
Root Cause: This SQL query is executed when restarting an already deactivated job: SELECT COUNT(*) FROM AH WHERE AH_ParentHir = ?. In very large environments where there are millions of entries in the table AH table, this query causes performance issues.

Environment

OS Version: N/a

Resolution

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

Fix Status: Released

Fix Version(s):
Component(s): AE Server and Initialdata

Automation Engine 12.1.0 HF4 - Available

Additional Information

Workaround :
Create the following manual index:

AH_ParentHir