Import of MSDTC transaction failed: XACT_E

Import of MSDTC transaction failed: XACT_E_NOTRANSACTION.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Seguros Catatumbo - 02 Nov 2007 13:45 GMT

I have been searching this error everywhere, and it talks about some
RPC permission or something. But it only happens to a specific user.
The difference is that on this specific user, there are four or five
more inserts to the database.

On the top of the asp page i have:

<%@ TRANSACTION = required %>

and near the bottom i have:

If Err.Number = 0 Then
objectcontext.setcomplete
else
objectcontext.setabort
end if

Is it possible that my problem is just that one of the queries that
get done inside the specific user's section is just taking too long
and timing out, therefore getting that message?

Reply to this Message

Seguros Catatumbo - 02 Nov 2007 15:44 GMT

> I have been searching this error everywhere, and it talks about some
> RPC permission or something. But it only happens to a specific user.
[quoted text clipped - 16 lines]
> get done inside the specific user's section is just taking too long
> and timing out, therefore getting that message?

I found one of those queries and it was taking too long to execute, so
i am guessing that the XACT_E_NOTRANSACTION error is always thrown on
a timeout if it is done inside a transaction.
I put an index in that query, i hope that it won't happen any more.

Reply to this Message

Webmaster Forum / ASP / Database Access / November 2007

Import of MSDTC transaction failed: XACT_E_NOTRANSACTION.