Performance issues when loading workflows

Products

• CA Automic Workload Automation - Automation Engine
• CA Automic One Automation

Issue/Introduction

There's a performance issue when accessing the "Open Monitor" of the workflow which contains several sub-workflows.

Some of the messages in the WP logs may show a long running getobject routine or long running sql statements like the following:

Select * from JPP,OPU where jpp_oh_idnr = opu_oh_idnr and OPU_OH_Idnr = ? order by JPP_Lnr, OPU_Order asc

select * from (select 'PRPT' DIVDB_String, OPSE_Name,'' OPUD_PName, OPSE_Value, OPSEA_OPSE_Name, OPSEA_Lnr, OPSEA_Value, OPSE_AltView, OPSE_HasList, OPSE_XUI_TYPE from OPSE  left join OPSEA on OPSEA_OH_Idnr = OPSE_OH_Idnr and OPSEA_OPSE_Name = OPSE_Name where OPSE_OH_Idnr = ? union all Select 'JOBS', OPUD_VName,OPUD_PName, OPUD_Value, OPUDA_OPUD_VName, OPUDA_Lnr, OPUDA_Value, OPUD_AltView, OPUD_HasList, '' from OPUD  left join OPUDA on OPUDA_OH_Idnr = OPUD_OH_Idnr and OPUDA_OPUD_VName = OPUD_VName and OPUDA_OPU_Lnr = OPUD_OPU_Lnr  where OPUD_OH_Idnr = ? and OPUD_PName = ? ) x order by OPSE_Name , DIVDB_String asc

Environment

Product: CA Automic Workload Automation - Automation Engine v21.x

Cause

DE166272

Resolution

Update to a fix version listed below or a newer version if available.

Fix version:
Component(s): Automation.Engine
Automation.Engine 21.0.14 - Available
Automation.Engine 24.4.1 - Planned release July 2025

 

Downloaded from link:

https://downloads.automic.com/downloads/quick_start/aa/21.0.14

 

 

 

 

Additional Information

Performance issues when loading workflows (DE166272):
The logic identifying prompt sets used by workflow tasks was incorrect resulting in a potentially huge number of DB queries degrading the performance.