Error Message :
The following SQL query:
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.
OS Version: N/a
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: