General slow perfromance and rows in MQ1PWP table increasing
search cancel

General slow perfromance and rows in MQ1PWP table increasing


Article ID: 85012


Updated On:


CA Automic Workload Automation - Automation Engine


Error Message :

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.


OS Version: N/A


Cause type:
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.


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

Additional Information

Workaround :
For a workaround, please contact Automic Support and refer to this article.