Submit a ticketCall us

Cloud Workloads: Meet Your New Hybrid IT Reality
Have you found yourself in that evolving, hybrid IT grey area and wondering if cloud workloads are now part of your purview? And if so, will monitoring cloud workloads require a new set of dedicated cloud monitoring tools? Your answers: yes, they should be, and no, they don’t.

Find out how SolarWinds® Server & Application Monitor (SAM) can help you monitor your cloud workloads side by side with your on-premises workloads. Register Now.

Home > Success Center > Enterprise Operations Console (EOC) > Reports Tab Generates an Error - Violation of PRIMARY KEY constraint 'PK_EOC_Report'. Cannot insert duplicate key in object 'dbo.EOC_Report'

Reports Tab Generates an Error - Violation of PRIMARY KEY constraint 'PK_EOC_Report'. Cannot insert duplicate key in object 'dbo.EOC_Report'

Created by Steven Bansil_ret, last modified by MindTouch on Jun 23, 2016

Views: 118 Votes: 3 Revisions: 10

Overview

The following error is found in the Reports tab for Enterprise Operations Console (EOC) that is monitoring an instance running both NPM and NCM:

 

Violation of PRIMARY KEY constrant 'PK_EOC_Report. Cannot insert duplicate key in object 'dbo.EOC.Report'. The duplicate key value is (5, 1, Down Nodes). The statement has been terminated. 

Environment

  • EOC 1.6.x

Cause

Issue is cause by having custom reports with the same names created on different SolarWinds Server maintained under EOC.

Resolution

To ensure that all reports run by EOC have unique names:

  1. Run the following query in SWQL Studio (part of Orion SDK) connecting to Orion using SWIS v2 on the Orion database to check for reports with duplicate names. Instead of SWQL Studio you can use SWIS interface on Orion Web Console by simply going to Settings and adding swis.aspx at the end of the URL, similar to below:

    http://SERVER/Orion/Admin/swis.aspx
     
  2. SELECT name, Count (name) AS NameCount
    FROM Orion.Report
    GROUP BY Name
    ORDER BY NameCount DESC
  3. Locate rows with a NameCount value of more than 1 (they will be listed at the top) and perform any of the following: 
    1. Rename duplicate reports that are required to be retained
    2. Delete duplicate reports that are not required to be retained
  4. Check the Reports tab in EOC and confirm that the reports are displaying
Last modified

Tags

Classifications

Public