| 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 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 |