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  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.
SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community. More than 150,000 members are here to solve problems, share technology and best practices, and directly contribute to our product development process.