SQL query intend to update table AH_ParentHir removed

Document ID : KB000084322
Last Modified Date : 14/04/2018
Show Technical Document Details
Issue:
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.
 
Environment:
OS Version: N/a
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.
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