SharePoint Workflows and DelayActivity problem
While working on one of my WSS 3.0 projects recently I came up with a problem that was very annoying for me. The problem was related with the custom workflow made for one of the lists in SharePoint site. The workflow used a couple of Delay activities which did not worked consistently. After the Delay activity went to 'sleep' it never wakes up...never. I've searched Google and saw that the community already had this problem and so I started to go step by step. So I am writing you the steps that I did to make the Delay activity timer to resume correctly after reloading a workflow. Take in consideration that my environment was WSS 3.0 with SP1 on Vista with SQL Server 2005:
- Check the Windows SharePoint Services Timer if it is running. It was running, I made restart of the service and still did not worked.
- Check the ScheduledWorkItems table in my site content database to see if the activity saves the reloading time as it should. You can see the reload time under the DeliveryDate column. Everything was fine here, so the problem was not related to this.
- Installed the following hotfix from Microsoft http://www.microsoft.com/downloads/details.aspx?FamilyID=6096ce0f-d21e-47ac-afe2-d4e1c2fce670&displaylang=en. It didn't worked also.
- Then at last I found this infrastructure upgrade on the Microsoft SharePoint Team Blog: Announcing: Availability of Infrastructure Updates. Install this upgrade, restart the Windows SharePoint Services Timer and you should be OK. The Delay activity should start working as expected.
I hope that this will help someone as it did for me.