Commerce Server General - Purchase Error

This is Interesting: Free IT Magazines  
Home > Archive > Commerce Server General > October 2005 > Purchase Error





You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author Purchase Error
cgruber

2005-09-29, 8:48 pm

I have a feeling that this is a database configuration issue, but
maybe you guys could send me in the right direction.

When I click 'Accept Charges' after all the credit card info is added
I get the following error:

Server Error in '/RelayGearStores' Application.
--------------------------------------------------------------------------------

New transaction cannot enlist in the specified transaction
coordinator.
Description: An unhandled exception occurred during the execution of
the current web request. Please review the stack trace for more
information about the error and where it originated in the code.

Exception Details: System.Runtime.InteropServices.COMException: New
transaction cannot enlist in the specified transaction coordinator.

Source Error:


Line 1682: public PurchaseOrder SaveAsOrder()
Line 1683: {
Line 1684: PurchaseOrder purchaseOrder =
this.fieldBasket.SaveAsOrder();
Line 1685: if ((this.fieldBasketErrors.Count == 0) &&
Line 1686: (this.fieldPurchaseErrors.Count == 0))


Source File:
c:\inetpub\wwwroot\relaygearstores\retai
lextensions\components\ordermanagement\t
ransactioncontext.cs
Line: 1684

Stack Trace:


[COMException (0x8004d00a): New transaction cannot enlist in the
specified transaction coordinator. ]
ADODB.ConnectionClass.Open(String ConnectionString, String UserID,
String Password, Int32 Options) +0
Microsoft.CommerceServer.Internal.Common.DBUtil.init(String&
connection_string) +167

[CommerceException: Could not connect to datasource]

Microsoft.CommerceServer.Internal.Common.Util.ThrowCommerceException(String
message, Exception inner, String source) +52
Microsoft.CommerceServer.Internal.Common.DBUtil.init(String&
connection_string) +204

Microsoft.CommerceServer.Interop.Orders. PrivateOrderGroupMtsTxHelperFreeThreaded
.MtsSetup(String
in_User, String in_dsn, IGenID in_GenID, Object&
in_out_OrderGroupData, Int16& in_out_exists_in_databse) +124

Microsoft.CommerceServer.Interop.Orders. PrivateOrderGroupMtsTxHelperFreeThreaded
.SaveAsOrderHelper(Object
in_User, Object in_dsn, Object in_GenID, Object&
in_out_OrderGroupData, Object& loaded_from, Object&
in_out_exists_in_databse, Object SavePrefix, Object&
out_vtOutTrackingNumber) +106

[CommerceException: SaveAsOrderHelper Failed.]

System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage
reqMsg, IMessage retMsg) +264

System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData&
msgData, Int32 type) +877

Microsoft.CommerceServer.Interop.Orders. PrivateOrderGroupMtsTxHelperFreeThreaded
.SaveAsOrderHelper(Object
in_User, Object in_dsn, Object in_GenID, Object&
in_out_OrderGroupData, Object& loaded_from, Object&
in_out_exists_in_databse, Object SavePrefix, Object&
out_vtOutTrackingNumber) +0

Microsoft.CommerceServer.Interop.Orders.OrderGroupFreeThreaded.SaveAsOrder(Object&
vtOutTrackingNumber) +176

[CommerceException: SaveAsOrder Failed.]

Microsoft.CommerceServer.Internal.Common.Util.ThrowCommerceException(String
message, Exception inner, String source) +52

Microsoft.CommerceServer.Interop.Orders.OrderGroupFreeThreaded.SaveAsOrder(Object&
vtOutTrackingNumber) +284
Microsoft.CommerceServer.Runtime.Orders.Basket.SaveAsOrder() +241

[CommerceOrderSystemException: Failed to save basket as an order.]
Microsoft.CommerceServer.Runtime.Orders.Basket.SaveAsOrder() +528
Microsoft.Solutions.Applications.OrderManagement.Cart.SaveAsOrder()
in
c:\inetpub\wwwroot\relaygearstores\retai
lextensions\components\ordermanagement\t
ransactioncontext.cs:1684

Microsoft.Solutions.Applications.RetailExtensions.CheckoutPayment.PurchaseCart()
in
c:\inetpub\wwwroot\RelayGearStores\Retai
lExtensions\CheckoutPayment.aspx.cs:555

Microsoft.Solutions.Applications.RetailExtensions.CheckoutPayment.AcceptChargesButton_Click(Object
sender, EventArgs e) in
c:\inetpub\wwwroot\RelayGearStores\Retai
lExtensions\CheckoutPayment.aspx.cs:575
System.Web.UI.WebControls.Button.OnClick(EventArgs e) +108

System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String
eventArgument) +57
System.Web.UI.Page. RaisePostBackEvent(IPostBackEventHandler

sourceControl, String eventArgument) +18
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData)
+33
System.Web.UI.Page.ProcessRequestMain() +1262


Any ideas?
Thanks,
Chris

Ravi Shankar

2005-09-30, 2:49 am

The "cannot enlist in a distributed transaction" error is because of DTC
configuration. If you're on W2K3 SP1 then you should revisit your DTC
configuration (ensure that Remote Clients is re-enabled on all compters,
inbound & outbound is set (MSCS & SQL)). The link to this is
http://support.microsoft.com/defaul...kb;en-us;899191
--
Ravi Shankar


