Description

Emails do not get sent, autorun and other plugin jobs are not processed, workflows are stuck, and when viewing the Manage Background Jobs page the jobs are in a pending or permanent processing state.

Applies To

Workflow

Cause

In rare cases, a network interruption can cause a processing svservice job to fail and not complete. Svservice will not be able to move past this stuck job.

Solution

In first place to get jobs running try and get your SharePoint Administrator to restart the SharePoint timer service on all web front ends. Then retry the schedule again after a few minutes.

If you want to remove stuck job our Engineering team will be able to connect to the SQL instance containing the Winshuttle Workflow database but this will require Database access from your IT.

Expand the database tables. In the svservice table, find the stuck jobs by their IDs. These jobs will be in a status of Processing. Use an UPDATE statement to set these jobs back to pending, in which case svservice will attempt to run the job again, or place it in an error status and svservice will skip over it.

1 = Pending

2 = Completed

3 = Error

4 = Processing