My Oracle Support Banner

EM 12c: Enterprise Manager 12c Cloud Control AWR WareHouse Transfer Job CAW_TRANSFER fails with Error: Failed to create .zip, exit code: [12] error: [No such file or directory] (Doc ID 2274555.1)

Last updated on AUGUST 19, 2022

Applies to:

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


The Enterprise Manager (EM) Cloud Control AWR WareHouse Transfer Job (CAW_TRANSFER) fails with the following error:

Failed to create, exit code: [12] error: [No such file or directory]

(The error above error followed 14 zip warnings: name not matched: ... for each of the 14 *.dmp files waiting for transfer.)

Running the following SQL query on the AWR WH Repository DB results in data pump errors:

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-39000: bad dump file specification
ORA-31640: unable to open dump file "<AWR-WH param 'dest_dir'>/<dump file name>" for read

(where the file path/name is very long)



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

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