Aggregator statistics not generated after 11.3.6 SP3 upgrade

Document created by JeanPaulLucas Employee on Jan 18, 2016
Version 1Show Document
  • View in full screen mode

Following errors are noticed in the Scheduler log when it was attempting to generate the aggregator statistics after an upgrade to CA WAAE 11.3.6 SP3   

                               

CAUAJM_E_18402 ORA-24347: Warning of a NULL column in an aggregate function

CAUAJM_E_40303 Failed to complete aggregation of product statistics.      

 

This problem will be fixed in upcoming CA WAAE 11.3.6 SP4

 

To get it fixed in CA WAAE 11.3.6 SP3, you can run the below SQL queries

 

Run below SQL 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;   

 

Attachments

    Outcomes