Try our conversational search powered by Generative AI!

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.