Windows Server

cgruber · Guest

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

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

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

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

Exception Details: System.Runtime.InteropServices.COMException: Ne
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\retailextensions\components\ordermanagement\transactioncontext.c
Line: 1684

Stack Trace:

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

[CommerceException: Could not connect to datasource

Microsoft.CommerceServer.Internal.Common.Util.ThrowCommerceException(Strin
message, Exception inner, String source) +5
Microsoft.CommerceServer.Internal.Common.DBUtil.init(String
connection_string) +20

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

Microsoft.CommerceServer.Interop.Orders.PrivateOrderGroupMtsTxHelperFreeThreaded.SaveAsOrderHelper(Objec
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) +10

[CommerceException: SaveAsOrderHelper Failed.

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

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

Microsoft.CommerceServer.Interop.Orders.PrivateOrderGroupMtsTxHelperFreeThreaded.SaveAsOrderHelper(Objec
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) +

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

[CommerceException: SaveAsOrder Failed.

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

Microsoft.CommerceServer.Interop.Orders.OrderGroupFreeThreaded.SaveAsOrder(Object
vtOutTrackingNumber) +28
Microsoft.CommerceServer.Runtime.Orders.Basket.SaveAsOrder() +24

[CommerceOrderSystemException: Failed to save basket as an order.
Microsoft.CommerceServer.Runtime.Orders.Basket.SaveAsOrder() +52
Microsoft.Solutions.Applications.OrderManagement.Cart.SaveAsOrder(
i
c:\inetpub\wwwroot\relaygearstores\retailextensions\components\ordermanagement\transactioncontext.cs:168

Microsoft.Solutions.Applications.RetailExtensions.CheckoutPayment.PurchaseCart(
i
c:\inetpub\wwwroot\RelayGearStores\RetailExtensions\CheckoutPayment.aspx.cs:55

Microsoft.Solutions.Applications.RetailExtensions.CheckoutPayment.AcceptChargesButton_Click(Objec
sender, EventArgs e) i
c:\inetpub\wwwroot\RelayGearStores\RetailExtensions\CheckoutPayment.aspx.cs:57
System.Web.UI.WebControls.Button.OnClick(EventArgs e) +10

System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(Strin
eventArgument) +5
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 · Guest

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/default.aspx?scid=kb;en-us;899191
--
Ravi Shankar

cgruber · Guest

That seemed to do the trick

Thanks Ravi

	Windows Server Forum Index -> Commerce Server	All times are GMT
Page 1 of 1