|
|
You're in the
dotnet distributed apps
group:DTC fails when number of updates in huge
dotnet distributed apps:
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
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 _______________________________ [quoted text, click to view] "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 > >
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 _______________________________ [quoted text, click to view] "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 >>> >>> >> >> > >
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 [quoted text, click to view] "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 >> >> > >
This is ASP. I am not explicitly committing or aborting the transaction.
And what is strange is that the error occurs at a different place when the page is reloaded!! [quoted text, click to view] "Sam Santiago" <ssantiago@n0spam-SoftiTechture.com> wrote in message news:uVREs0U6EHA.208@TK2MSFTNGP12.phx.gbl... > 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 >>>> >>>> >>> >>> >> >> > >
You could add event handlers to the page in order to log information
when the transaction is aborted or committed: Sub OnTransactionCommit() Response.Write "<p><b>Display debugging info here.</b>." End Sub Sub OnTransactionAbort() Response.Write "<p><b>Display debugging info here.</b>." End Sub Also, at some point in your page you should do either and ObjectContext.SetComplete on success or ObjectContext.SetAbort on failure. Check out these links for more info: ObjectContext http://msdn.microsoft.com/library/default.asp?url=/library/en-us/iissdk/iis/ref_vbom_obco.asp Spanning Transactions across Pages http://support.microsoft.com/default.aspx?scid=kb;en-us;299638 Thanks, Sam -- _______________________________ Sam Santiago ssantiago@n0spam-SoftiTechture.com http://www.SoftiTechture.com _______________________________ [quoted text, click to view] "Tony Moaikel" <tmoaikel@cybiz.com> wrote in message news:OwmJJFC7EHA.2568@TK2MSFTNGP10.phx.gbl... > This is ASP. I am not explicitly committing or aborting the transaction. > And what is strange is that the error occurs at a different place when the > page is reloaded!! > > "Sam Santiago" <ssantiago@n0spam-SoftiTechture.com> wrote in message > news:uVREs0U6EHA.208@TK2MSFTNGP12.phx.gbl... >> 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 >>>>> >>>>> >>>> >>>> >>> >>> >> >> > >
Don't see what you're looking for? Try a search.
|
June 2003
July 2003
August 2003
September 2003
October 2003
November 2003
December 2003
January 2004
February 2004
March 2004
April 2004
May 2004
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
December 2007
January 2008
February 2008
March 2008
April 2008
May 2008
June 2008
| home · blog · groups | Questions? Comments? Contact the dn |