Error Message :
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.
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.
OS Version: N/A
Update to a fix version listed below or a newer version if available.
Fix Status: Fixed
Component(s) : AE Server & Initial data
Automation Engine 12.2.0 - Available
Automation Engine 12.1.1 - Available
Automation Engine 12.0.5 - Available
Ensure to space out the DB loads in order to lower the load on the server processes.