SharePoint Workflow Error: Due to heavy load, the latest workflow operation has been queued. It will attempt to resume at a later time.

Standard

Note: Due to heavy load, the latest workflow operation has been queued. It will attempt to resume at a later time.

I was receiving the above error and found out below causes:

  1. A workflow was being executed on a large number of items 2500 items in a list.
  2. Multiple workflow instances were being initiated on the same site within a small amount of time, current Workflow Timer was set to “ 1 minute”
  3. When an item was added to the library it was getting in the queue
  4. When user click the “ Task Button” in outlook it will raise permissions error after receiving the email notification
  5. Workflows taking more time to initiate
  6. RAM and CPU performance was Ok

Resolution:

I restarted Workflow service in “Services”  under “Administrative Tools” and did few updates in system:

  • Increase Throttle Size
  • Increase Batch Size
  • Time Out
  • Workflow Timer Interval

Increase Throttle Size

The Workflow throttle setting controls how many Workflows can be processing at any one time on the entire server farm. By increasing the throttle it will allow the number of Workflows execution or can be initiated at a time.

Use below PowerShell command to get the current Throttle Size:

Get-SPFarmConfig | Select WorkflowPostponeThreshold

Use below PowerShell command to set new Throttle Size:

Set-SPFarmConfig -WorkflowPostponeThreshold 250

Increased Batch Size

This is the size that determines number of events processed for a single Workflow instance. Default value is 100, but it can be range from 1 to any number.

Use below PowerShell command to get the current Batch Size:

Get-SPFarmConfig | Select WorkflowBatchSize

Use below PowerShell command to set new Batch Size:

Set-SPFarmConfig -WorkflowBatchSize 200

Time Out

This decides the time out of the Workflow event. The default value is 5 and can be any integer. The time is in minute.

Use below STSADM command to get the current Time Out value:

stsadm -o getproperty -pn workflow-eventdelivery-timeout

Use below STSADM command to get the current Time Out value:

stsadm -o setproperty -pn workflow-eventdelivery-timeout -pv “15″

Workflow Timer Interval

This setting is applicable at Web Application level and not the farm level. The workflow timer interval specifies how often the workflow SPTimer job fires to process pending workflow tasks. This interval also represents the granularity of delay timers within your workflow. If a timer is set to delay for one minute, but the interval timer fires only every five minutes, the workflow delays for five minutes, not one minute.

Use below STSADM command to get the current Workflow Timer Interval value:

stsadm -o getproperty -pn job-workflow -url <Web Application Url>

Use below STSADM command to get the current Workflow Timer Interval value:

stsadm -o setproperty -pn job-workflow -pv “Every 10 minutes between 0 and 30″ -url <Web Application Url>

In a while WF will start processing the queue. Thanks,

Advertisements

4 thoughts on “SharePoint Workflow Error: Due to heavy load, the latest workflow operation has been queued. It will attempt to resume at a later time.

  1. Zahid Zia

    summaya do you have any ebook about 2013 OOTB workflows? i have been trying to search on everywhere but no luck. i have nintex experience but one of my customer is not interested in 3rd party…if u have i would appreciate rhe sharing.

    Like

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s