Hello,
I have a flow scheduled to run nightly which was working well up to mid last week. Now I am encountering a flow error when the handful of the records have an update attempted:
Error element Update_Contact (FlowRecordUpdate).
The flow tried to update these records: null. This error occurred: CANNOT_INSERT_UPDATE_ACTIVATE_ENTITY: hed.TDTM_Contact: System.LimitException: hed:Too many SOQL queries: 101. You can look up ExceptionCode values in the SOAP API Developer Guide.
The error occurred on the last step of the flow which is an update to the contact that started the flow. From looking at the flow and results of the flow, this looks to only be an issue for a handful of records. The rest are updating as expected.
Since the issue is not widespread, it seems to be an issue with the records within the flow error. Nothing currently stands out for these records. Is there something within the Contact TDTM that may be causing this?
Thank you @Nick Lindberg -- we recently restructured some code around the preferred email functionality as it was getting pretty hairy. I'm chatting with my lead dev about what might have changed. We didn't change functionality at all, but did shuffle some things around.
