|
Home > Archive > Commerce Server General > January 2006 > Basket Errors
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]
|
|
| TechMate 2006-01-16, 5:54 pm |
| I get these errors at least 10 times every week. Somehow the GUID generated
in the BasketGroup table for commerce sites is duplicated. Is there way to
have a checkpoint or trigger to avoid these errors.
System.Runtime.InteropServices.COMException (0x80040E2F): Cannot insert
duplicate key row in object 'BasketGroup' with unique index
'BasketGroup_ind'.[23000] The statement has been terminated.[01000] Cannot
insert duplicate key row in object 'BasketGroup' with unique index
'BasketGroup_ind'. at
Microsoft.CommerceServer.Interop.Orders.DBStorageClass.InsertData(Object
vtReserved, Object pdispData) at
Microsoft.CommerceServer.Interop.Orders.MTSHelperImpl.SaveDictToTable(Int16&
bExists, IDictionary& dict, String& table, String& key, Object& exception,
Object& exception2, DBStorage& dbs, Boolean& bReinitializeDBS, String&
SavePrefix, String& dsn, String& userid) at
Microsoft.CommerceServer.Interop.Orders.OrderGroupFreeThreaded.SaveFlat(LoadedFromState
my_save_to) at
Microsoft.CommerceServer.Interop.Orders.OrderGroupFreeThreaded.SaveAsBasket()
| |
| Ravi Shankar 2006-01-23, 6:02 pm |
| Hi Techmate,
I remember some time bck there was a support KB issued which seemed to tie
the error you're getting with a tearing down of the COM+ session... the same
article also said something about how to control the frequency with which the
COM+ sessions are torn down.
If you can catch this error in code and retry the OP does it give this error
again ?
--
Ravi Shankar
"TechMate" wrote:
> I get these errors at least 10 times every week. Somehow the GUID generated
> in the BasketGroup table for commerce sites is duplicated. Is there way to
> have a checkpoint or trigger to avoid these errors.
>
> System.Runtime.InteropServices.COMException (0x80040E2F): Cannot insert
> duplicate key row in object 'BasketGroup' with unique index
> 'BasketGroup_ind'.[23000] The statement has been terminated.[01000] Cannot
> insert duplicate key row in object 'BasketGroup' with unique index
> 'BasketGroup_ind'. at
> Microsoft.CommerceServer.Interop.Orders.DBStorageClass.InsertData(Object
> vtReserved, Object pdispData) at
> Microsoft.CommerceServer.Interop.Orders.MTSHelperImpl.SaveDictToTable(Int16&
> bExists, IDictionary& dict, String& table, String& key, Object& exception,
> Object& exception2, DBStorage& dbs, Boolean& bReinitializeDBS, String&
> SavePrefix, String& dsn, String& userid) at
> Microsoft.CommerceServer.Interop.Orders.OrderGroupFreeThreaded.SaveFlat(LoadedFromState
> my_save_to) at
> Microsoft.CommerceServer.Interop.Orders.OrderGroupFreeThreaded.SaveAsBasket()
|
|
|
|
|