"cgruber" wrote:

> I have a feeling that this is a database configuration issue, but
> maybe you guys could send me in the right direction.
>
> When I click 'Accept Charges' after all the credit card info is added
> I get the following error:
>
> Server Error in '/RelayGearStores' Application.
> --------------------------------------------------------------------------------
>
> New transaction cannot enlist in the specified transaction
> coordinator.
> Description: An unhandled exception occurred during the execution of
> the current web request. Please review the stack trace for more
> information about the error and where it originated in the code.
>
> Exception Details: System.Runtime.InteropServices.COMException: New
> transaction cannot enlist in the specified transaction coordinator.
>
> Source Error:
>
>
> Line 1682: public PurchaseOrder SaveAsOrder()
> Line 1683: {
> Line 1684: PurchaseOrder purchaseOrder =
> this.fieldBasket.SaveAsOrder();
> Line 1685: if ((this.fieldBasketErrors.Count == 0) &&
> Line 1686: (this.fieldPurchaseErrors.Count == 0))
>
>
> Source File:
> c:\inetpub\wwwroot\relaygearstores\retai
lextensions\components\ordermanagement\t
ransactioncontext.cs
> Line: 1684
>
> Stack Trace:
>
>
> [COMException (0x8004d00a): New transaction cannot enlist in the
> specified transaction coordinator. ]
> ADODB.ConnectionClass.Open(String ConnectionString, String UserID,
> String Password, Int32 Options) +0
> Microsoft.CommerceServer.Internal.Common.DBUtil.init(String&
> connection_string) +167
>
> [CommerceException: Could not connect to datasource]
>
> Microsoft.CommerceServer.Internal.Common.Util.ThrowCommerceException(String
> message, Exception inner, String source) +52
> Microsoft.CommerceServer.Internal.Common.DBUtil.init(String&
> connection_string) +204
>
> Microsoft.CommerceServer.Interop.Orders. PrivateOrderGroupMtsTxHelperFreeThreaded
.MtsSetup(String
> in_User, String in_dsn, IGenID in_GenID, Object&
> in_out_OrderGroupData, Int16& in_out_exists_in_databse) +124
>
> Microsoft.CommerceServer.Interop.Orders. PrivateOrderGroupMtsTxHelperFreeThreaded
.SaveAsOrderHelper(Object
> in_User, Object in_dsn, Object in_GenID, Object&
> in_out_OrderGroupData, Object& loaded_from, Object&
> in_out_exists_in_databse, Object SavePrefix, Object&
> out_vtOutTrackingNumber) +106
>
> [CommerceException: SaveAsOrderHelper Failed.]
>
> System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage
> reqMsg, IMessage retMsg) +264
>
> System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData&
> msgData, Int32 type) +877
>
> Microsoft.CommerceServer.Interop.Orders. PrivateOrderGroupMtsTxHelperFreeThreaded
.SaveAsOrderHelper(Object
> in_User, Object in_dsn, Object in_GenID, Object&
> in_out_OrderGroupData, Object& loaded_from, Object&
> in_out_exists_in_databse, Object SavePrefix, Object&
> out_vtOutTrackingNumber) +0
>
> Microsoft.CommerceServer.Interop.Orders.OrderGroupFreeThreaded.SaveAsOrder(Object&
> vtOutTrackingNumber) +176
>
> [CommerceException: SaveAsOrder Failed.]
>
> Microsoft.CommerceServer.Internal.Common.Util.ThrowCommerceException(String
> message, Exception inner, String source) +52
>
> Microsoft.CommerceServer.Interop.Orders.OrderGroupFreeThreaded.SaveAsOrder(Object&
> vtOutTrackingNumber) +284
> Microsoft.CommerceServer.Runtime.Orders.Basket.SaveAsOrder() +241
>
> [CommerceOrderSystemException: Failed to save basket as an order.]
> Microsoft.CommerceServer.Runtime.Orders.Basket.SaveAsOrder() +528
> Microsoft.Solutions.Applications.OrderManagement.Cart.SaveAsOrder()
> in
> c:\inetpub\wwwroot\relaygearstores\retai
lextensions\components\ordermanagement\t
ransactioncontext.cs:1684
>
> Microsoft.Solutions.Applications.RetailExtensions.CheckoutPayment.PurchaseCart()
> in
> c:\inetpub\wwwroot\RelayGearStores\Retai
lExtensions\CheckoutPayment.aspx.cs:555
>
> Microsoft.Solutions.Applications.RetailExtensions.CheckoutPayment.AcceptChargesButton_Click(Object
> sender, EventArgs e) in
> c:\inetpub\wwwroot\RelayGearStores\Retai
lExtensions\CheckoutPayment.aspx.cs:575
> System.Web.UI.WebControls.Button.OnClick(EventArgs e) +108
>
> System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String
> eventArgument) +57
> System.Web.UI.Page. RaisePostBackEvent(IPostBackEventHandler

> sourceControl, String eventArgument) +18
> System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData)
> +33
> System.Web.UI.Page.ProcessRequestMain() +1262
>
>
> Any ideas?
> Thanks,
> Chris
>
>

cgruber

2005-10-24, 10:38 am

That seemed to do the trick!

Thanks Ravi!

Sponsored Links






Free braindumps | Software forum | Database administration forum

Copyright 2003 - 2008 webservertalk.com