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.

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

book

Article ID: 88692

calendar_today

Updated On:

Products

CA Automic Applications Manager (AM)

Issue/Introduction

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

Environment

Release: AAMOS499000-8.0-Automic Applications Manager-OS400 Agent
Component:

Resolution

Detailed Description and Symptoms

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


Solution

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.