EM12c/13c: Enterprise Manager Cloud Control Event topSqlMonitoringList Message: Result has repeating key value error (Doc ID 2104448.1)

Last updated on JANUARY 18, 2023

Applies to:

Symptoms

Critical EM Event notifications are frequently sent:

Event topSqlMonitoringList is generating a "Result has repeating key value error"

Format of the error:

===
Host=<HOSTNAME>
Target type=Database Instance
Target name=<SID>
Categories=Error
Message= Result has repeating key value : czzfwwn404avq,16777216,373,51511
Severity=Critical
Event reported time=<DATE>
Target Lifecycle Status=Production
Department=Support
Line of Business=Information Technology
Operating System=Linux
Platform=x86_64
Associated Incident Id=19477
Associated Incident Status=New
Associated Incident Owner=
Associated Incident Acknowledged By Owner=No
Associated Incident Priority=Low
Associated Incident Escalation Level=0
Event Type=Metric Evaluation Error
Event name=topSqlMonitoringList
Metric Group=Top SQL Monitoring List
Collection Name=topSqlMonitoringList_col
Rule Name=Production Ruleset,Metric Evaluation Errors
Rule Owner=<USER>
Update Details:
Result has repeating key value : czzfwwn404avq,16777216,373,51511
Incident created by rule (Name = Production Ruleset, Metric Evaluation Errors; Owner = SYSMAN).
===

Cause

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