ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

Multiple statistic calculation calls executed during Oracle ILM


Article ID: 84743


Updated On:


CA Automic Workload Automation - Automation Engine


Error Message :
U00003525 UCUDB: ===> 'begin uc_calc_stat (); end;'

During an Oracle ILM (Information Lifecycle Management) switch, multiple statistic calculations are called by different WPs and for the entire schema.  These calls can cause delays in the completion of the ILM switch.


You may be encountering this issue if:
  1. The Automation Engine (AE) is using an Oracle database.
  2. During an Oracle ILM switch, delays are experienced.
  3. In multiple WP logs the following message is seen:​
U00003525 UCUDB: ===> 'begin uc_calc_stat (); end;'



Cause type:
Root Cause: Schema statistics should only be calculated for the partitioned tables and once per day


Release: AUTWAB99000-11.0-Automic Workload Automation-Base Edition


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


Fix Status: Released

Fix Version(s):
Component(s): AE Server and Initialdata

Automation Engine 12.1.0 - Available
Automation Engine 12.0.3 - Available
Automation Engine 11.2.7 - Available

Additional Information

Workaround :

If this issue is significantly impacting your system during an ILM switch and you are unable to upgrade to a fixed version, please contact Automic Support for assistance.