General slow perfromance and rows in MQ1PWP table increasing

Document ID : KB000085012
Last Modified Date : 14/04/2018
Show Technical Document Details
Issue:
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.
Environment:
OS Version: N/A
Cause:
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.
Resolution:
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.