Skip to content

DBADash CLI - RemoveAndDelete #1621

@FuriousDBA

Description

@FuriousDBA

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.

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions