General slow perfromance and rows in MQ1PWP table increasing
Article ID: 85012
CA Automic Workload Automation - Automation Engine
Error Message : N/A
Performance issues can be experienced and the MQ1PWP table increases.
This issue can have following symptoms:
The system has an overall bad performance.
It might be impossible to log in to the GUI/AWI
Jobs stay in stati like generating or activating for very long
Check if the MQ-Table of the PWP has a high number of records. There are always 2 MQ-sets, and only one is always active. I.e. both have to be checked:
select count(*) from MQ1PWP; select count(*) from MQ2PWP;
Normally, one will be empty. The other one should only have few entries (hundreds). If the number is very high (thousands) and not decreasing (or only slightly), it might be this problem.
Cause type: Defect Root Cause: Performance issues when a large number of tasks with delayed deactivation exist. Deactivation is checked over and over, even the tasks cannot be deactivated. Change made to check only once and decouple from the PWP.
OS Version: N/A
Update to a fix version listed below or a newer version if available.
Fix Status: Released
Fix Version(s): Automation Engine 12.1.0 - Available Automation Engine 12.0.1 - Available Automation Engine 11.2.4 - Available
Workaround : For a workaround, please contact Automic Support and refer to this article.