The last in the list of SharePoint quirks happened to me few days ago.
The Symptoms
You have a SharePoint Designer workflow that has a Pause Workflow action until some future date. The date arrives and the workflow doesn’t wake up.
The First Thought
Timer activities in SharePoint workflows were prone to keep sleeping when rehydrated. A fix was promptly released by Microsoft, available here (as I mentioned in this blog).
The Real Culprit
For some obscure reason the SharePoint timer job that wakes up the sleeping workflows got lost. It was not activated. To check this up, fire the CMD window and type:
stsadm -o getproperty -propertyname "job-worfklow" -url http://MOSS_SERVER_URL
in this case it returned
<Property Exist="No" />
just as I feared.
The Solution
stsadm -o setproperty -propertyname "job-worfklow" -propertyvalue "every 1 minutes between 0 and 59" -url http://MOSS_SERVER_URL
Thanks to:
Paul Galvin’s blog (http://paulgalvin.spaces.live.com/blog/cns!1CC1EDB3DAA9B8AA!198.entry)
El Blanco’s blog (http://chrissyblanco.blogspot.com/2007/06/issues-with-delay-activity-in-moss.html)
Hi,
I am creating a reminder wrokflow using SharePoint Designer, and when i using “Pause Until Date” activity. It doesn’t resume and Workflow status does not change from “In Progress”.
(i.e it displays “Pausing for 0 minutes” under Workflow History but it doesn’t take specified action).
I have created it many times but found same problem.
I have done some googling for that in last some days, and from there I had got a hot fix KB 932394 and installed it but still I am in same trouble with Pause Until Date Activity.
I have also changed job-workflow time duration using stsadm command from 5 minutes to 1 minute as below:
stsadm -o setproperty -propertyname “job-workflow” -propertyvalue “every 1 minutes between 0 and 59” -url http://localhost
but found same problem.
What should I do for this?
Please suggest me why “Pause Until Date” doesn’t resume and Workflow status does not change from “In Progress” in my workflow.
Thank you,
Saurabh Kumar Singh