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

Last updated on JULY 15, 2017

Applies to:

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

Symptoms

Enterprise Manager (EM) Cloud Control 12.1.0.5.0

Critical EM12c Event notifications are frequently sent:

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

Format of the error:

===
Host=foo.com
Target type=Database Instance
Target name=ORCL
Categories=Error
Message= Result has repeating key value : czzfwwn404avq,16777216,373,51511
Severity=Critical
Event reported time=Feb 8, 2016 1:32:16 AM CST
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=SYSMAN
Update Details:
Result has repeating key value : czzfwwn404avq,16777216,373,51511
Incident created by rule (Name = Production Ruleset, Metric Evaluation Errors; Owner = SYSMAN).

===

Changes

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms