Five New Optimizely Certifications are Here! Validate your expertise and advance your career with our latest certification exams. Click here to find out more

SqlTransaction.ZombieCheck Exception saving cart Optimizely commerce

Vote:
 

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

#267907
Dec 06, 2021 8:45
Vote:
 

Hi, for this type of issue, it might be best to contact developer support service. We need further investigation that might not fit for this forum 

#267910
Dec 06, 2021 9:37
* You are NOT allowed to include any hyperlinks in the post because your account hasn't associated to your company. User profile should be updated.