My Oracle Support Banner

[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 FEBRUARY 20, 2019

Applies to:

Enterprise Manager for Oracle Database - Version 13.1.0.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 <PATH>/trace/1_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 <PATH>/diag/rdbms/trace/1_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 = <PATH>/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: <INSTANCE_NAME>
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

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.