ADO.NET MSDTC Error

9 Nov 2005 5:06 AM

Srini Eadha

Hi,
we are experiencing strange problem in ADO.NET assembly. we use DTC
transactions for MSMQ and SQL server. just recently we are consistently(one
or two times in a day) getting following exception and losing messages every
time with this exception.

"Import of MSDTC transaction failed: Result Code = 0x8004d00e.".

we are running our application(C#) on windows 2000 and SQL server.

I know I am not explaining problem clearly, but I just would like to know if
any one already knew this exception or issue.

I already googled the issue, did not find any solution/suggestions.

Please, I would appreciate for any kind of help to resolve this issue.

Thanks,
Srini

9 Nov 2005 11:11 AM

Sahil Malik [MVP]

There could be a number of reasons for this error. Your distro trans could
be timing out, you may be trying to recommit a committed or rolled back
transaction, or you may be missing a patch on windows xp sp2 (sp2 blocks out
network msdtc).

- Sahil Malik [MVP]
ADO.NET 2.0 book -
http://codebetter.com/blogs/sahil.malik/archive/2005/05/13/63199.aspx
-------------------------------------------------------------------------------------------

Show quote

"Srini Eadha" <srini.ea***@sungard.com> wrote in message
news:OrxMVtO5FHA.2036@TK2MSFTNGP14.phx.gbl...
> Hi,
> we are experiencing strange problem in ADO.NET assembly. we use DTC
> transactions for MSMQ and SQL server. just recently we are
> consistently(one or two times in a day) getting following exception and
> losing messages every time with this exception.
>
> "Import of MSDTC transaction failed: Result Code = 0x8004d00e.".
>
> we are running our application(C#) on windows 2000 and SQL server.
>
> I know I am not explaining problem clearly, but I just would like to know
> if any one already knew this exception or issue.
>
> I already googled the issue, did not find any solution/suggestions.
>
> Please, I would appreciate for any kind of help to resolve this issue.
>
> Thanks,
> Srini
>
>

9 Nov 2005 2:58 PM

Srini Eadha

Hi Malik, thank you for the response.

I am still wondering what could be causing this problem, I checked multiple
commits/rollback,but couldn't find one.
as I mentioned we are running our app on win2000 server(sp4) in .NET1.1 with
no service pack.

This is very urgent matter for us, any help would be highly appreciated.

Thanks,

Srini

Show quote

"Sahil Malik [MVP]" <contactmethrumyblog@nospam.com> wrote in message
news:uy3EV5R5FHA.2864@tk2msftngp13.phx.gbl...
> There could be a number of reasons for this error. Your distro trans could
> be timing out, you may be trying to recommit a committed or rolled back
> transaction, or you may be missing a patch on windows xp sp2 (sp2 blocks
> out network msdtc).
>
> - Sahil Malik [MVP]
> ADO.NET 2.0 book -
> http://codebetter.com/blogs/sahil.malik/archive/2005/05/13/63199.aspx
> -------------------------------------------------------------------------------------------
>
> "Srini Eadha" <srini.ea***@sungard.com> wrote in message
> news:OrxMVtO5FHA.2036@TK2MSFTNGP14.phx.gbl...
>> Hi,
>> we are experiencing strange problem in ADO.NET assembly. we use DTC
>> transactions for MSMQ and SQL server. just recently we are
>> consistently(one or two times in a day) getting following exception and
>> losing messages every time with this exception.
>>
>> "Import of MSDTC transaction failed: Result Code = 0x8004d00e.".
>>
>> we are running our application(C#) on windows 2000 and SQL server.
>>
>> I know I am not explaining problem clearly, but I just would like to know
>> if any one already knew this exception or issue.
>>
>> I already googled the issue, did not find any solution/suggestions.
>>
>> Please, I would appreciate for any kind of help to resolve this issue.
>>
>> Thanks,
>> Srini
>>
>>
>
>