Error Message :
Performance issues can be experienced and the MQ1PWP table increases.
This issue can have following symptoms:
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:
- 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
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
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
Automation Engine 12.1.0 - Available
Automation Engine 12.0.1 - Available
Automation Engine 11.2.4 - Available
For a workaround, please contact Automic Support and refer to this article.