Episerver Web Content Management System 11.17.0.0 EPiServer Commerce 13.20.0.0
Hello.
My customers Optimizely commerce-solution is doing about 10k orders per day so transaction intensity is quite high.
During a 7 day-period we get about 25-30 of the below errors. I see there is an older thread regarding this from 2014 but its mostly regarding pages(SqlTransaction.ZombieCheck).
For us it occurs during these method calls:(saving cart)
Exception:System.InvalidOperationException: This SqlTransaction has completed; it is no longer usable. at System.Data.SqlClient.SqlTransaction.ZombieCheck() at System.Data.SqlClient.SqlTransaction.Commit() at Mediachase.Data.Provider.TransactionScope.ThreadStaticTransactionScope.Commit() at Mediachase.Data.Provider.TransactionScope.Complete() at Mediachase.Commerce.Orders.PurchaseOrder.AcceptChanges()
Episerver Web Content Management System 11.17.0.0
EPiServer Commerce 13.20.0.0
Hello.
My customers Optimizely commerce-solution is doing about 10k orders per day so transaction intensity is quite high.
During a 7 day-period we get about 25-30 of the below errors. I see there is an older thread regarding this from 2014 but its mostly regarding pages(SqlTransaction.ZombieCheck).
For us it occurs during these method calls:(saving cart)
EPiServer.Commerce.Order.Save(IOrderGroup order);
Mediachase.Commerce.Orders.PurchaseOrder.AcceptChanges()
EPiServer.Commerce.Order.Internal.DefaultOrderRepository.Delete(OrderReference orderLink)
The exception:
Exception:System.InvalidOperationException:
This SqlTransaction has completed; it is no longer usable. at System.Data.SqlClient.SqlTransaction.ZombieCheck()
at System.Data.SqlClient.SqlTransaction.Commit()
at Mediachase.Data.Provider.TransactionScope.ThreadStaticTransactionScope.Commit()
at Mediachase.Data.Provider.TransactionScope.Complete()
at Mediachase.Commerce.Orders.PurchaseOrder.AcceptChanges()
We are using serializableCart.
BR Benedikts Johansons