IP SLA Operation stops working after an upgrade and after a short period of time

Hi.  Can you share your case #? 

01688717

Ok, still working this issue. Support has sent me a couple of fixes, one of which the instructions didn't match my install for some reason. Then I was escalated and told to Perform a fresh Orion installation (uninstall and reinstall) on the same Windows server. This did not resolve my issue. Anyone else see an error like this when they run Database Maintenance?

2024-07-23 14:30:16,431 [5] ERROR SolarWinds.Data.DatabaseMaintenance.Reporter - [Failure] 3.26s Finalize Maintenance - VoipOperationResults_CS

Message:

--------------------------------------------

dbm_ExecuteMaintenance: dbm_AggregateData_part: dbm_AggregateTimeSerie_part: XACT_STATE=-1Could not create constraint or index. See previous errors., IF NOT EXISTS(SELECT 1 FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[VoipOperationResults_CS_Hourly_stg]') AND name = N'PK_VoipOperationResults_CS_Hourly_stg')

BEGIN

    ALTER TABLE [dbo].[VoipOperationResults_CS_Hourly_stg] ADD CONSTRAINT [PK_VoipOperationResults_CS_Hourly_stg] PRIMARY KEY CLUSTERED

    (

        [Timestamp] ASC, [VoipOperationInstanceId] ASC

    ) WITH (FILLFACTOR = 100) ON [TIMESERIES]

END

Warning: Null value is eliminated by an aggregate or other SET operation.

Warning: Null value is eliminated by an aggregate or other SET operation.

Looks like you've got yourself a DB error, needs a fix to the DB (though you usually get these through installations and config wizards)
There was a bug in 2024.1 or so around DB maintenance for IPSLA, but didnt take down the feature like that.

Support will probably send you a fix script given a bit of time. Sounds like it needs reindexing maybe.