March 30, 2009 at 1:08 pm
Server.GetLastError().ToString():
System.Web.HttpUnhandledException: Exception of type System.Web.HttpUnhandledException was thrown. ---> Microsoft.CommerceServer.Runtime.Orders.CommerceOrderSystemException: Failed to save basket as an order. ---> Microsoft.CommerceServer.Runtime.CommerceException: SaveAsOrder Failed. ---> Microsoft.CommerceServer.Runtime.CommerceException: SaveAsOrderHelper Failed. ---> Microsoft.CommerceServer.Runtime.CommerceException: Could not connect to datasource ---> System.Runtime.InteropServices.COMException (0x8004D00A): New transaction cannot enlist in the specified transaction coordinator. at ADODB.ConnectionClass.Open(String ConnectionString, String UserID, String Password, Int32 Options) at Microsoft.CommerceServer.Internal.Common.DBUtil.init(String& connection_string) --- End of inner exception stack trace --- at Microsoft.CommerceServer.Internal.Common.Util.ThrowCommerceException(String message, Exception inner, String source) at Microsoft.CommerceServer.Internal.Common.DBUtil.init(String& connection_string) at 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) at 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) --- End of inner exception stack trace --- Server stack trace: at Microsoft.CommerceServer.Internal.Common.Util.ThrowCommerceException(String message, Exception inner, String source) at 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) at System.Runtime.Remoting.Messaging.Message.Dispatch(Object target, Boolean fExecuteInContext) at System.Runtime.Remoting.Messaging.StackBuilderSink.SyncProcessMessage(IMessage msg, Int32 methodPtr, Boolean fExecuteInContext) Exception rethrown at [0]: at System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg) at System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type) at 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) at Microsoft.CommerceServer.Interop.Orders.OrderGroupFreeThreaded.SaveAsOrder(Object& vtOutTrackingNumber) --- End of inner exception stack trace --- at Microsoft.CommerceServer.Internal.Common.Util.ThrowCommerceException(String message, Exception inner, String source) at Microsoft.CommerceServer.Interop.Orders.OrderGroupFreeThreaded.SaveAsOrder(Object& vtOutTrackingNumber) at Microsoft.CommerceServer.Runtime.Orders.Basket.SaveAsOrder() --- End of inner exception stack trace --- at Microsoft.CommerceServer.Runtime.Orders.Basket.SaveAsOrder() at CustomDirect.Commerce.Orders.OrderForm.SaveToReceipt() at CustomDirect.Commerce.Orders.CDICommerceManager.SaveToReceipt(IOrderForm orderForm) at CustomDirect.styles.module.reorder_payment_review_content.ibnCompletePurchase_Click(Object sender, ImageClickEventArgs e) at System.Web.UI.WebControls.ImageButton.OnClick(ImageClickEventArgs e) at System.Web.UI.WebControls.ImageButton.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) at System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) at System.Web.UI.Page.ProcessRequestMain() --- End of inner exception stack trace --- at System.Web.UI.Page.HandleError(Exception e) at System.Web.UI.Page.ProcessRequestMain() at System.Web.UI.Page.ProcessRequest() at System.Web.UI.Page.ProcessRequest(HttpContext context) at System.Web.CallHandlerExecutionStep.System.Web.HttpApplication+IExecutionStep.Execute() at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)
Server.GetLastError().InnerException.ToString():
Microsoft.CommerceServer.Runtime.Orders.CommerceOrderSystemException: Failed to save basket as an order. ---> Microsoft.CommerceServer.Runtime.CommerceException: SaveAsOrder Failed. ---> Microsoft.CommerceServer.Runtime.CommerceException: SaveAsOrderHelper Failed. ---> Microsoft.CommerceServer.Runtime.CommerceException: Could not connect to datasource ---> System.Runtime.InteropServices.COMException (0x8004D00A): New transaction cannot enlist in the specified transaction coordinator. at ADODB.ConnectionClass.Open(String ConnectionString, String UserID, String Password, Int32 Options) at Microsoft.CommerceServer.Internal.Common.DBUtil.init(String& connection_string) --- End of inner exception stack trace --- at Microsoft.CommerceServer.Internal.Common.Util.ThrowCommerceException(String message, Exception inner, String source) at Microsoft.CommerceServer.Internal.Common.DBUtil.init(String& connection_string) at 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) at 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) --- End of inner exception stack trace --- Server stack trace: at Microsoft.CommerceServer.Internal.Common.Util.ThrowCommerceException(String message, Exception inner, String source) at 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) at System.Runtime.Remoting.Messaging.Message.Dispatch(Object target, Boolean fExecuteInContext) at System.Runtime.Remoting.Messaging.StackBuilderSink.SyncProcessMessage(IMessage msg, Int32 methodPtr, Boolean fExecuteInContext) Exception rethrown at [0]: at System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg) at System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type) at 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) at Microsoft.CommerceServer.Interop.Orders.OrderGroupFreeThreaded.SaveAsOrder(Object& vtOutTrackingNumber) --- End of inner exception stack trace --- at Microsoft.CommerceServer.Internal.Common.Util.ThrowCommerceException(String message, Exception inner, String source) at Microsoft.CommerceServer.Interop.Orders.OrderGroupFreeThreaded.SaveAsOrder(Object& vtOutTrackingNumber) at Microsoft.CommerceServer.Runtime.Orders.Basket.SaveAsOrder() --- End of inner exception stack trace --- at Microsoft.CommerceServer.Runtime.Orders.Basket.SaveAsOrder() at CustomDirect.Commerce.Orders.OrderForm.SaveToReceipt() at CustomDirect.Commerce.Orders.CDICommerceManager.SaveToReceipt(IOrderForm orderForm) at CustomDirect.styles.module.reorder_payment_review_content.ibnCompletePurchase_Click(Object sender, ImageClickEventArgs e) at System.Web.UI.WebControls.ImageButton.OnClick(ImageClickEventArgs e) at System.Web.UI.WebControls.ImageButton.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) at System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) at System.Web.UI.Page.ProcessRequestMain()
Server.GetLastError().StackTrace.ToString():
at System.Web.UI.Page.HandleError(Exception e) at System.Web.UI.Page.ProcessRequestMain() at System.Web.UI.Page.ProcessRequest() at System.Web.UI.Page.ProcessRequest(HttpContext context) at System.Web.CallHandlerExecutionStep.System.Web.HttpApplication+IExecutionStep.Execute() at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)
Server.GetLastError().TargetSite.ToString():
Boolean HandleError(System.Exception)
Server.GetLastError().Message.ToString():
Exception of type System.Web.HttpUnhandledException was thrown.
Server IP#:
March 30, 2009 at 1:14 pm
Not being a CommerceServer expert, what I saw in one of the errors indicated that it may have lost connection to the database server.
March 30, 2009 at 1:17 pm
Looks like you either have a connection error, or possibly your DTC process is down:
Microsoft.CommerceServer.Runtime.CommerceException: [highlight=#ffff11]Could not connect to datasource [/highlight]---> System.Runtime.InteropServices.COMException (0x8004D00A): [highlight=#ffff11]New transaction cannot enlist in the specified transaction coordinator[/highlight]. at ADODB.ConnectionClass.Open(String ConnectionString, String UserID, String Password, Int32 Options) at
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
March 30, 2009 at 1:23 pm
What could be a reason for it?
March 30, 2009 at 1:28 pm
Oh man, thousands... network connectivity, security, service shut down, changes to connection strings... Those are just the easy ones. It could be client configuration changes... It's really hard to say.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
March 30, 2009 at 1:32 pm
Could this be a SQL Server database? What is your suggestion that I should do? Our web sides all of them are failing as soon as people checking out the purchase and customers can't make a purchase.
March 30, 2009 at 1:35 pm
It could be the database server, it could be your web server. You are going to have to do some troubling shooting to determine what the problem is. Unfortunately, we can't do that for you from where we are.
March 30, 2009 at 1:38 pm
Thank you for the advice. I am asking what I need to check from database server. Thank you
March 30, 2009 at 1:57 pm
Open a profiler on your Database server, and then try to go to your website to make order, and see whether your Order will hit your database.
If nothing goes into your DB, then there is something between the webserver and your DB going wrong. check your SQL error log and see whether there is any login failure in case your webclient could not reach into your DB.
March 30, 2009 at 1:59 pm
I'll chime in, can you connect to the database server from another application like SSMS?
It looks like a similar issue with a resolution can be found here
I found the link with this google search
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 10 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply