Error Message :
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.
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.
OS Version: N/a
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.
Update to a fix version listed below or a newer version if available.
Fix Status: Released
Component(s): AE Server and Initialdata
Automation Engine 12.1.0 HF4 - Available
Create the following manual index: