My Oracle Support Banner

EM 13c: AWR CAW_RUN_ETL_NOW - AWR transfer Failed With File Size Mismatch (Doc ID 2621959.1)

Last updated on MARCH 25, 2020

Applies to:

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


Uploading dump file to AWR Warehouse repository [Action>Upload Snapshots Now] fails with the following error:

2019-12-09 11:14:46,977 [17204604:<SID>:HTTP Listener-17204604 - /emd/main/ (~Task-free~ OMS.console@20793@<host name>=>[157588648690001])] INFO - >>> Dispatching request: GetActiveCollectionRequest (rac_database.<SID> collectionItems:failed_awr_import_coll) <<<

2019-12-09 11:14:17,875 [17204604:<SID>:HTTP Listener-17204604 - /emd/main/ (DispatchRequests OMS.console@20793@<host name>=>[157588643360005])] INFO - >>> Dispatching request: PerformOperationRequest (%perlbin%/perl (targetId=host.<host name>) - /bin/sh /base/oracle/oraexp/ RFS_DIRS 100 HOEM authscheme=NATIVE_AGENT username:oracle jobId=OMS.console@20793@<host name>=>[157588643360005]) <<<
2019-12-09 11:14:17,876 [17204604:B0E5B001] INFO - Job Attributes: {JobID=OMS.console@20793@<host name>=>[157588643360005], KeepAliveRequest=false} Job Command: {<agent_base>/agent_13.}
2019-12-09 11:14:17,920 [17204604:<SID>] INFO - PatternDetector filter scan disabled: reason=REQUEST
2019-12-09 11:14:18,051 [17204604:<SID>] INFO - JobTaskExitPacket {JobTaskExitPacket[exitCode=0,msg=,nlsid=56]}
2019-12-09 11:14:18,052 [17204604:<SID>] INFO - >>> Reporting response: PerformOperationResponse (exitCode:0 output:<SID> drwxrwxr-x oracle dba 4096 1465716264000

When CAW_RUN_ETL_NOW run shows below error:

* the zip is created as follow :
"total bytes=22568960, compressed=2012803 -> 91% savings
Created archive"
But the size isn't the same when manually checked in the folder (actual : 344064).

* The transferFile step fails with "File size mismatch (Actual: 344064, Expected: 2013075)"

When CAW_TRANSFER is run shows below error:

"Maximum total size of dump files: 5368709120
file:DUMP_FILE.dmp size(bytes):

Number of files picked up for transfer: 1

Updated status of dump files, ready to transfer

Creating archive file using [/soft/oracle/product/agent/agent_13. -v DUMP_FILE.dmp]

zip warning: name not matched: DUMP_FILE.dmp

zip error: Nothing to do! (

Failed to create, exit code: [12] error: [2]




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.