Orchestrator Multinode - Cannot Use SAVE TRANSACTION Within A Distributed Transaction

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,