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 ou
r
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.PrivateOrderGroupMtsTxHelperFreeThre
aded.GenerateTrackingNumber() +41

Microsoft.CommerceServer.Interop.Orders.PrivateOrderGroupMtsTxHelperFreeThre
aded.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.PrivateOrderGroupMtsTxHelperFreeThre
aded.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(O
bject& vtOutTrackingNumber) +176

[CommerceException: SaveAsOrder Failed.]

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

Microsoft.CommerceServer.Interop.Orders.OrderGroupFreeThreaded.SaveAsOrder(O
bject& 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.Ra
isePostBackEvent(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

[ Post a follow-up to this message ]

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(Stri
ng
> bstrCounterName, Int32 cDigits) +0
>
> Microsoft.CommerceServer.Interop.Orders.PrivateOrderGroupMtsTxHelperFreeTh
readed.GenerateTrackingNumber() +41
>
> Microsoft.CommerceServer.Interop.Orders.PrivateOrderGroupMtsTxHelperFreeTh
readed.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.PrivateOrderGroupMtsTxHelperFreeTh
readed.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(Strin
g
> 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) +1
09
>
> 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
>

[ Post a follow-up to this message ]

It looks like the "Counter" table in your <sitename>_commerce DB is corrupte
d
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(Stri
ng
> bstrCounterName, Int32 cDigits) +0
>
> Microsoft.CommerceServer.Interop.Orders.PrivateOrderGroupMtsTxHelperFreeTh
readed.GenerateTrackingNumber() +41
>
> Microsoft.CommerceServer.Interop.Orders.PrivateOrderGroupMtsTxHelperFreeTh
readed.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.PrivateOrderGroupMtsTxHelperFreeTh
readed.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(Strin
g
> 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) +1
09
>
> 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
>

[ Post a follow-up to this message ]

It shouldn't be because I have overwritten my local _commerce DB with the on
e
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 corrup
ted
> or has been dropped.
> --
> Ravi Shankar
>
>
> "MinaY" wrote:
> 

[ Post a follow-up to this message ]