Pause until Date Activity Not Triggered

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)

One thought on “Pause until Date Activity Not Triggered”

  1. 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

Leave a Reply

Your email address will not be published. Required fields are marked *