AW_CALC_HISTORY_STATISTICS job aborts and receive ORA-06502: PL/SQL: numeric or value error: number

Products

• CA Automic Applications Manager (AM)

Issue/Introduction

The AW_CALC_HISTORY_STATISTICS job is aborting or just running indefinitely forcing you to kill the job. In the jobs output file located in the remote agent's $AW_HOME/out directory you notice the following error:

ORA-06502: PL/SQL: numeric or value error: number precision too large

Environment

CA Automic Applications Manager

Resolution

Please log into sqlplus as the Oracle Applications Manager user and run the following sql:

select SO_JOBID, SO_MODULE, SO_START_DATE, SO_JOB_STARTED, SO_JOB_FINISHED, SO_STATUS from  so_job_history where  SO_JOB_STARTED < sysdate -65;

You can adjust the sysdate portion appropriately, but what we are looking for are jobs that have a SO_JOB_STARTED date set to before the SO_START_DATE.
This is often an extreme difference and dates seem to most commonly show up as in 1970. If you have jobs with these mismatched dates please contact support.