{"data":{"id":"ACSD-59786","source":"qpt","sourceRef":"magento/quality-patches@1.1.84","title":"Fixes the issue where GraphQL returns an internal server error when trying to get a Quote ID for an expired quote.","categories":["B2B","GraphQL"],"components":["magento/module-quote-graph-ql"],"origin":"adobe-commerce-support","documentation":{"url":"https://experienceleague.adobe.com/en/docs/commerce-operations/tools/quality-patches-tool/patches-available-in-qpt/v1-1-51/acsd-59786-graphql-returns-an-error-when-fetching-a-quote-id-for-an-expired-quote","path":"help/tools/quality-patches-tool/patches-available-in-qpt/v1-1-51/acsd-59786-graphql-returns-an-error-when-fetching-a-quote-id-for-an-expired-quote.md","blobSha":"8c8900e5353caf0f699ce7a1f9741b2b6d4544ca","description":"A GraphQL query returns an error when fetching a quote_id for an expired quote.","stepsToReproduce":"1. Enable Companies and Purchase Orders. * Stores > Configuration > General > B2B Features and set Enable Company to Yes. * Stores > Configuration > General > B2B Features > Order Approval Configuration and set Enable Purchase Orders to Yes. 1. Create a new company and set Enable Purchase Orders to Yes for the same. 1. Create a simple product and assign it to a category. 1. Log in to Storefront using the company Admin account and create a new order using Purchase Order as the payment method. 1. Change the Quote Lifetime (days). * Stores > Configuration > Sales > Checkout > Shopping Cart > Quote Lifetime (days) = 0. 1. Run the command bin/magento c:f. 1. Go to the DB quote_table and change the created_at and updated_at values with one day in the past. 1. Run the command bin/magento cron:run --group=\"sales_clean_quotes. 1. Execute the GraphQL request given below using an authorized token for the Admin who creates the Purchase Order: { customer { purchase_order(uid: \"MQ==\") { quote { id } } } }","introducedInQpt":"1.1.51","createdFor":["2.4.6-p3"],"documentedRange":"2.4.6 - 2.4.7-p3","scheduledFixRelease":"2.4.8"},"files":[{"package":"magento/magento2-base","constraint":">=2.4.6 <2.4.8","path":"patches/os/ACSD-59786_2.4.6-p3.patch","blobSha":"dc39441572b235378e3a883693e8a970b663aa98","url":"https://raw.githubusercontent.com/magento/quality-patches/11d565bdde197b9c7bac859a5698e99098b48457/patches/os/ACSD-59786_2.4.6-p3.patch","thirdParty":false,"modifies":[{"path":"vendor/magento/module-quote-graph-ql/Model/Resolver/MaskedCartId.php","change":"modified","package":"magento/module-quote-graph-ql"}],"packages":["magento/module-quote-graph-ql"],"hasTests":false,"applicableVersions":{"magento-community":["2.4.7-p10","2.4.7-p9","2.4.7-p8","2.4.7-p7","2.4.7-p6","2.4.7-p5","2.4.7-p4","2.4.7-p3","2.4.7-p2","2.4.7-p1","2.4.7","2.4.6-p15","2.4.6-p14","2.4.6-p13","2.4.6-p12","2.4.6-p11","2.4.6-p10","2.4.6-p9","2.4.6-p8","2.4.6-p7","2.4.6-p6","2.4.6-p5","2.4.6-p4","2.4.6-p3","2.4.6-p2","2.4.6-p1","2.4.6"],"magento-commerce":["2.4.7-p10","2.4.7-p9","2.4.7-p8","2.4.7-p7","2.4.7-p6","2.4.7-p5","2.4.7-p4","2.4.7-p3","2.4.7-p2","2.4.7-p1","2.4.7","2.4.6-p15","2.4.6-p14","2.4.6-p13","2.4.6-p12","2.4.6-p11","2.4.6-p10","2.4.6-p9","2.4.6-p8","2.4.6-p7","2.4.6-p6","2.4.6-p5","2.4.6-p4","2.4.6-p3","2.4.6-p2","2.4.6-p1","2.4.6"],"mage-os":[]},"unknownVersions":[],"requires":[],"replacedWith":null,"deprecated":false}],"applicableVersions":{"magento-community":["2.4.7-p10","2.4.7-p9","2.4.7-p8","2.4.7-p7","2.4.7-p6","2.4.7-p5","2.4.7-p4","2.4.7-p3","2.4.7-p2","2.4.7-p1","2.4.7","2.4.6-p15","2.4.6-p14","2.4.6-p13","2.4.6-p12","2.4.6-p11","2.4.6-p10","2.4.6-p9","2.4.6-p8","2.4.6-p7","2.4.6-p6","2.4.6-p5","2.4.6-p4","2.4.6-p3","2.4.6-p2","2.4.6-p1","2.4.6"],"magento-commerce":["2.4.7-p10","2.4.7-p9","2.4.7-p8","2.4.7-p7","2.4.7-p6","2.4.7-p5","2.4.7-p4","2.4.7-p3","2.4.7-p2","2.4.7-p1","2.4.7","2.4.6-p15","2.4.6-p14","2.4.6-p13","2.4.6-p12","2.4.6-p11","2.4.6-p10","2.4.6-p9","2.4.6-p8","2.4.6-p7","2.4.6-p6","2.4.6-p5","2.4.6-p4","2.4.6-p3","2.4.6-p2","2.4.6-p1","2.4.6"],"mage-os":[]},"conditions":{"and":[{"type":"log","path":"var/log/exception.log","match":"Cannot add or update a child row: a foreign key constraint fails *QUOTE_ID_MASK_QUOTE_ID_QUOTE_ENTITY_ID"}]},"requirements":null},"_documentation":"https://magento.watch/api","_description":"Quality patch ACSD-59786 details"}