GUI unresponsive when performing several DB loads in succession

Document ID : KB000084643
Last Modified Date : 14/04/2018
Show Technical Document Details
Issue:
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.
Environment:
OS Version: N/A
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.
Resolution:
Update to a fix version listed below or a newer version if available.

Fix Status: In Progress

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

Automation Engine 12.2.0 - Planned release date: 2018-06-19
Automation Engine 12.1.1 - Available
Automation Engine 12.0.5 - Planned release date: 2018-05-07
Additional Information:
Workaround :
Ensure to space out the DB loads in order to lower the load on the server processes.