Import of MSDTC transaction failed: XACT_E_NOTRANSACTION.

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?

Re: Import of MSDTC transaction failed: XACT_E_NOTRANSACTION.

On 2 nov, 08:45, Seguros Catatumbo wrote:
> 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?

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.