Cannot delete USER Event viewer: UiPath.IdentityServer.Web.Middleware.ExceptionHandlingMiddleware Cannot use SAVE TRANSACTION within a distributed transaction.SqlException*Cannot use SAVE TRANSACTION within a distributed transaction.* at Microsoft.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at Microsoft.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at Microsoft.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
Root Cause: This is an 2016 MS SQL Server issue when Always Mode is enabled
Resolution: Modify the parameter
- Set DTC_SUPPORT = PER_DB
Check related links for setting up the parameter,
- Configure Availability Group For Distributed Transactions
- Fix Errors 627 or 12324 Occur When Cross Database Transactions Are Promoted To Distributed Transactions In SQL Server Availability Group .