Symptoms:
Following errors are noticed in the Scheduler log when it was attempting to generate the aggregator statistics:
CAUAJM_E_18402 ORA-24347: Warning of a NULL column in an aggregate function
CAUAJM_E_40303 Failed to complete aggregation of product statistics.
Environment:
Scheduler failed to generate aggregator statistics after upgrading CA WAAE to 11.3.6 SP3 ( Any Platform )
Cause:
New columns are added to aggregator tables (ujo_rep_hourly, ujo_rep_daily,
ujo_rep_weekly, ujo_monthly) to include new job states: suspended and resume.
Existing records would have NULL for these newly added comumns and so
database aggregator function like SUM or average fail on NULL values.
Workaround:
Run below QL queries as aedbadmin(oracle) or sa user for Sybase/MS-SQL:
update ujo_rep_daily set ac_resumefail_n=0 where ac_resumefail_n is NULL;
update ujo_rep_daily set ac_suspendfail_n=0 where ac_suspendfail_n is NULL;
update ujo_rep_daily set js_suspend_n=0 where js_suspend_n is NULL;
update ujo_rep_daily set js_suspend_p=0 where js_suspend_p is NULL;
update ujo_rep_hourly set ac_resumefail_n=0 where ac_resumefail_n is NULL;
update ujo_rep_hourly set ac_suspendfail_n=0 where ac_suspendfail_n is NULL;
update ujo_rep_hourly set js_suspend_n=0 where js_suspend_n is NULL;
update ujo_rep_hourly set js_suspend_p=0 where js_suspend_p is NULL;
update ujo_rep_weekly set ac_resumefail_n=0 where ac_resumefail_n is NULL;
update ujo_rep_weekly set ac_suspendfail_n=0 where ac_suspendfail_n is NULL;
update ujo_rep_weekly set js_suspend_n=0 where js_suspend_n is NULL;
update ujo_rep_weekly set js_suspend_p=0 where js_suspend_p is NULL;
update ujo_rep_monthly set ac_resumefail_n=0 where ac_resumefail_n is NULL;
update ujo_rep_monthly set ac_suspendfail_n=0 where ac_suspendfail_n is NULL;
update ujo_rep_monthly set js_suspend_n=0 where js_suspend_n is NULL;
update ujo_rep_monthly set js_suspend_p=0 where js_suspend_p is NULL;
commit;
Additional Information:
This problem will be fixed in upcoming 11.3.6 SP4