ACSD-47027: slow query B2B [!UICONTROL CompanyRole] [!DNL GraphQL] update

The ACSD-47027 patch solves the issue where the slow query B2B [!UICONTROL CompanyRole] [!DNL GraphQL] update does not work as expected. This patch is available when the [!DNL Quality Patches Tool (QPT)] 1.1.23 is installed. The patch ID is ACSD-47027. Please note that the issue is scheduled to be fixed in Adobe Commerce 2.4.6.

Affected products and versions

The patch is created for Adobe Commerce version:

• Adobe Commerce (all deployment methods) 2.4.2-p1

Compatible with Adobe Commerce versions:

• Adobe Commerce (all deployment methods) 2.4.2 - 2.4.5-p1

Issue

The slow query B2B [!UICONTROL CompanyRole] [!DNL GraphQL] update does not work as expected.

Prerequisites:

Install the B2B module.

Steps to reproduce:

1. In the Adobe Commerce Admin, go to [!UICONTROL Stores] > [!UICONTROL Settings] > [!UICONTROL Configurations] > [!UICONTROL B2B Features] and set [!UICONTROL Enable Company] to Yes.

2. Go to the frontend and create a company.

3. After you log in as a company user, go to [!UICONTROL My Account] > [!UICONTROL Roles and Permissions] and add a new role.

4. Enable [!UICONTROL dev] query log using bin/magento dev:que:enab.

5. Now send the below [!DNL GraphQL] request (id is the [!UICONTROL base64] encoded role id):

   
   mutation {
   updateCompanyRole(
      input: {
         id: "Mg=="
         permissions: [
         "Magento_Company::view"
         "Magento_Company::view_account"
         "Magento_Company::user_management"
         "Magento_Company::roles_view"
        ]
      }
    ) {
      role {
         id
     name
   
     permissions {
     id
   
     text
   
     children {
        id
   
        text
   
        children {
           id
   
           text
         }
       }
     }
   }
   
   }
   }
   

6. Check the query log.

7. You can see that the above query is executed. This query is executed in app/code/Magento/CompanyGraphQl/Model/Company/Role/ValidateRole.php::validateResources.

Expected results:

The app/code/Magento/CompanyGraphQl/Model/Company/Role/ValidateRole.php::validateResources needs to be optimized to avoid loading all the data available in the [!UICONTROL company_permissions] DB table.

Actual results:

Adobe Commerce executes a query without any filter. When there are a large number of records, it takes a lot of time for Adobe Commerce to prepare the data collection.

Apply the patch

To apply individual patches, use the following links depending on your deployment method:

• Adobe Commerce or Magento Open Source on-premises: [!DNL Quality Patches Tool] > Usage in the [!DNL Quality Patches Tool] guide.
• Adobe Commerce on cloud infrastructure: Upgrades and Patches > Apply Patches in our developer documentation.

Related reading

To learn more about [!DNL Quality Patches Tool], refer to:

• [!DNL Quality Patches Tool] released: a new tool to self-serve quality patches in our support knowledge base.
• Check if patch is available for your Adobe Commerce issue using [!DNL Quality Patches Tool] in our support knowledge base.

For info about other patches available in QPT, refer to [!DNL Quality Patches Tool]: Search for patches in the [!DNL Quality Patches Tool] guide.