0

I have created email reminder system using SharePoint 2010 workflow in SPD which sends email to user after every 12 hours i.e. first at 12am and then at 12pm.

For this purpose I am creating two lists called Primary and Secondary.

Primary contain two fields; LastReminderTime (datetime field) and NextReminderTime (this is calculated field which adds 12 hours in LastReminderTime field)

Secondary contain one field LastReminderTime (datetime field)

Both lists are running a workflow called "P workflow" and "S workflow" respectively. They are set to run on item change.

This is how it works:

  1. An item is updated in Primary list with LastReminderTime (which is a date and time is always starts at 12am, for e.g. 2016-12-12 12:00am). NextReminderTime will be set as 2016-12-12 12:00pm). Item is already present in this list (I am skipping that part because it is not necessary)

  2. "P workflow" runs and pauses till NextReminderTime comes at which it sends email to user and then sets LastReminderTime field in "Secondary" list with value of "NextReminderTime" in "Primary" list

  3. "S workflow" runs and immediately sets "LastReminderTime" in "Primary" with its own "LastReminderTime"

  4. Now "NextReminderTime" in "Primary" becomes "2016-12-13 12:00am"

  5. "P workflow" runs and pauses till "NextReminderTime" and then sends email and then it does the same thing as mentioned in steps above.

So in this way they keep on running and sends email every 12 hours (there is a condition which if met will stop the workflow so it won't run forever but I am ignore that part)

Now the problem I am facing is there are 13 items each in both lists so at exactly 12:00am or 12:00pm, 13 "P workflow" runs, sends email and updates field "Secondary". Then 13 "S workflow" runs immediately and sets value in "Primary". Then 13 "P workflows" run in "Primary and pause till "NextReminderTime". But problem is out of 13 workflows, there are always 1 to 3 workflows in Secondary list that will not "LastReminderTime" in "Primary" even though they ran successfully.

When I see history of those workflows it shows that they all ran at that time i.e. 12:00am or 12:00pm but for some reason workflow for some items (normally between 1 to 3) "S workflow" doesn't update item in "Primary" list.

Could it be because SharePoint cannot handle so many workflows at once i.e. all running at the same time and updating fields in one another?

  • 1
    If you made it an single list it wouldnt have Problems. The way list items work and the way you are useing them just don't go along. thats why it is about 90% stable/working. Have the 2 Workflows run on the single list and if it the gives Errors the Problem is within the workflow Actions. – Raoul Mensink Dec 14 '16 at 17:52
  • For this scenario (sending reminder every few hours) running 2 workflows on single list won't work. Because any change in item will trigger both at the same time. – Frank Martin Dec 14 '16 at 18:05
  • Which you should fix so it wont. Either you Need to make it one workflow or set better conditions. However we are lacking Information to guide you on this. – Raoul Mensink Dec 15 '16 at 9:58
0

I added a 10 minutes pause in second workflow which is "S Workflow" and now everything is working fine.

-1

In sharepoint 2013 workflows does not depend on the number of ques pending to be finished, the workflows works parralaley. So is there any field that is pending on the other workflow/depeneds on any other action caused by the workflow? If so rectify them. Also you can set status for the workflows during for each field's update. It would be much appreciated if you could share the workflow steps and variables.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.