BizTalk Atomic Transaction Rollback in orchestration RRS feed

  • Question

  • I have multiple process in a orchestration to call database insert and update (by different sent port).

    Does have any way to make those trsaction call database insert and update in Atomic Transaction? except using Compensation Model.

    Wednesday, March 11, 2015 1:59 AM


  • Hi,

    Using an Atomic Scope shape to perform multiple send  operations does not  guarantee that the send operations will be rolled back in the case one send fails. For example, if you have two Send shapes each sending a message to a SQL database, if there is a failure in one or both SQL  databases, the Atomic Scope shape does not guarantee that the data will  be backed out from either database call. BizTalk considers the boundary of a transaction to be the point that a message is committed to the  Message Box. True rollbacks are guaranteed only in true Microsoft Distributed Transaction  Coordinator (MSDTC) transactions.

    Refer some good articles around it.

    Behavior of BizTalk Adapters with Transactions

    Orchestrations - Creating Atomic Scopes


    Please mark as answer or vote as helpful if my reply does

    Wednesday, March 11, 2015 5:10 AM