Logic Apps execute a SP withing a forEach and get "Rate limit is exceeded. Try again in X seconds." when run manually. error 429

Question

Hi all,

I have a logic app that basically has 4 ForEach activities and each one is really simple, executes a SP activity withing this forEach and the number of elements that the forEach is processing is from 500 to 50k SP's to be executed in SQL Server and the last forEach actity fails due to 429 error, I've already increased the concurrency value:

"runtimeConfiguration": {
    "concurrency": {
      "repetitions": 50
    }
  }

and once I run the webhook activy from ADF pipelines fails with an InternalServer error, is there something else that I need to check?

Thanks in advance.

Answer 1

As the message states, your issue is related to Logic Apps throttling since I understood that you are exceeding the throughput limits of Logic Apps.

You can identify this by looking under the Metrics tab in Azure portal with Action Throttled and Trigger Throttled events.

Modifying the retry policy Time Interval is can be an option to fix this issue.

https://docs.microsoft.com/en-us/powerapps/developer/common-data-service/api-limits

Check the workarounds here :

https://medium.com/@derek_li/logic-apps-and-throttling-8096362dfb1a