none
WCF SQL Adapter Send Port Error RRS feed

  • Question

  • Hi,
    Could any one tell what is the below error. It happend on WCF SQL Send Adapter

    System.Transactions.TransactionAbortedException:
    System.Transactions.TransactionStatePromotedAborted.PromotedTransactionOutcome(InternalTransaction tx)
    System.Transactions.CommittableTransaction.Commit()
    Microsoft.BizTalk.Adapter.Wcf.Runtime.TxnBatch2.EndBatchComplete()
    Microsoft.BizTalk.Adapter.Wcf.Runtime.TransmitTxnBatch.EndBatchComplete()

    Regards
    Smithesh

     

    Tuesday, January 11, 2011 8:52 AM

Answers

  • Hi,

    When are you experiencing this error? What kind of operation, table, stored-procedure? When using WCF-SQL you may notice deadlocks and/or blocking on the computer running SQL Server. By default, the WCF-based SQL adapter starts a serialized transaction. You can set the UseAmbientTransaction property to false and define the desired transaction isolation level within the stored procedure.

    HTH

    Regards,

    Steef-Jan Wiggers
    MVP & MCTS BizTalk Server
    http://soa-thoughts.blogspot.com/
    If this answers your question please mark it accordingly

     


    BizTalk
    Tuesday, January 11, 2011 11:39 AM
    Moderator
  • Check if the DTC settings were changed.
    Leonid Ganeline [BizTalk MVP] BizTalk: History of one project architecture
    Wednesday, January 19, 2011 9:18 PM

All replies

  • Hi,

    When are you experiencing this error? What kind of operation, table, stored-procedure? When using WCF-SQL you may notice deadlocks and/or blocking on the computer running SQL Server. By default, the WCF-based SQL adapter starts a serialized transaction. You can set the UseAmbientTransaction property to false and define the desired transaction isolation level within the stored procedure.

    HTH

    Regards,

    Steef-Jan Wiggers
    MVP & MCTS BizTalk Server
    http://soa-thoughts.blogspot.com/
    If this answers your question please mark it accordingly

     


    BizTalk
    Tuesday, January 11, 2011 11:39 AM
    Moderator
  • Hi Steef,

    It uses a SP to insert details to a table. In SP, isolation level is set to READ COMMITTED. AmbientTransaction is set to TRUE
    This was nt happend for last 6 months as it is in production.

    Suddenly this issues happend, not sure wat is causing this.

    Regards
    Smithesh

    Wednesday, January 12, 2011 12:59 AM
  • Check if the DTC settings were changed.
    Leonid Ganeline [BizTalk MVP] BizTalk: History of one project architecture
    Wednesday, January 19, 2011 9:18 PM