When the database maintenance is ran on the Orion Server, i am getting the following error in the swmaintenance.log. Please provide any fix if available.
ERROR SolarWinds.Data.DatabaseMaintenance.MaintenanceEngine - Error in thread: System.Data.SqlClient.SqlException (0x80131904): dbm_ExecuteMaintenance: dbm_AggregateData_part: dbm_AggregateTimeSerie_part: The ALTER TABLE statement conflicted with the CHECK constraint "CHK_CPULoad_CS_Hourly_stg". The conflict occurred in database "SolarWindsOrion", table "dbo.CPULoad_CS_Hourly_stg", column 'Timestamp'. ALTER TABLE CPULoad_CS_Hourly_stg WITH CHECK ADD CONSTRAINT CHK_CPULoad_CS_Hourly_stg CHECK ([Timestamp] >= '20190630' AND [Timestamp] < '20190701')
Warning: Null value is eliminated by an aggregate or other SET operation.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at SolarWinds.Database.TimeSeries.Helpers.SqlHelper.ExecuteNonQuery(IDbConnection connection, String sql, IDbTransaction transaction, IEnumerable`1 parameters, CommandType commandType)
at SolarWinds.Database.TimeSeries.Helpers.SqlHelper.SolarWinds.Database.TimeSeries.Helpers.ISqlHelper.ExecuteNonQuery(String sql, IDbConnection connection, IDbTransaction transaction, IEnumerable`1 parameters, CommandType commandType)
at SolarWinds.Database.TimeSeries.Drivers.ColumnStore.ColumnStoreMaintenanceExecutor.ExecuteMaintenance(String tableName, DateTime currentDate)
at SolarWinds.Database.TimeSeries.Drivers.MaintenanceExecutorBase.ExecuteMaintenance(String tableName, RetentionIntervals retentionIntervals, DateTime currentDate)
at SolarWinds.Data.DatabaseMaintenance.TimeSeriesTableHandler.PostMaintenance(DateTime basisDate)
at SolarWinds.Data.DatabaseMaintenance.MaintenanceEngine.<>c__DisplayClass24_0.<TableHandlerWorker>b__7()
at SolarWinds.Data.DatabaseMaintenance.MaintenanceEngine.ExecuteMaintenanceAction(Action maintenanceAction, String actionDescription)
at SolarWinds.Data.DatabaseMaintenance.MaintenanceEngine.TableHandlerWorker(DatabaseMaintenanceThreadParameter value)
ClientConnectionId:51fa85a6-d4e6-4339-b2c3-036159e9ab1b
Error Number:50000,State:0,Class:16
Any help would be greatly appreciated.
