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.
Issue is cause by having custom reports with the same names created on different SolarWinds Server maintained under EOC.
To ensure that all reports run by EOC have unique names:
swis.aspxat the end of the URL, similar to below:
SELECT name, Count (name) AS NameCount FROM Orion.Report GROUP BY Name ORDER BY NameCount DESC