Great work yaaar.

could u help in solving a problem which Iam facing?

I created a custom list in sharepoint site and created a workflow for that list(workflow runs automatically when a new list is created).It's functioning properly when I logged in as site administrator.

               If I log in with a member username&password workflow is not getting completed.

The workflow is about sending a mail when a new list is created.

          Member is having cotribute rights to the site.

Thanks for ur reply.

Hi, did the hotfix fixed your problem? I have the delay problem even after applying the hotfix.

All, I have the same issue as Marta. The problem persists after applying the patch. When I look at the Content Database I can find the workflow entry in table "ScheduledWorkItems" with correct entries in columns "created" and "DeliveryDate" - but the workflow does not proceed after the pausing interval has ended and stays "in progress" forever.

Any ideas what I could do?

Regards, Eric

I am having the same problem as Eric and Marta.  I applied the hotfix, and i am still having problems where the delays are NOT waking up.

Some ?'s I am thinking.  The hotfix says it if for windows 20003 server SP 1, but I have SP2.  But I had the problem before the hotfix.  Maybe the fix doesn't work on SP2?

Also, I am testing this on a Virtual Server, not sure if this could be why, but I would love to get to the bottom of this...

Regards,

Jon

From visiting a few forums, I have 5 other developers with the same problem.  I am callling MS today to report the problem.

-Jon

So far, I’ve gotten feedback from 7 other developers (in forums) who are having the same problem where this update (Hotfix) is not working correctly for the Workflow delay activities, specifically Windows Server 2003 SP2 (anybody have problems on different platform?)

So, I called MS support this morning and they transferred me to .NET support team.  Apparently it is a Microsoft .NET Framework 3.0 issue (Artical ID: 932394).  They took down my information and informed me that due to the overwhelming popularity of SharePoint, that it would take 10-20 days until they could get back to me.  OY!

So, I am going to look into other options /checks such as:

Uninstalling .net 3.0

creating a SP Designer workflow to see if I can something to work until the delay is fixed. (maybe crack it open to see what delay(s) it uses...)

Install VS 2005 SP1

find an alternative to delay (maybe System.Timer, etc..).

One person suggested to make sure your timezone is set on SP and SQL server, but I checked that and all is good.

I will keep everyone updated if I find anything, but until then, we're in a jam.

Regards,

Jonathan K. Herschel

Forget about installing SP1. I had the problem with SP1 and I installed the fix and it did not work. Then I installed SP 2 and reinstalled the fix and still it did not work.

I opened a ticked as well with MS ...

visit this link for the solution, it worked for me (SP2)

forums.microsoft.com/.../showpost.aspx

If you visit the link Marta left, you will see MS response to my case and that this is a known issue and they are working on it.

Here it is:

All,

Good News (in fact that it has a workaround).

I spoke with someone from MS regarding this issue and he sent the below follow-up email to me today.

"I have been able to set up some local tests on my machine to narrow down the problem and have had a talk about this with the product group as well. The issue happens if the Delay is inside a replicator, there are many delays running in parallel, or if DelayFor is the last activity in a workflow, using just a delay activity in a workflow works fine.

The product group is aware of these issues and is looking into all these scenarios. As of right now I [do] not have any time lines for a fix or an update, it could take a while to have a public fix available. I am the owner of this bug [and] will keep monitoring this issue and watch for updates..."

If you can tweak your setup so that it doesn't fall in to the above scenarios, it may work, otherwise, I ended up using a regular Delay Activity which has the following settings: TimeoutDuration which is in the format of DD:HH:MM:CC (The CC is seconds b/c the SS caused a smiley ).  So, the following would be 50 days, 40 hours, 30 minutes and 00 seconds: 50.40:30:00.

Instead of using the DelayUntil, try using a regular delay.  I took the DATETIME of today and subtracted it from DATETIME of 'your date' and converted it into Days,Hours,Minutes, & Seconds.

Example:

DateTime dtReminder1 = Convert.ToDateTime(workflowProperties.Item["Reminder 1 Date"]); // gets datetime from a field named 'Reminder 1 Date'

TimeSpan tsDiff = dtReminder1.Subtract(dtToday); // subtract today from 'Reminder 1 Date'

Double dblDays = tsDiff.Days; // get days

Double dbltemp = tsDiff.Hours; // store total hours into temp variable

Double dblHours = dbltemp % 24; // extract days (24 hours/day) from tsDiff, so you are left with just the hours

Double dbltemp2 = tsDiff.Minutes; // store total minutes into temp2 variable

Double dblMinutes = dbtemp2 % 60 // extract minutes (60 mins/hour) from tsDiff, so you are left with just the minutes

You are left with the following:

dblDays = # days, dlbHours = # hours, dlbMinutes = # of minutes.

Instead of using the DelayFor, try using the regular delay.  This is allready set to use Hours Minutes and SEconds, so instead of using three settings (days, hours, minutes), convert into one string 00.00:00:00.

Hope this helps!

Jonathan K. Herschel

Dear All,

     I am creating a reminder workflow using SharePoint Designer, and when I  use "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" only, under Workflow History but it doesn't take any specified action).

I have done some googling for that in last 4 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 very much,

Saurabh Kumar Singh

Dear Saurabh,

Did you get any solution on this as I am also stuck badly with the pause until date and the pause for duration activites even after applying the pathces, infrastructure updates and all the hotfixes , kindly respond.