Magento 2.4.0: exception during B2B 1.2.0 install

This article provides a fix for a Magento known issue for an exception thrown during setup:upgrade when installing B2B 1.2.0.

Affected products and versions

• Magento Commerce version 2.4.0
• Magento Commerce Cloud version 2.4.0
• B2B version 1.2.0

Issue

Steps to reproduce

1. Install Magento with more than 1 store created.
2. Create an additional store.
3. Install B2B 1.2.0.

The upgrade of any B2B instance with more than 1 store from a version below 1.2.0 or Magento instance below 2.4.0, is also affected.

Expected result

B2B 1.2.0 installs.

Actual result

When setup:upgrade runs to install B2B 1.2.0, this error appears on the PurchaseOrder module:

Module 'Magento_PurchaseOrder':
  Unable to apply data patch Magento\PurchaseOrder\Setup\Patch\Data\InitPurchaseOrderSalesSequence
  for module Magento_PurchaseOrder. Original exception message: DDL statements
  are not allowed in transactions

Solution

Apply the patch provided in this article.

Patch

The patch is attached to this article, available for download in both .composer and .git formats.

To download it, scroll down to the end of the article and click the file name, or click one of the following links:

• Composer patch B2B-716_composer.patch
• Git patch B2B-716_git.patch

How to apply a patch

Composer patch

See How to apply a composer patch provided by Magento for composer patch instructions.

Git patch

• See DevDocs' Apply patches for git patch instructions for Magento Commerce Cloud.
• See DevDocs' Applying patches: Custom patches for git patch instructions for Magento Commerce.

Related reading

• Magento 2.4.0 known issue: raw message data display on storefront
• Magento 2.4.0 known issue: Export Tax Rates does not work
• Magento 2.4.0 known issue: Braintree payment methods do not show up in Multiple Addresses checkout
• Magento 2.4.0 known issue: Error message selecting local payment method displayed for some countries during checkout
• Magento 2.4.0 known issue: 404 error when removing rewards points on multi-shipping checkout
• Magento 2.4.0 known issue: orders display error
• Magento 2.4.0 B2B Admin can't add configurable product to quote
• Shipping labels creation known issue in Magento 2.4.0
• Magento 2.4.0 known issue - refresh on Customer's Activities does not work
• Magento 2.4.0 known issue: “Add selections to my cart” button does not work