Slow performance opening workflows with many PromptSets in AWI v24 or v26

Products

• CA Automic Workload Automation - Automation Engine

Issue/Introduction

Workflows containing a large number of PromptSet (PRPT) objects may experience significant delays when being opened in the Automic Web Interface (AWI) v24.

Users report load times exceeding 30-40 seconds for complex workflows.

Symptoms

• Opening a Workflow (JOBP) in the editor or monitor takes an excessive amount of time.
• Database traces show a high volume of SP_CURSOR operations.
• Workload Process (WP) logs may indicate long-running getobject routines.

Environment

• Automation Engine v24.x or v26
• Automic Web Interface v24.x or v26
• Database: Microsoft SQL Server

Cause

DE202235: The Automation Engine was incorrectly using the DB_OPC_SELECT_BULK opcode when reading PromptSet (PRPT) objects. Because these objects contain CLOB data, MS SQL Server is forced to use a scrollable cursor, which creates significant performance overhead during the fetch process.

Resolution

This issue is addressed by a change on the Automation Engine by changing the database access logic to use DB_OPC_SELECT_ONE.

Fix Status:

• Targeted to be fixed in: Automation Engine 24.4.5
• Targeted to be fixed in: Automation Engine 26.1.0

Please subscribe to this article to receive updates regarding the official release availability.

Once the fix version is officially released (Post-GA), it will be available for download. Consult Automic Downloads for steps to download the latest release.

Additional Information

Public Title: Poor Performance when Loading Workflows into AWI

Public Description: A problem has been fixed that prevents AWI to load and display workflows in a efficient way.  

If further assistance is required, please see Contact Support to reach a representative for your region.