0 Replies Latest reply on Aug 10, 2018 8:09 AM by alphabits

    Cannot Summarize Custom Poller Table Due to PK Error


      My custompollerstatistics_detail table is unable to summarize into the hourly table during database maintenance due to the PK error shown below.


      2018-08-09 20:25:17,414 [4] ERROR SolarWinds.Data.DatabaseMaintenance.StandardTableHandlerDAL - Failed to execute procedure: dbm_CustomPollerStatistics_DetailToHourly

      System.Data.SqlClient.SqlException (0x80131904): Violation of PRIMARY KEY constraint 'PK_CustomPollerStatistics_Hourly'. Cannot insert duplicate key in object 'dbo.CustomPollerStatistics_Hourly'. The duplicate key value is (12fb2831-f76f-41a9-95b9-00123442263e, Jul 26 2018  6:00PM, 1, ).


      If I delete the offending row it just throws the error on the next row when database maintenance is ran again.


      Any thoughts here? I have a support case open, but its really stagnated.