GUI unresponsive when performing several DB loads in succession

book

Article ID: 84643

calendar_today

Updated On:

Products

CA Automic Workload Automation - Automation Engine

Issue/Introduction

Error Message :
N/A

When performing several DB Loads in a row the User Interface / AWI becomes unresponsive.

Here is what happens in the background :

1 - The PWP looks in the ITL (internal task list table), then triggers the WPs with gen-ox via the db tables.

2 - DB Load writes an ITL - re - us - ca (refresh user cache) message at the end of the process : the cache for the FOLDERTREE (OFS) is invalidated at this point.

3 - Every WP sends a kick-ofs "please get a new tree, the old is no longer valid" for every registered user. So the number of OFS messages = number of WPs x number of connected users.

The issue is particularly visible in systems with many WPs and users.

Cause

Cause type:
Defect
Root Cause: For every transport case every WP triggers a folder-cache refresh for all users. This normally has to be done by the primary work process only.

Environment

OS Version: N/A

Resolution

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

Fix Status: Fixed

Fix Version(s):
Component(s) : AE Server & Initial data

Automation Engine 12.2.0 - Available
Automation Engine 12.1.1 - Available
Automation Engine 12.0.5 - Available

Additional Information

Workaround :
Ensure to space out the DB loads in order to lower the load on the server processes.