cancel
Showing results for 
Search instead for 
Did you mean: 
Create Post
Level 9

Error in Solarwinds Database maintenance log.

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.

Labels (1)
0 Kudos
0 Replies