SaveAsOrder failed with "Cursor operation conflict" error
Windows Server Forum Index Windows Server
Server discussion on Windows platform.
 
 FAQFAQ   MemberlistMemberlist     RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 
 
Google
 
Web winserverhelp.com
SaveAsOrder failed with "Cursor operation conflict" error

 
Post new topic   Reply to topic    Windows Server Forum Index -> Commerce Server
Author Message
MinaY
Guest
Posted: Wed Sep 21, 2005 12:51 am    Post subject: SaveAsOrder failed with "Cursor operation conflict" error Reply with quote
Hi,
I encounter this error during checkout stage. This happened after I added a
field to OrderFormHeader table. Yet this error only happens in my personal
development environment which uses a local database, it doesn't happen in our
test environment. So I tried to overwrite my local database with the test
database, but the problem still exists. If I change my commerce server
manager to use the test database, this error would disappear. Also search on
internet and cannot find any help. Please help!

Here is the error detail:

[COMException (0x80040e23): Cursor operation conflict]
Microsoft.CommerceServer.Interop.Orders.GenIDClass.GetCounterValue(String
bstrCounterName, Int32 cDigits) +0

Microsoft.CommerceServer.Interop.Orders.PrivateOrderGroupMtsTxHelperFreeThreaded.GenerateTrackingNumber() +41

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) +726

[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) +288
Microsoft.CommerceServer.Runtime.Orders.Basket.SaveAsOrder() +241

[CommerceOrderSystemException: Failed to save basket as an order.]
Microsoft.CommerceServer.Runtime.Orders.Basket.SaveAsOrder() +530
Microchip.BuyMicrochip.CheckoutStep004.imgbtnPlaceOrder_Click(Object
sender, ImageClickEventArgs e) in F:\Checkout.aspx.cs:1093
System.Web.UI.WebControls.ImageButton.OnClick(ImageClickEventArgs e) +109

System.Web.UI.WebControls.ImageButton.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +69
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler
sourceControl, String eventArgument) +18
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33
System.Web.UI.Page.ProcessRequestMain() +1262
Back to top
Wyatt Preul
Guest
Posted: Wed Sep 21, 2005 6:21 am    Post subject: RE: SaveAsOrder failed with "Cursor operation conflict" erro Reply with quote
Verify that your local database is setup with the same permissions as the
test environment's database.

"MinaY" wrote:

Quote:
Hi,
I encounter this error during checkout stage. This happened after I added a
field to OrderFormHeader table. Yet this error only happens in my personal
development environment which uses a local database, it doesn't happen in our
test environment. So I tried to overwrite my local database with the test
database, but the problem still exists. If I change my commerce server
manager to use the test database, this error would disappear. Also search on
internet and cannot find any help. Please help!

Here is the error detail:

[COMException (0x80040e23): Cursor operation conflict]
Microsoft.CommerceServer.Interop.Orders.GenIDClass.GetCounterValue(String
bstrCounterName, Int32 cDigits) +0

Microsoft.CommerceServer.Interop.Orders.PrivateOrderGroupMtsTxHelperFreeThreaded.GenerateTrackingNumber() +41

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) +726

[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) +288
Microsoft.CommerceServer.Runtime.Orders.Basket.SaveAsOrder() +241

[CommerceOrderSystemException: Failed to save basket as an order.]
Microsoft.CommerceServer.Runtime.Orders.Basket.SaveAsOrder() +530
Microchip.BuyMicrochip.CheckoutStep004.imgbtnPlaceOrder_Click(Object
sender, ImageClickEventArgs e) in F:\Checkout.aspx.cs:1093
System.Web.UI.WebControls.ImageButton.OnClick(ImageClickEventArgs e) +109

System.Web.UI.WebControls.ImageButton.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +69
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler
sourceControl, String eventArgument) +18
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33
System.Web.UI.Page.ProcessRequestMain() +1262
Back to top
MinaY
Guest
Posted: Wed Sep 21, 2005 4:51 pm    Post subject: RE: SaveAsOrder failed with "Cursor operation conflict" erro Reply with quote
It shouldn't be because I have overwritten my local _commerce DB with the one
that works. Counter table should be ok. SQL Profiler also indicates the
counter for "Order Tracking" is actaully returned correctly.

