Microsoft Vista: Exception while using Transaction Scope Activity

• satyavani / 100 / Mon, 01 Mar 2010 01:56:00 GMT / Comments (3)
• Hi,

  Transaction Scope Activity is giving the following exception when I am trying to run the application from Server where it is executing properly when it is run locally.

  Please give me the solution.

  System.Transactions.TransactionException: The Transaction Manager is not available. (Exception from HRESULT: 0x8004D01B) > System.Runtime.InteropServices.COMException (0x8004D01B): The Transaction Manager is not available. (Exception from HRESULT: 0x8004D01B)
  at System.Runtime.InteropServices.Marshal.ThrowExceptionForHRInternal(Int32 errorCode, IntPtr errorInfo)
  at System.EnterpriseServices.Thunk.ServiceDomainThunk.EnterServiceDomain(ServiceConfigThunk psct)
  at System.EnterpriseServices.ServiceDomain.Enter(ServiceConfig cfg)
  at System.Transactions.TransactionScope.PushServiceDomain(Transaction newCurrent)
  End of inner exception stack trace
  at System.Transactions.TransactionScope.PushServiceDomain(Transaction newCurrent)
  at System.Transactions.TransactionScope.SetCurrent(Transaction newCurrent)
  at System.Transactions.TransactionScope.PushScope()
  at System.Transactions.TransactionScope.Initialize(Transaction transactionToUse, TimeSpan scopeTimeout, Boolean interopModeSpecified)
  at System.Transactions.TransactionScope..ctor(Transaction transactionToUse, TimeSpan scopeTimeout, EnterpriseServicesInteropOption interopOption)
  at System.Workflow.Runtime.Scheduler.Run()
  
• Keywords:

  exception, transaction, scope, activity, microsoft, vista

• http://www.edevs.com/ms-vista/69172/«« Last Thread - Next Thread »»

• 1. Sounds like a DTC issue. Take a look at the following posts for how to resolve the problem:

     http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=184654&SiteID=1

     http://forums.microsoft.com/TechNet/ShowPost.aspx?PostID=76892&SiteID=17

     tomlake_msft | Tues, 04 Sep 2007 21:51:59 GMT |

  2. Hi Tom,

     I think I was not clear about my problem in the earlier post.I am giving you the clear view of the problem.

     We have one sequential WF.

     Put Transactionscope (TS) Activity over it.

     Add two code activity inside the TS.

     Add persistent service into WF runtime, so that we can use transaction.

     Open the DB connection and close in each code activity.

     Problem:

     When we tried on localhost, it works fine.

     When we tried on remote DB, it opens DB connection first time without any exception. after that i have closed the DB connection.

     When we tried to open DB connection second time, it throws an exception "Communication with the underlying transaction manager has failed".

     Even i am doing any transaction in the DB, only opening and closing the DB Connection twice within the Transaction scope.

     Note : We have enabled the MSDTC from Component services. checked allow remote connection and disable the firewall services.

     i have tried all above settings to resolve the issue, But......?

     Please give any solutions for the above scenario.

     Can we use two code activities inside Transaction scope for database transactions. Why it is working in local machine. Why it's not in remote.

     Thank You

     Satya.

     satyavani | Tues, 04 Sep 2007 21:53:05 GMT |

  3. Hi,

     Anybody can look in to my problem and give a solution or even any reference of other post, it will be more precious for me. This issue is pending for my process to complete. Please give a solution.

     Thank You

     Satya

     satyavani | Tues, 04 Sep 2007 21:53:58 GMT |