We are using hybris Commerce Suite and have the issue that there are locks on the discounts table when a lot of people try to use the same PromotionVoucher.
Observed are a lot of UPDATE statements like the one below:
UPDATE discounts SET hjmpTS = 30790 ,modifiedTS='2017-12-01 13:33:16.278' WHERE PK = 8797208084528
The PK is always the same, it’s the PromotionVoucher. Basically these statements just set the modifiedTS. Sometimes these statements get stuck and accumulate on the DB. Some other actions on the storefront are held up waiting to acquire the lock. This for example blocks all further checkouts involving the specific PromotionVoucher.
Any hybris version.
SAP Commerce 1811 ; SAP Hybris Commerce 1808 ; SAP Hybris Commerce 6.0 ; SAP Hybris Commerce 6.1 ; SAP Hybris Commerce 6.2 ; SAP Hybris Commerce 6.3 ; SAP Hybris Commerce 6.4 ; SAP Hybris Commerce 6.5 ; SAP Hybris Commerce 6.6 ; SAP Hybris Commerce 6.7
- time stamp
- blocked session
About this pageThis is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).
Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.