I have a WF where in a Query List I retrieve 600 records from a list of 7,000. I then Loop thru the 600 retrieved records 1 at a time to create a new record. I have the WF set up to run on a Nintex scheduler. At lease once a week it completes but restarts the WF and thus duplicates my output.
Can someone confirm exactly where my pause belongs - as an example after it gets to the 201st record ? How long should the pause be assuming that this is an option. Note if I manually run the Workflow it seems to fail after the 201st record. Thus, I am manually running the WF daily and running the WF 3 times :( I go to the query list and essentially run in increments of 200.
Also some suggested Paging which I am unfamilar with (other than 1 post), but doesnt Paging seem excessive for a QueryList that pulls back 600 records.