"Ravi Shankar" wrote:

Quote:
It looks like the "Counter" table in your <sitename>_commerce DB is corrupted
or has been dropped.
--
Ravi Shankar


"MinaY" wrote:

Hi,
I encounter this error during checkout stage. This happened after I added a
field to OrderFormHeader table. Yet this error only happens in my personal
development environment which uses a local database, it doesn't happen in our
test environment. So I tried to overwrite my local database with the test
database, but the problem still exists. If I change my commerce server
manager to use the test database, this error would disappear. Also search on
internet and cannot find any help. Please help!

Here is the error detail:

[COMException (0x80040e23): Cursor operation conflict]
Microsoft.CommerceServer.Interop.Orders.GenIDClass.GetCounterValue(String
bstrCounterName, Int32 cDigits) +0

Microsoft.CommerceServer.Interop.Orders.PrivateOrderGroupMtsTxHelperFreeThreaded.GenerateTrackingNumber() +41

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) +726

[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) +288
Microsoft.CommerceServer.Runtime.Orders.Basket.SaveAsOrder() +241

[CommerceOrderSystemException: Failed to save basket as an order.]
Microsoft.CommerceServer.Runtime.Orders.Basket.SaveAsOrder() +530
Microchip.BuyMicrochip.CheckoutStep004.imgbtnPlaceOrder_Click(Object
sender, ImageClickEventArgs e) in F:\Checkout.aspx.cs:1093
System.Web.UI.WebControls.ImageButton.OnClick(ImageClickEventArgs e) +109

System.Web.UI.WebControls.ImageButton.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +69
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler
sourceControl, String eventArgument) +18
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33
System.Web.UI.Page.ProcessRequestMain() +1262
Back to top
Ravi Shankar
Guest
Posted: Wed Sep 21, 2005 4:51 pm    Post subject: RE: SaveAsOrder failed with "Cursor operation conflict" erro Reply with quote
It looks like the "Counter" table in your <sitename>_commerce DB is corrupted
or has been dropped.
--
Ravi Shankar


"MinaY" wrote:

Quote:
Hi,
I encounter this error during checkout stage. This happened after I added a
field to OrderFormHeader table. Yet this error only happens in my personal
development environment which uses a local database, it doesn't happen in our
test environment. So I tried to overwrite my local database with the test
database, but the problem still exists. If I change my commerce server
manager to use the test database, this error would disappear. Also search on
internet and cannot find any help. Please help!

Here is the error detail:

[COMException (0x80040e23): Cursor operation conflict]
Microsoft.CommerceServer.Interop.Orders.GenIDClass.GetCounterValue(String
bstrCounterName, Int32 cDigits) +0

Microsoft.CommerceServer.Interop.Orders.PrivateOrderGroupMtsTxHelperFreeThreaded.GenerateTrackingNumber() +41

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) +726

[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) +288
Microsoft.CommerceServer.Runtime.Orders.Basket.SaveAsOrder() +241

[CommerceOrderSystemException: Failed to save basket as an order.]
Microsoft.CommerceServer.Runtime.Orders.Basket.SaveAsOrder() +530
Microchip.BuyMicrochip.CheckoutStep004.imgbtnPlaceOrder_Click(Object
sender, ImageClickEventArgs e) in F:\Checkout.aspx.cs:1093
System.Web.UI.WebControls.ImageButton.OnClick(ImageClickEventArgs e) +109

System.Web.UI.WebControls.ImageButton.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +69
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler
sourceControl, String eventArgument) +18
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33
System.Web.UI.Page.ProcessRequestMain() +1262
Back to top
 
Post new topic   Reply to topic    Windows Server Forum Index -> Commerce Server All times are GMT
Page 1 of 1

 
 You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum




New Topics Powered by phpBB