{"data":{"id":"MDVA-43824","source":"qpt","sourceRef":"magento/quality-patches@1.1.84","title":"Fixes the issue where an error appears on canceling orders with a discount.","categories":["Order/Checkout"],"components":["magento/module-sales-rule"],"origin":"adobe-commerce-support","documentation":{"url":"https://experienceleague.adobe.com/en/docs/commerce-operations/tools/quality-patches-tool/patches-available-in-qpt/v1-1-13/mdva-43824-order-cancellation-action-failed-with-error","path":"help/tools/quality-patches-tool/patches-available-in-qpt/v1-1-13/mdva-43824-order-cancellation-action-failed-with-error.md","blobSha":"06e80724b158140017710721ea88bf1e95ac72a1","description":"Order placed by a logged-in customer cannot be cancelled. The order cancellation action failed with the following error: Zend_Db_Statement_Exception: SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (mer33515_ee24developpbdevelop.salesrule_customer, CONSTRAINT SALESRULE_CUSTOMER_RULE_ID_SEQUENCE_SALESRULE_SEQUENCE_VALUE FOREIGN KEY (rule_id) REFERENCES sequence_salesrule (sequen), query was: INSERT INTO salesrule_customer () VALUES (){code}","stepsToReproduce":"1. Create a sales rule (coupon type is either \"Specific Coupon\" or \"No Coupon\"). 1. Go to the storefront and log in as a customer and add a product to the cart. 1. Go to the cart and apply the cart price rule if the cart price rule has a coupon as \"Specific Coupon\". The cart price rule should be applied successfully. 1. Go to checkout and place the order with any payment method. 1. Go to the Commerce Admin > Sales > Orders. 1. Open the order placed in Step 4. 1. Click on the Cancel button.","introducedInQpt":"1.1.13","createdFor":["2.4.3-p1"],"documentedRange":"2.3.6 - 2.3.7-p3, 2.4.1 - 2.4.4","scheduledFixRelease":"2.4.5"},"files":[{"package":"magento/magento2-base","constraint":">=2.3.6 <=2.3.7-p3 || >=2.4.1 <2.4.4-p12","path":"patches/os/MDVA-43824_2.4.3-p1.patch","blobSha":"65111731e47973fa7d282dbf28c93e737e9a2fdf","url":"https://raw.githubusercontent.com/magento/quality-patches/11d565bdde197b9c7bac859a5698e99098b48457/patches/os/MDVA-43824_2.4.3-p1.patch","thirdParty":false,"modifies":[{"path":"vendor/magento/module-sales-rule/Model/Coupon/Usage/Processor.php","change":"modified","package":"magento/module-sales-rule"}],"packages":["magento/module-sales-rule"],"hasTests":false,"applicableVersions":{"magento-community":["2.4.4-p11","2.4.4-p10","2.4.4-p9","2.4.4-p8","2.4.4-p7","2.4.4-p6","2.4.4-p5","2.4.4-p4","2.4.4-p3","2.4.4-p2","2.4.4-p1","2.4.4","2.4.3-p3","2.4.3-p2","2.4.3-p1","2.4.3","2.4.2-p2","2.4.2-p1","2.4.2","2.4.1-p1","2.4.1","2.3.7-p3","2.3.7-p2","2.3.7-p1","2.3.7","2.3.6-p1","2.3.6"],"magento-commerce":["2.4.4-p11","2.4.4-p10","2.4.4-p9","2.4.4-p8","2.4.4-p7","2.4.4-p6","2.4.4-p5","2.4.4-p4","2.4.4-p3","2.4.4-p2","2.4.4-p1","2.4.4","2.4.3-p3","2.4.3-p2","2.4.3-p1","2.4.3","2.4.2-p2","2.4.2-p1","2.4.2","2.4.1-p1","2.4.1","2.3.7-p3","2.3.7-p2","2.3.7-p1","2.3.7","2.3.6-p1","2.3.6"],"mage-os":[]},"unknownVersions":[],"requires":[],"replacedWith":null,"deprecated":false}],"applicableVersions":{"magento-community":["2.4.4-p11","2.4.4-p10","2.4.4-p9","2.4.4-p8","2.4.4-p7","2.4.4-p6","2.4.4-p5","2.4.4-p4","2.4.4-p3","2.4.4-p2","2.4.4-p1","2.4.4","2.4.3-p3","2.4.3-p2","2.4.3-p1","2.4.3","2.4.2-p2","2.4.2-p1","2.4.2","2.4.1-p1","2.4.1","2.3.7-p3","2.3.7-p2","2.3.7-p1","2.3.7","2.3.6-p1","2.3.6"],"magento-commerce":["2.4.4-p11","2.4.4-p10","2.4.4-p9","2.4.4-p8","2.4.4-p7","2.4.4-p6","2.4.4-p5","2.4.4-p4","2.4.4-p3","2.4.4-p2","2.4.4-p1","2.4.4","2.4.3-p3","2.4.3-p2","2.4.3-p1","2.4.3","2.4.2-p2","2.4.2-p1","2.4.2","2.4.1-p1","2.4.1","2.3.7-p3","2.3.7-p2","2.3.7-p1","2.3.7","2.3.6-p1","2.3.6"],"mage-os":[]},"conditions":null,"requirements":null},"_documentation":"https://magento.watch/api","_description":"Quality patch MDVA-43824 details"}