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(Load
edFromState
my_save_to) at
Microsoft.CommerceServer.Interop.Orders.OrderGroupFreeThreaded.SaveAsBasket(
)

[ Post a follow-up to this message ]

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 th
e
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:
[vbcol=seagreen]
> I get these errors at least 10 times every week. Somehow the GUID generate
d
> 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(Int1
6&
> 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(Lo
adedFromState
> my_save_to) at
> Microsoft.CommerceServer.Interop.Orders.OrderGroupFreeThreaded.SaveAsBasket()[/vbc
ol]

[ Post a follow-up to this message ]