I get the following error messages in my nightly cleanup log. Anyone able to shed some light on how to fix this. I have 1000's of them.
6/6/2007 6:13:46 AM Summarizing into Daily Response Times Summarizing NodeID 22
6/6/2007 6:13:47 AM Error completing step
6/6/2007 6:13:47 AM The Command Text was INSERT INTO ResponseTime (NodeID, [DateTime], AvgResponseTime, MinResponseTime, MaxResponseTime, PercentLoss, Availability, Archive) SELECT NodeID AS NodeID, CONVERT(DATETIME, (FLOOR(CAST(DateTime AS float))), 102) AS [DateTime], AVG(AvgResponseTime) AS AvgResponseTime, MIN(MinResponseTime) AS MinResponseTime, MAX(MaxResponseTime) AS MaxResponseTime, AVG(PercentLoss) AS PercentLoss, AVG(Availability) AS Availability, 2 AS Archive FROM ResponseTime AS T1 WHERE (Archive < 2) AND (DateTime < 39207) AND (NodeID = 22) GROUP BY NodeID, CONVERT(DATETIME, (FLOOR(CAST(DateTime AS float))), 102)
6/6/2007 6:13:47 AM The Error Message was Violation of PRIMARY KEY constraint 'PK_ResponseTime'. Cannot insert duplicate key in object 'dbo.ResponseTime'.
6/6/2007 6:33:30 AM Summarizing into Daily Interface Traffic Summarizing InterfaceID 4107
6/6/2007 6:33:31 AM Error completing step
6/6/2007 6:33:31 AM The Command Text was INSERT INTO InterfaceTraffic (NodeID, InterfaceID, [DateTime], In_Averagebps, In_Minbps, In_Maxbps, In_TotalBytes, In_TotalPkts, In_AvgUniCastPkts, In_MinUniCastPkts, In_MaxUniCastPkts, In_AvgMultiCastPkts, In_MinMultiCastPkts, In_MaxMultiCastPkts, Out_Averagebps, Out_Minbps, Out_Maxbps, Out_TotalBytes, Out_TotalPkts, Out_AvgUniCastPkts, Out_MaxUniCastPkts, Out_MinUniCastPkts, Out_AvgMultiCastPkts, Out_MinMultiCastPkts, Out_MaxMultiCastPkts, Archive) SELECT NodeID AS NodeID, InterfaceID AS InterfaceID, CONVERT(DATETIME, (FLOOR(CAST(DateTime AS float))), 102) AS [DateTime], AVG(In_Averagebps) AS In_Averagebps, MIN(In_Minbps) AS In_Minbps, MAX(In_Maxbps) AS In_Maxbps, SUM(In_TotalBytes) AS In_TotalBytes, SUM(In_TotalPkts) AS In_TotalPkts, AVG(In_AvgUniCastPkts) AS In_AvgUniCastPkts, MIN(In_MinUniCastPkts) AS In_MinUniCastPkts, MAX(In_MaxUniCastPkts) AS In_MaxUniCastPkts, AVG(In_AvgMultiCastPkts) AS In_AvgMultiCastPkts, MIN(In_MinMultiCastPkts) AS In_MinMultiCastPkts, MAX(In_MaxMultiCastPkts) AS In_MaxMultiCastPkts, AVG(Out_Averagebps) AS Out_Averagebps, MIN(Out_Minbps) AS Out_Minbps, MAX(Out_Maxbps) AS Out_Maxbps, SUM(Out_TotalBytes) AS Out_TotalBytes, SUM(Out_TotalPkts) AS Out_TotalPkts, AVG(Out_AvgUniCastPkts) AS Out_AvgUniCastPkts, MIN(Out_MaxUniCastPkts) AS Out_MaxUniCastPkts, MAX(Out_MinUniCastPkts) AS Out_MinUniCastPkts, AVG(Out_AvgMultiCastPkts) AS Out_AvgMultiCastPkts, MIN(Out_MinMultiCastPkts) AS Out_MinMultiCastPkts, MAX(Out_MaxMultiCastPkts) AS Out_MaxMultiCastPkts, 2 AS Archive FROM InterfaceTraffic AS T1 WHERE (Archive < 2) AND (DateTime < 39207) AND (InterfaceID = 4107) GROUP BY NodeID, InterfaceID, CONVERT(DATETIME, (FLOOR(CAST(DateTime AS float))), 102)
6/6/2007 6:33:31 AM The Error Message was Violation of PRIMARY KEY constraint 'PK_InterfaceTraffic'. Cannot insert duplicate key in object 'dbo.InterfaceTraffic'.
6/6/2007 7:10:02 AM Summarizing into Daily CiscoBuffer Errors Summarizing NodeID 55
6/6/2007 7:10:02 AM Error completing step
6/6/2007 7:10:02 AM The Command Text was INSERT INTO CiscoBuffers (NodeID, [DateTime], BufferNoMem, BufferSmMiss, BufferMdMiss, BufferBgMiss, BufferLgMiss, BufferHgMiss, Archive) SELECT NodeID AS NodeID, CONVERT(DATETIME, (FLOOR(CAST(DateTime AS float))), 102) AS [DateTime], SUM(BufferNoMem) AS BufferNoMem, SUM(BufferSmMiss) AS BufferSmMiss, SUM(BufferMdMiss) AS BufferMdMiss, SUM(BufferBgMiss) AS BufferBgMiss, SUM(BufferLgMiss) AS BufferLgMiss, SUM(BufferHgMiss) AS BufferHgMiss, 2 AS Archive FROM CiscoBuffers AS T1 WHERE (Archive < 2) AND (DateTime < 39207) AND (NodeID = 55) GROUP BY NodeID, CONVERT(DATETIME, (FLOOR(CAST(DateTime AS float))), 102)
6/6/2007 7:10:02 AM The Error Message was Violation of PRIMARY KEY constraint 'PK_CiscoBuffers'. Cannot insert duplicate key in object 'dbo.CiscoBuffers'.
6/6/2007 7:30:04 AM Summarizing into Hourly Application Performance Summarizing NodeID 952
6/6/2007 7:30:08 AM Error completing step
6/6/2007 7:30:08 AM The Command Text was INSERT INTO ApplicationStatistics (NodeID, AppID, [DateTime], CPULoad, MemoryUsed, PercentMemory, SamplePeriod, Availability) SELECT NodeID AS NodeID, AppID AS AppID, CONVERT(DATETIME, DATEADD([hour], DATEPART([hour], DateTime), FLOOR(CAST(DateTime AS float))), 102) AS [DateTime], AVG(CPULoad) AS CPULoad, AVG(MemoryUsed) AS MemoryUsed, AVG(PercentMemory) AS PercentMemory, 3600 AS SamplePeriod, 3600 AS Availability FROM ApplicationStatistics AS T1 WHERE (SamplePeriod < 3600) AND (DateTime < 39230) AND (NodeID = 952) GROUP BY NodeID, AppID, CONVERT(DATETIME, DATEADD([hour], DATEPART([hour], DateTime), FLOOR(CAST(DateTime AS float))), 102)
6/6/2007 7:30:08 AM The Error Message was Violation of PRIMARY KEY constraint 'PK_ApplicationStatistics'. Cannot insert duplicate key in object 'dbo.ApplicationStatistics'.
