Clear collection errors agent

When there are collection errors due to UDM scripts, the collection errors keep existing in the OEM repository, although the UDM scripts have been deleted from OEM a while ago. There is no option in OEM to delete these old collection errors.

  

When searching the internet, I came across the table mgmt_current_metric_errors which contains the collection errors. You can delete the neccessary records from this table.

sql> desc mgmt_current_metric_errors

 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 TARGET_GUID                               NOT NULL RAW(16)
 METRIC_GUID                               NOT NULL RAW(16)
 COLL_NAME                                 NOT NULL VARCHAR2(64)
 AGENT_GUID                                NOT NULL RAW(16)
 COLLECTION_TIMESTAMP                      NOT NULL DATE
 METRIC_ERROR_MESSAGE                               VARCHAR2(4000)
 METRIC_ERROR_TYPE                                  NUMBER(1)

 
sql> delete from mgmt_current_metric_errors;