Failed HTTP request inside ApplyToEach is taking 24 to complete, how i can improve this

[johnjohn123]

I have a Send Http Request action which send POST http request to a webhook url:-

https://******.my.salesforce-sites.com/sharepoint/services/*******

now incase the url return 200 the request will take less than 30 seconds to complete, but in case there is an internal error returned from the webhook the send http request will do 8 retires and will take around 24 minutes to complete the current ApplyToEach iteration.. so why this is happening and how we can reduce the time in case of failure?

Here is a screen shot of a failed Http Request, showing the time it took to complete (24 minutes) and the number of retries it did (8 retries):-

here is the send http request, which does not have authentication and uses the Post request, as follow:-

Thanks

[FLMike]

Hi,

Solving unfortunately we would need to dig in more, but you had 2 problems.

1. The call failing (can't help with the webhook, well I could but thats a different forum hehe)

2. The time it runs if failures

To fix the time issue (which BTW it appears someone CHANGED the default retries to 8 because its not that many by default.

Steps

1. Click the ... on the HTTP Connector

2. Click Settings

3. Look at the Retry Policy

Its either going to say Default (which is 4), or it will say a Number (manually typed), or some other defined Policy.

Reduce the retries to something lower and your time will go down significantly.

Cheers
If you like my answer, please Mark it as Resolved, and give it a thumbs up, so it can help others
Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey

[johnjohn123]

@FLMike I have not defined any custom setting for the Send Http request action, here is the full settings:-

so not sure why it is doing 8 retries instead of 4?

also do you think that the delay is been caused by the web hook? as waiting for 24 minutes is really too much

[FLMike]

The only way I know how is if someone changed the Default policy.

Even if you had an Apply to Each, i would only expect 4.

I'd try to lower it to say 1 or 2 tops and verify if it only does the 1 or 2. But thats how you would lower the time frame, assuming when you look at the overall flow execution, that the retries are the most time consuming.

Cheers
If you like my answer, please Mark it as Resolved, and give it a thumbs up, so it can help others
Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey

[johnjohn123]

@FLMike the weird thing in my case, is that the duration for each retry is only 2-3 seconds, so even if we have 8 retries it should not take 24 minutes... but the retries have these start and end date/time:-

9/23/2023, 8:06:08 AM    9/23/2023, 8:06:10 AM

9/23/2023, 8:01:00 AM    9/23/2023, 8:01:02 AM

9/23/2023, 7:58:28 AM    9/23/2023, 7:58:30 AM

9/23/2023, 7:56:54 AM    9/23/2023, 7:56:56 AM

9/23/2023, 7:56:19 AM   9/23/2023, 7:56:21 AM

9/23/2023, 7:55:53 AM   9/23/2023, 7:55:55 AM

9/23/2023, 7:55:38 AM   9/23/2023, 7:55:40 AM

9/23/2023, 7:55:30 AM   9/23/2023, 7:55:33 AM

so the start date/time was 7:55:30 and it end after the 8th retry on 8:06:10 AM .. so this is 11 minutes and not 24 minutes.. so where the time has been sent? and why there is couple of minutes when a retry end and the other retry start?

how i can improve this?

Thanks

[FLMike]

Hi,

You have 2 options.

1. Do manual a run where you are sure that it will cause an error. While it runs, it will show the runtime of each step (and any combined steps (conditions etc). It will show you where the time is being spent. 

2. Go to the Details tab of the Flow

-To the Right where it says Process Mining, click on Improve your flow

Let it run.

It will show you this for your flow. It may take several minutes or look stuck. its not be patient.

Once it comes up you can click on any item in your flow and then in the right Paths visual, click on Time (instead of frequency) and then you can click on any line there to find what actions are taking that time

Cheers
If you like my answer, please Mark it as Resolved, and give it a thumbs up, so it can help others
Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey