Custom Indexes causing Database Maintenance to fail

8/24/2021 2:41 PM

2/11/2025 8:05 PM

If your DBA has created any custom indexes on Orion DB, then you may notice following errors in DB maintenance log after upgrade to 2020.2.6 (version this error was reported under). The error may also appear in another version of Solarwinds orion platform.

<Timestamp> [1] ERROR SolarWinds.Data.DatabaseMaintenance.MaintenanceEngine - Error in thread: 
System.Data.SqlClient.SqlException (0x80131904): dbm_ExecuteMaintenance: dbm_AggregateData_part: dbm_AggregateTimeSerie_part: 
ALTER TABLE SWITCH statement failed. There is no identical index in source table 
'SolarWindsOrion.dbo.CPUMultiLoad_CS_Hourly_stg' for the index 'IX_NodeID_Timestamp' 
in target table 'SolarWindsOrion.dbo.CPUMultiLoad_CS_Hourly_hist' . ALTER TABLE CPUMultiLoad_CS_Hourly_stg
SWITCH TO CPUMultiLoad_CS_Hourly_hist PARTITION 23
WITH (WAIT_AT_LOW_PRIORITY (MAX_DURATION = 1 MINUTES, ABORT_AFTER_WAIT = BLOCKERS))
Warning: Null value is eliminated by an aggregate or other SET operation.

 

Orion Platform

Custom Indexes in place on the Table

Custom Indexes were created for the Tables mentioned in the error.
Please ask your DBA to remove or fix them and then Re-run DB maintenance. Check DB maintenance logs after next DB maintenance run on the Main poller if the error is gone 
Ex:
Index IX_NodeID_Timestamp  is missing in table CPUMultiLoad_CS_Hourly_stg