-
-
Notifications
You must be signed in to change notification settings - Fork 87
Open
Labels
CompletedDEV work completed. To be included in next release if issue is still open.DEV work completed. To be included in next release if issue is still open.
Description
Hi,
when using DBADashConfig.exe with action RemoveAndDelete I'm getting errors like below:
2025-11-04 00:01:04 | Removing: SRVSRVSRV|DBDBDB
2025-11-04 00:01:11.723 +00:00 [INF] Action:RemoveAndDelete
2025-11-04 00:01:11.777 +00:00 [INF] Remove existing connection: SRVSRVSRV.database.windows.net|DBDBDB
2025-11-04 00:01:11.783 +00:00 [INF] Marking instance deleted in REPOREPOREPO.database.windows.net|DBADashDB
2025-11-04 00:01:13.225 +00:00 [ERR] Error marking instance deleted in REPOREPOREPO.database.windows.net|DBADashDB
Microsoft.Data.SqlClient.SqlException (0x80131904): Instance not found
at Microsoft.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at Microsoft.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at Microsoft.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, SqlCommand command, Boolean callerHasConnectionLock, Boolean asyncClose)
at Microsoft.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
at Microsoft.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)
at Microsoft.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean isAsync, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
at Microsoft.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry, String method)
at Microsoft.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry, String methodName)
at Microsoft.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at DBADash.SharedData.InstanceDelete(String connectionID, String connectionString, Boolean isActive, Boolean hardDelete) in D:\a\dba-dash\dba-dash\DBADash\SharedData.cs:line 19
at DBADash.SharedData.MarkInstanceDeleted(String connectionID, String connectionString) in D:\a\dba-dash\dba-dash\DBADash\SharedData.cs:line 34
at DBADashConfig.Helper.MarkInstanceDeleted(CollectionConfig config, String connectionId, Boolean isActive) in D:\a\dba-dash\dba-dash\DBADashConfig\Helper.cs:line 113
ClientConnectionId:xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Error Number:50000,State:1,Class:11
ClientConnectionId before routing:xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Routing Destination:xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx.westeurope1-a.worker.database.windows.net,11034
Surely I understand the error message. I'm removing ConnectionString from the ServiceConfig file but Instance is already deleted or not active, but can we please make the RemoveAndDelete action successful in that case?
Thx
Metadata
Metadata
Assignees
Labels
CompletedDEV work completed. To be included in next release if issue is still open.DEV work completed. To be included in next release if issue is still open.