Displaying Users on Client 0 takes too long because AE requests only 50 elements in the select bulk statement
Article ID: 281934
Updated On:
Products
Issue/Introduction
On environments with a huge amount of Users defined, like 120K Users, every time you connect to the Client 0 - Administration the User list is loaded and this operation takes almost 2 minutes.
When executing directly the request in the database for obtaining the 120K users, this can be done in sqlplus in only 1 second.
Environment
Automation Engine 21.x, 24.x
Cause
The reason why it takes so long to display the list in AWI is because the AE processes perform a select bulk query requesting only 50 elements to be fetched at a time, so this whole operation repeats 2400 times so in the end this takes 2 minutes.
Resolution
Update to a fix version listed below or a newer version if available.
Fix version:
Component(s): Automation Engine
Will be fixed in Automation.Engine 21.0.11 - Planned release end July 2024
Will be fixed in Automation.Engine 24.1.0 - Planned release end June 2024
Additional Information
Defect ID: AE-36117
Public Short Description: System variable UC_SYSTEM_SETTINGS is extended with BULK_FETCH_SIZE parameter.
Public Description: A problem has been fixed where the system variable UC_SYSTEM_SETTINGS was extended with BULK_FETCH_SIZE parameter. Allowed values are 50 - 9999. Default value is 500.
This will be documented in the Reference section of the documentation (24.1.0 and 21.0.11) and also in the What's New topic for 21.0.11.
Feedback
