General slow perfromance and rows in MQ1PWP table increasing

Products

• CA Automic Workload Automation - Automation Engine

Issue/Introduction

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.