DotNetNuke UserController.GetUser(PortalId,UserId, False) inside TransactionScope throws TransactionAbortedException

Question

Either DotNetNuke UserController.GetUser(PortalId,UserId,false) or UserController.ValidateUser(...) inside TransactionScope is causing TransactionAbortedException and the innerException is TransactionPromotionException. The symptoms are the same as this.

Could anyone suggest me the solution to this issue? Thanks a lot !

using (System.Transactions.TransactionScope ts = new System.Transactions.TransactionScope())
    {
        DotNetNuke.Entities.Users.UserInfo ui = DotNetNuke.Entities.Users.UserController.GetUser(PortalId, UserId, false);         
        ts.Complete();
    }

score 0 · Answer 1 · edited Jun 20 '20 at 09:12

By default DotNetNuke uses the ASP.NET 2.0 membership provider. As you pointed, Membership.GetUser() opens another database connection, which causes the exception inside TransactionScope.

If you want to use GetUser() inside TransactionScope, you'll either have to enable MSDTC or use SQL Server 2008. SQL 2008 allows multiple connections within a single TransactionScope, if the connections are to the same DBMS and are not open at the same time.

DotNetNuke UserController.GetUser(PortalId,UserId, False) inside TransactionScope throws TransactionAbortedException

1 Answers1

See Also: