My Oracle Support Banner

EM 13C: Agent Upload Failed With Error "EMD Upload Error:full Upload Has Failed: Upload Recent Sending Statistics" (Doc ID 2995144.1)

Last updated on DECEMBER 26, 2023

Applies to:

Enterprise Manager Base Platform - Version 13.4.0.0.0 and later
Information in this document applies to any platform.

Symptoms

Symptoms 1:

Few Agent upload fail with error : EMD upload error:full upload has failed: Upload Recent Sending Statistics

<AGENT_HOME>/bin/emctl upload agent
Oracle Enterprise Manager Cloud Control 13c Release 4
Copyright (c) 1996, 2020 Oracle Corporation. All rights reserved.
---------------------------------------------------------------
EMD upload error:full upload has failed: Upload Recent Sending Statistics
________________________________
Channel=data send[ms]=61 fsz=645
Channel=data send[ms]=74 fsz=910

Avg send time=67.5 milliseconds
Backoff Event List
________________________________
Upload Failure List
_______________________________
Connection Event List
_____________________________
Upload timed out before completion.
Number of files to upload before the uploadNow call: 100, total size (MB): 12.367094
Remaining number of files to upload: 101, total size (MB): 12.368876 (TIMEOUT)

Symptoms 2:

Repository DB alert log is filled with frequent deadlocks and heavy load on DB. Due to this, spikes of agent backoff requests regularly.

Deadlocks:

Current SQL : UPDATE EM_METRIC_ITEMS SET IS_CURRENT = '0' WHERE
METRIC_GROUP_ID = :B3 AND TARGET_GUID = :B2 AND IS_CURRENT = '1' AND
LAST_COLLECTION_TIME < :B1
Current SQL : UPDATE EM_METRIC_ITEMS SET LAST_COLLECTION_TIME = :B1 ,
IS_CURRENT = '1' WHERE METRIC_ITEM_ID = :B2 AND LAST_COLLECTION_TIME < :B1

Current SQL : UPDATE EM_METRIC_ITEMS SET IS_CURRENT = '0' WHERE
METRIC_GROUP_ID = :B3 AND TARGET_GUID = :B2 AND IS_CURRENT = '1' AND
LAST_COLLECTION_TIME < :B1

 Symptoms 3:

 Number of records under the EM_METRIC_ITEMS_e table is too huge.

 SELECT count(1) FROM EM_METRIC_ITEMS_e;

 Showing xxx million records

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.