EM 12c, EM 13c: AWR-Warehouse Unable To Upload The Snapshot

(Doc ID 2295579.1)

Last updated on AUGUST 15, 2017

Applies to:

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

Symptoms

EM 12c and 13c. AWRWare house DB version is 11.2.0.4

On AWR Warehouse page, for all the Source databases, newest snapshot loaded time shows old data.

None of the snapshots are loading into AWR Warehouse.

Running the job “Upload Snapshot Now” completes successfully. But the snapshots does not load.

We can see that the dump is created on AWR warehouse box but its facing problems while loading.

Executing the following query on AWRWarehouse DB gives errors:

SQL>select m.target_name, error_msg, to_char(m.end_time, 'Mon dd, hh24:mi:ss'), log_file from dbsnmp.caw_load_errors e, dbsnmp.caw_load_metadata m where e.dump_id = m.dump_id and m.status = 4 order by m.end_time;

ORA-20115: datapump import encountered error:
ORA-31626: job does not exist
ORA-31638: cannot attach to job SYS_IMPORT_FULL_02 for user SYS
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPV$FT_INT", line 428
ORA-39077: unable to subscribe agent KUPC$A_1_103441637612000 to queue "KUPC$C_1_20170807103441"
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPC$QUE_INT", line 254
ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-31626: job does not exist

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