MSDTC Configuration Issue

-

dear team,

we have configured msdtc in windows server 2003 our application. we need sync 2 databases (procedure: cap_exposureinsert) unfortunately receive error message in our event log. same same settings have done in our other environment , didn’t face issue.

message: operation not performed because ole db provider "sqlncli" linked server "mblc_to_mbafc_link" unable begin distributed transaction.

further detail please reviews 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: operation not performed because ole db provider "sqlncli" linked server "mblc_to_mbafc_link" unable begin 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

hello naveed,

please refer following discussions , see if of suggestions given thread's helps 

ole db provider "sqlncli" linked server " " returned message "no transaction active."

http://www.sqlservercentral.com/forums/topic415654-149-1.aspx

problem msdtc 

http://social.technet.microsoft.com/forums/en-us/winservergen/thread/eb8835d9-5f5b-4df2-8c68-4a61d5e44d6b

thanks

regards, santosh

i not represent organisation work for, opinions expressed here own.

this posting provided "as is" no warranties or guarantees , confers no rights.



Windows Server  >  Windows Server General Forum



Comments

Post a Comment

Popular posts from this blog

server manager error: ADAM.events.xml could not be enumerated.

-
firewall off isnt it. rerun ldap wizard:?  why?  will screw exchange server running on machine?  ldap wizard asks questions don't understand. please dont send generic links to: http://social.technet.microsoft.com/wiki/contents/articles/13444.windows-server-2012-server-manager-troubleshooting-guide-part-ii-troubleshoot-manageability-status-errors-in-server-manager.aspx thanks, john hi john, >> ok. server manager app. these questions refer this. nothing else 2.  do need create app dir or not?  this server manager, shouldnt done? (why did break in first place?) how check if app dir exists server manager or not. 3.  if "lightweight" implementation of anything, sure hate see "heavyweight" version. the waring events can't enumerated. , cause not completing configuration of ad lds. ad lds not related server manager. used provide flexible support directory-enabled applications. if not implementing such applications, remove role. her
Read more

Cannot access Anywhere Access using domain name?

-
after installing anywhere access in windows server 2012 essentials r2, cannot use anywhere access using setup domain name in wizard such remote.mydomain.com? if enter public ip address, example, 72.2.34.5 works. before set anywhere access, created a record pointing public address...pinged , worked...so not sure doing wrong?  is wizard supposed create record etc , make remote.mydomain.com work? if enter public ip address while on lan, takes me router webpage.  shouldn't work on lan if accessed via public ip? thank you, tim. the wizard can configure remote.microsoft_names.com  remote.remotewebaccess.com but cannot configure domains purchased outside wizard.  depends on how domain configured if wildcard.yourdomain.com should work  if try ping remote.your_domain.com afar , not give proper  public ip, need add record mariette said. much have record domain.com www.domain.com , if have website somewhere else www.domain.com , need remote.domain.com go box gr
Read more

WMI Failure: Unable to update Local Resource Group

-
Image
hi i have windows server 2008 r2 enterprise terminal services installed. this has been working fine, unable add new computers local computer groups policy on rd gateway manager i following error wmi failure: unable update local resource group  just confirm on , resource authorization policies then manage local computer groups hi hussain, posting in windows server forum. firstly please let know, did find particular event log issue? please ensure have configured rap settings correctly , set correct value , permissions rap.xml file , rapstore registry key. please check below thread more details. 1. wmi failure- unable create resource access policy (answered clarence) 2. event id 543 — rd gateway server configuration 3. event id 642 — rd gateway server availability hope helps! thanks, dharmesh Windows Server
Read more