MOSS Forum

Ask Question   UnAnswered
Home » Forum » MOSS       RSS Feeds

SPD 2007 workflow pause until issues

  Asked By: Staci    Date: Jan 07    Category: MOSS    Views: 1927

I have a somewhat complex workflow. there is a choice field called active /
There is a calculated date field that tells when the field will change from
active to terminated.

I need an email to go out 14 days, 7 days, 3 days before the calculated date
field ends the contract.

So, I have a condition that states if the active field = active

then in the actions field I have:
add -14 days to the calculated date (output to 14Day variable)
then Pause until variable: 14day
then email.

the problem is that the email fires off every time a new item is added to the
list, however, the workflow states that it is in progress after that, so I think
that it is going to fire off another email 14 days before. Is there anyway to
stop that email from going off the first time?

My first guess is that the problem is with the calculated field, but I can't
prove that yet. Please can someone tell me that I am wrong and how to deal with



6 Answers Found

Answer #1    Answered By: Meaghan Webster     Answered On: Jan 07

Throw in another hidden column that is something like a flag. When the workflow
runs the very first time, check if the flag is down. If it is then don't send an
email. At the very end of the workflow, if the flag is not up, set it to up.
When the workflow runs the second time (I assume) then when it checks for the
flag, it should be up and can send the email the second time.

Something like that, anyways....

Answer #2    Answered By: Sunny Delacruz     Answered On: Jan 07

Yep, tried that, it just ends up ending the workflow. I have used Pause until
before and never had this problem so I am starting to wonder if it maybe isn't a
missing update problem.

Answer #3    Answered By: .net Guru     Answered On: Jan 07

For whatever it is worth, in our MOSS enterprise farm, I have NEVER gotten
"pause untiL" to work under any, very simple, 1-2 step, 1-2 row list
(am not at my work, network PC, but I thought it was "wait until", no matter)

Answer #4    Answered By: Renata Burt     Answered On: Jan 07

I use it all the time...!

Answer #5    Answered By: Lazaro Rutledge     Answered On: Jan 07

So it looks like there is a workflow update that is part of dotnet
system.workflow libraries that we are missing.
I found this by first getting the workflow to work fine on another clients
server and then going though updates.

Answer #6    Answered By: Karin Kerr     Answered On: Jan 07

Add in a check after the pause just before the send email to see if the flag is
still active.

Also write the calculated date to the log file to check you are getting the date
you expect.

Didn't find what you were looking for? Find more on SPD 2007 workflow pause until issues Or get search suggestion and latest updates.