Error CAUAJM_E_18402 ORA-24347: Warning of a NULL column

Article Id: 36547
Status: Published
Updated On: 14-02-2018 07:37
Legacy Id: TEC1040484
Products:
CA Workload Automation AE - Business Agents (AutoSys) , CA Workload Automation AE - Scheduler (AutoSys) , CA Workload Automation Agent
Issue/Introduction:

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                                                               

                                                                                                                       

Environment:

Release: ATSYHA99000-11.3.6-Workload Automation AE-High Availability Option
Component: