Solved

Workflows taking a long time to run

  • 14 November 2019
  • 6 replies
  • 369 views

Badge +5

Hi, I'm using Nintex for Sharepoint Online. The issue is that one particular workflow is often taking ages to run. Sometimes it only takes 8 mins, other times it's taken 48mins! I've had a look through other posts and it sounds similar to this one:

https://community.nintex.com/t5/Technical-Issues/Workflow-Taking-Extended-Period-of-Time-to-Run/ta-p/86710

 

But the link in the advice given doesn't work for me - maybe it's an O365 thing?

Can anyone advise on how to speed things up?

 

Thank you.

icon

Best answer by barryc 15 November 2019, 03:55

View original

6 replies

Userlevel 3
Badge +9
By inserting Log to History between every action and reviewing the workflow log revealed the following:
1) A loop iterated more times than expected.
2) "Query XML" is a slower executing service.
3) When "Start a Task Process" sends out the email delivery was held by our Mimecast.com relay for 15 minutes. White-listing all 12 subnets from Mandrillapp.com solved that issue.
Badge +5

As @v-tmasenko  has already mentioned...does your workflow use Query XML often? This caused such poor peformance in some of our workflows that we ended up redesigning forms to not have repeating sections or unbound controls. 


Also, O365 actions are often very slow to execute e.g. O365 Set Item Permissions. So if you have many of these you could see runtime blow out.

Userlevel 6
Badge +22
Hi,
Also keep in mind that Nintex Workflows use SharePoints Workflow Manager to run workflows. This is a shared service among many SharePoint Online tenants. If another Tenant using the same service is hammering it this can slow down your workflows.
Badge +5

Hello, apologies for the late reply - I seem to have turned notifications off. Yes the workflow does use Query XML, and you're right it does take ages but it seems to get past that point and then hang somewhere random. We are using some set item permissions actions too. I've tried inserting logging and there's nothing suspicious happening. I'm wondering if perhaps Sharepoint itself is running slowly on our tenant and that's causing the problem. At least I know i'm not alone! Thank you.

Badge +5

Update: I think all these replies apply to us - I've just picked the most fitting one as the answer. However I think the main issue is that there is something wrong with our Sharepoint tenant or possibly how we connect to it. If I find out what it is i'll do another update. Thank you everyone for your help.

Badge +4

Actually, I have the same issue, the workflow think first before startup and it takes minutes to get the list item update, I hate this latency 

Reply