|
Home > Archive > Commerce Server General > September 2005 > SaveAsOrder failed with "Cursor operation conflict" 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 |
SaveAsOrder failed with "Cursor operation conflict" error
|
|
|
| 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
| |
| Wyatt Preul 2005-09-20, 8:48 pm |
| Verify that your local database is setup with the same permissions as the
test environment's database.
"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
>
| |
| Ravi Shankar 2005-09-21, 5:52 pm |
| 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
>
| |
|
| 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:
[vbcol=seagreen]
> It looks like the "Counter" table in your <sitename>_commerce DB is corrupted
> or has been dropped.
> --
> Ravi Shankar
>
>
> "MinaY" wrote:
>
|
|
|
|
|