Hi,
Database Maintenance has been failing on Interface tables for a last couple of days and this is the error that I see on the logs - I have already raised a case with SolarWinds - but then wanted to know if anyone faced this in the past and if so how did you fix it ?
2022-12-23 11:22:22,238 [5] ERROR SolarWinds.Data.DatabaseMaintenance.MaintenanceEngine - Error in thread: System.Data.SqlClient.SqlException (0x80131904): dbm_ExecuteMaintenance: dbm_AggregateData_part: dbm_AggregateTimeSerie_part: XACT_STATE=-1MERGE clause of ALTER PARTITION statement failed because two nonempty partitions containing a columnstore index cannot be merged. Consider an ALTER TABLE SWITCH operation from one of the nonempty partitions on table 'InterfaceErrors_CS_Detail_hist' to a temporary staging table and then re-attempt the ALTER PARTITION MERGE operation. Once completed, use ALTER TABLE SWITCH to move the staging table partition back to the original source table., ALTER PARTITION FUNCTION pf_InterfaceErrors_CS_Detail_hist() MERGE RANGE (@merge_date)
Warning: Null value is eliminated by an aggregate or other SET operation.
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, Boolean shouldCacheForAlwaysEncrypted)
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:bf6c8e61-1bc2-457e-b774-12cae5f64bab
Error Number:50000,State:1,Class:15
