Hi everyone,
I upgraded from 2020.2 to 2022.3 and sadly I found in the admin notification show Database maintenance started on Tuesday, September 13, 2022 has finished with errors.
I tried to check and run the DB Maintainance manually, the issue is error with System.Data.SqlClient.SqlException (0x80131904): Could not find stored procedure 'dbm_ExecuteMaintenance_legacy'.
Is there any way to create that proc? I open the SQLServer and can not find that proc in SSMC
HERE is the error
2022-09-13 10:09:46,577 [4] INFO SolarWinds.Data.DatabaseMaintenance.TimeSeriesTableHandler+TimeSeriesMaintenanceExecutorContext - Running maintenance for CPUMultiLoad_CS
2022-09-13 10:09:46,577 [4] ERROR SolarWinds.Data.DatabaseMaintenance.MaintenanceEngineHelper - Failed to execute 'Finalize Maintenance [CPUMultiLoad]'
System.Data.SqlClient.SqlException (0x80131904): Could not find stored procedure 'dbm_ExecuteMaintenance_legacy'.
at System.Data.SqlClient.SqlConnection.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.Legacy.LegacyMaintenanceExecutor.ExecuteMaintenance(String tableName, DateTime currentDate)
at SolarWinds.Database.TimeSeries.Drivers.MaintenanceExecutorBase.ExecuteMaintenance(String tableName, RetentionIntervals retentionIntervals, DateTime currentDate)
at SolarWinds.Database.TimeSeries.Drivers.LegacyToColumnStore.LegacyToColumnStoreMaintenanceExecutor.ExecuteLegacyMaintenance(String tableName, DateTime currentDate)
at SolarWinds.Database.TimeSeries.Drivers.LegacyToColumnStore.LegacyToColumnStoreMaintenanceExecutor.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.MaintenanceEngineHelper.ExecuteMaintenanceAction(Action maintenanceAction, OperationSeverity severity, String actionName, String actionTarget)
ClientConnectionId:db991c38-9768-4e37-ae03-1153f92b5032
Error Number:2812,State:62,Class:16
