Re: DTC fails when number of updates in huge

From: Sam Santiago (ssantiago_at_n0spam-SoftiTechture.com)
Date: 12/24/04 

Date: Thu, 23 Dec 2004 16:11:50 -0800

  Is this ASP or ASP.NET? Do you use an other components with the ASP? The
error indicates you are attempted to perform additional transactional work
after the transaction is committed. Are you explicitly committing the
transaction or marking it as done at any point?

Thanks,

Sam 

-- 
_______________________________
Sam Santiago
ssantiago@n0spam-SoftiTechture.com
http://www.SoftiTechture.com
_______________________________
"Tony Moaikel" <tmoaikel@cybiz.com> wrote in message 
news:O8FrsTT6EHA.3908@TK2MSFTNGP12.phx.gbl...
> The error is: 'Distributed transaction completed. Either enlist in a new 
> transaction or the null transaction.
> The asp page itself is transactional (Transaction=Required) so all updates 
> within the page are under the same transaction.
>
> Thanks
> Tony
> "Sam Santiago" <ssantiago@n0spam-SoftiTechture.com> wrote in message 
> news:OlWG17S6EHA.3708@TK2MSFTNGP14.phx.gbl...
>> It might help to post the exact error message you are seeing.  Are all of 
>> these updates performed as one big transaction or as individual 
>> transactions?
>>
>> Thanks,
>>
>> Sam
>>
>> -- 
>> _______________________________
>> Sam Santiago
>> ssantiago@n0spam-SoftiTechture.com
>> http://www.SoftiTechture.com
>> _______________________________
>> "Tony Moaikel" <tmoaikel@cybiz.com> wrote in message 
>> news:%23HYvuqr5EHA.2624@TK2MSFTNGP11.phx.gbl...
>>> Hi all,
>>>
>>> We are facing an issue with an asp page that performs a huge number of 
>>> updates to a database.
>>> The page fails at different places when executed many times.
>>> Is there a way to increase the DTC capacity to allow more updates?
>>> We have tried to increase the log size but it does not seem to have any 
>>> effect.
>>>
>>> Thanks in advance
>>>
>>> Tony
>>>
>>>
>>
>>
>
>

Relevant Pages

  • Re: Handling Script Timeout when invoking ActiveX Object involving ADODB from ASP2.0 pages
    ... With the ASP file listed at the end of this post, ... I load the ASP on Server A, ... New transaction cannot enlist in the specified transaction coordinator. ... Const adOpenKeyset = 1 ...
    (microsoft.public.inetserver.asp.general)
  • Re: DTC fails when number of updates in huge
    ... The error is: 'Distributed transaction completed. ... The asp page itself is transactional so all updates ... "Sam Santiago" wrote in message ...
    (microsoft.public.dotnet.distributed_apps)
  • Re: Handling Script Timeout when invoking ActiveX Object
    ... In a proper scenario, I have an ASP Page, which ... err.Description= New transaction cannot enlist in the specified transaction ... With this production ASP page, ... how could I prevent this standard Microsoft error from being ...
    (microsoft.public.dotnet.framework.interop)
  • Re: Handling Script Timeout when invoking ActiveX Object
    ... In a proper scenario, I have an ASP Page, which ... err.Description= New transaction cannot enlist in the specified transaction ... With this production ASP page, ... how could I prevent this standard Microsoft error from being ...
    (microsoft.public.inetserver.asp.general)
  • Re: xp_sendmail in trigger from asp page -error
    ... You may get more help in an ASP ... newsgroup but please include the exact error message you have. ... open a transaction while you do this and it is bad practice to do so simply ... SQL Server MVP ...
    (microsoft.public.sqlserver.programming)
Loading