Skip to main content

KI-110

40+ workflow task assignees hit SOQL query limits

Created date

12/11/2023

Updated date

04/10/2024

Status

Done

Related work item(s)

MPP-2124, PLTFM-2462

Description

When workflow tasks are assigned to 40 or more users, the email builder that Komodo Publications Planning provides out of the box (PP_TaskNotificationEmailBuilder) hits the SOQL query limits and causes the "Too many SOQL queries" error message to appear. This is because the OOTB email builder runs several queries for each task assignee to check for permissions and attachments.

Affects version(s)

Fall '23

Impacted capabilities

N/A

Steps to reproduce

  1. Start a workflow on a document.

  2. Assign the workflow tasks to a total of 40 or more users. (For example, you can assign a single task to 40 users or you can assign one task to 20 users and then assign another task to another 20 users.)

The "Too many SOQL queries" error message will appear.

Workaround

Create a custom email builder to use in place of the OOTB email builder. The custom email builder should be configured so that it uses the PP Task Assignment (PP_Task_Assignment) metadata record of the Document System Event Notification (mvn__CM_Document_System_Event_Notification__mdt) custom metadata type.

Fix version

Spring '24

Resolution notes

N/A