Showing results for 
Search instead for 
Did you mean: 
Create Post
Level 11

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.

Labels (2)
0 Kudos
1 Reply
Level 13

Have you been able to fix it? I'm experiencing the same issue on my end.

0 Kudos