0

We have an 'after record is created or updated' record triggered flow on Case, I have this flow to update the Case->AccountId with Case->Contact->AccountId.

Attached screenshot of the flow, and a screenshot of the issue element where the flow hits the limit error:

Flow

Flow-Element

Error Occurred: The flow tried to update these records: null. This error occurred: LIMIT_EXCEEDED: System.LimitException: Too many query rows: 50001. You can look up ExceptionCode values in the SOAP API Developer Guide.

This limit is hitting, while we receive Email-to-Case requests specifically from one email: [email protected] For the rest of the cases, it is working fine.

I am not sure, but just for confirmation is this issue because of:

Email bounced. Update the email address and try

enter image description here

This error suddenly started on 2-Dec-2023. Before that, it was working fine.

3
  • Looks like recursion ! If you are updating the fields on same record which is triggering the flow, then why its a after save? It should be Fast field update (Before save) right? Dec 11, 2023 at 13:41
  • Hi @VivekM, Thank you for your comment. Actually, this flow was converted from Process Builder. I was under the impression that the contact allocation to Case would be after Case creation in Email-to-Case and I may not get ContactId in the Fast Field Update, so I did not change it to the Fast Field Update. Now I changed it and it is working. But I am still surprised, this element can reach this limit! Recursion can lead to DML, SOQL limit, but the Update element with triggered record can hit Too many query rows limit of 50001! Specifically, hitting this limit for one service & supplied email.
    – herr
    Dec 11, 2023 at 17:47
  • Will have to check more on the data to see why this is happening only for one email domain. 50k limit is an overall per-transaction limit, please check if there is any other trigger or flow on the same object. I have added the same as answer, please mark the answer as right if it helped you 🙂 Thanks Dec 11, 2023 at 17:59

1 Answer 1

1

As mentioned, If you are updating the fields on same record which is triggering the flow, then you should use Fast field update (Before save). Here the after save flow is causing recursion and causing to hit limits.

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .