cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Nintex Newbie

Performance issue with Scheduled Workflows

Hello 

 

This is my first post, I've seen there is quite a lot of info in general but I'd like to have a fresh opinion. 

We're on Sharepoint 2013, Nintex Workflow 2013 (3.0.8.0)

 

Very regularly, a scheduled workflow fails to start. We have multiple workflows that can be scheduled in different sites, and it's always the same one that fails, others seems to be fine. 

 

When I go to this particular site, and try to display the Scheduled Workflows page (site settings -> Scheduled workflows) the page never shows and I eventually get an error after a few minutes. 

 

The interesting part is that I've set up SQL monitoring to check what's going on and here is the weird thing: 

I can see the following stored procedure taking 15 seconds to run:

exec GetScheduledWorkflowsForWeb @WebId='xxxx'

 

When I run the same query in SQL studio, it's instantaneous. Furthermore, there's only 550 rows which doesn't look like many. 

 

My questions are: 

- Is it safe to assume that there is a link between the performance problem to load the scheduled workflows page and the fact that they quite often fail to start ? 

- The table has a number of items with NextRunTime = 9999-12-31, is it safe to purge them ? 

Labels: (1)
0 Kudos
Reply
10 Replies
Highlighted
Nintex Newbie

Re: Performance issue with Scheduled Workflows

Hello,

 

May be it will help to fix your issue

you can use pause for few min's like 2 to 5 min's at the initial of the workflow to perform further action items. 

0 Kudos
Reply
Highlighted
Nintex Newbie

Re: Performance issue with Scheduled Workflows

It addresses issues related to: work flows execution in a parameter clear way, gathering execution information about every work process task, and investigation of the gathered information with statistical learning strategies. http://www.essayempire.co.uk

0 Kudos
Reply
Highlighted
Nintex Newbie

Re: Performance issue with Scheduled Workflows

Hello

Thanks for the suggestion but that won't help me. The workflow are scheduled and they fail to start, adding a pause cannot help in that situation.
0 Kudos
Reply
Highlighted
Nintex Newbie

Re: Performance issue with Scheduled Workflows

Hi @etienneg,

Are the workflows fail always?

Did you try to remove the schedule and then re-add?

Did you try to re-create the workflow?

Does your workflow contain ForEach action and Update Item/Start Workflow actions in it?

0 Kudos
Reply
Highlighted
Nintex Newbie

Re: Performance issue with Scheduled Workflows

Hi @Jekaterina 

 

It's only the schedule of the workflow that fails, not the workflow itself. 

What about the fact that I cannot load the page showing scheduled workflow and the SQL perf ? 

 

 

0 Kudos
Reply
Highlighted
Nintex Newbie

Re: Performance issue with Scheduled Workflows

0 Kudos
Reply
Highlighted
Nintex Newbie

Re: Performance issue with Scheduled Workflows

Thanks I will read through those.

We have other sites with scheduled workflows where it's working fine, it's only one particular workflow that causes this issue and I'm starting to think it's all a performance issue and that I need to purge some old records. 

What happens is that the workflow gets scheduled to run at 8 am at a certain date, the timer job picks it up, attempts to start the workflow, it fails, and then keeps failing every time the timer job runs (every 6 minutes in our config). I have to manually delete the schedule and manually start the workflow. 

0 Kudos
Reply
Highlighted
Nintex Newbie

Re: Performance issue with Scheduled Workflows

With which account the workflow is scheduled?
Ensure that you are not using service account if the global setting 'Allow workflow schedules to impersonate the system account' in CA is disabled.
0 Kudos
Reply
Highlighted
Nintex Newbie

Re: Performance issue with Scheduled Workflows

Hi again

 

Unfortunately nothing has helped so far.

Can someone please have a look and answer those questions from original post ?

 

My questions are: 

- Is it safe to assume that there is a link between the performance problem to load the scheduled workflows page and the fact that they quite often fail to start ? 

- The table has a number of items with NextRunTime = 9999-12-31, is it safe to purge them ? 

0 Kudos
Reply