locked
MSDTC Configuration Issue RRS feed

  • Question

  • Dear Team,

    We have configured MSDTC in windows server 2003 for our application. What we do is we need sync two databases for (Procedure: CAP_EXPOSUREINSERT) but unfortunately we receive an error message in our event log. But same same settings we have done in our other environment and we didn’t face any issue.

    Message: The operation could not be performed because OLE DB provider "SQLNCLI" for linked server "MBLC_TO_MBAFC_LINK" was unable to begin a distributed transaction.

    Further detail please reviews the complete error log below.

    09/26/2012 15:01:11

    Type : System.Data.SqlClient.SqlException, System.Data, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089

    Message: The operation could not be performed because OLE DB provider "SQLNCLI" for linked server "MBLC_TO_MBAFC_LINK" was unable to begin a distributed transaction.

    Source : .Net SqlClient Data Provider

    Help link :

    Errors : System.Data.SqlClient.SqlErrorCollection

    Class : 16

    LineNumber : 129

    Number : 7391

    Procedure : CAP_EXPOSUREINSERT

    Server : Test server

    State : 2

    TargetSite : Int32 Update(System.Data.DataRow[], System.Data.Common.DataTableMapping)

    Stack Trace :    at System.Data.Common.DbDataAdapter.Update(DataRow[] dataRows, DataTableMapping tableMapping)

       at System.Data.Common.DbDataAdapter.Update(DataRow[] dataRows)

       at Cap.Persistence.Components.Exposure.CAPExposurePO.Flush(DataSet data, DataViewRowState rowState, IDbConnection connection, IDbTransaction transaction)

       at Cap.Persistence.Components.Exposure.CAPExposurePO.Insert(DataSet data, IDbConnection connection, IDbTransaction transaction)

    Additional Info:

    MachineName : Test server

    TimeStamp : 2012/09/26 7:01:11 AM

    FullName : Microsoft.Practices.EnterpriseLibrary.ExceptionHandling, Version=1.1.0.0, Culture=neutral, PublicKeyToken=null

    AppDomainName : /LM/W3SVC/1/Root/CAP-1-129930552048230000

    ThreadIdentity : huan jingx

    WindowsIdentity : NT AUTHORITY\NETWORK SERVICE

    Category: {cap}

    Priority: 0

    EventId: 100

    Severity: Error

    Title:Enterprise Library Exception Handling

    Machine: Test server

    Application Domain: /LM/W3SVC/1/Root/CAP-1-129930552048230000

    Process Id: 5320

    Process Name: c:\windows\system32\inetsrv\w3wp.exe

    Win32 Thread Id: 2924

    Thread Name:

    Extended Properties:


    Naveed Amir

    Friday, September 28, 2012 7:10 AM

Answers