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 13.2.0.0.0 and laterInformation in this document applies to any platform.
Symptoms
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.2.0.0.0/perl/bin/perl}
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 995657590C2A49A1E053C06C9D9E249E.zip"
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.2.0.0.0/bin/zip -v FILE_NAME.zip DUMP_FILE.dmp]
zip warning: name not matched: DUMP_FILE.dmp
zip error: Nothing to do! (FILE_NAME.zip)
Failed to create FILE_NAME.zip, exit code: [12] error: [2]
Changes
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 |
Changes |
Cause |
Solution |