[EM 13c]: AWR Warehouse Repository Database Alert Log File Shows "ORA-12012: error on auto execute of job "SYS"."MGMT_CAW_LOAD"

(Doc ID 2346725.1)

Last updated on JANUARY 23, 2018

Applies to:

Enterprise Manager for Oracle Database - Version 13.2.2.0.0 and later
Information in this document applies to any platform.

Symptoms

AWR Warehouse retention set to 1 year not purging the older snapshot.

Following errors are shown continuously in AWR warehouse database alert log file:
======================
Wed Dec 20 07:30:55 2017
Errors in file /eiawrdwpoma1/oracle/diag/rdbms/eiawrp1/eiawrp1/trace/eiawrp1_j002_31866.trc:
ORA-12012: error on auto execute of job "SYS"."MGMT_CAW_LOAD$82868"
ORA-00904: "ACTUAL_DELTA": invalid identifier
ORA-06512: at "DBSNMP.MGMT_CAW_LOAD", line 1874
ORA-06512: at "DBSNMP.MGMT_CAW_LOAD", line 2440
ORA-06512: at line 1

Trace file /eiawrdwpoma1/oracle/diag/rdbms/eiawrp1/eiawrp1/trace/eiawrp1_j002_31866.trc
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
ORACLE_HOME = /eiawrdwpoma1/oracle/product/12.1.0.2
System name: Linux
Node name: hostname
Release: 2.6.32-696.6.3.el6.x86_64
Version: #1 SMP Fri Jun 30 13:24:18 EDT 2017
Machine: x86_64
Instance name: eiawrp1
Redo thread mounted by this instance: 1
Oracle process number: 64
Unix process pid: 31866, image: oracle@hostname (J002)

*** 2017-12-20 07:30:55.316
*** SESSION ID:(325.23813) 2017-12-20 07:30:55.316
*** CLIENT ID:() 2017-12-20 07:30:55.316
*** SERVICE NAME:(SYS$USERS) 2017-12-20 07:30:55.316
*** MODULE NAME:(DBMS_SCHEDULER) 2017-12-20 07:30:55.316
*** CLIENT DRIVER:() 2017-12-20 07:30:55.316
*** ACTION NAME:(MGMT_CAW_LOAD$82868) 2017-12-20 07:30:55.316

ORA-12012: error on auto execute of job "SYS"."MGMT_CAW_LOAD$82868"
ORA-00904: "ACTUAL_DELTA": invalid identifier
ORA-06512: at "DBSNMP.MGMT_CAW_LOAD", line 1874
ORA-06512: at "DBSNMP.MGMT_CAW_LOAD", line 2440
ORA-06512: at line 1
======================

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms