I have an issue which required your help. I make a form for purchase request and it linked with a "huge" workflow. My problem come from the fact that if two request was submit in the same time (maybe 2 or 3 second). One of them finish but an error occured for the second. This issue come from an update item action.
Indeed, I make an title with auto-increment id and I think that's the execution of both workflow at the same time is critical because the different action of the workflow cannot be done at the same time.
Does anyone face to this issue and find a solution ?
Solved! Go to Solution.
From your description I feel that the issue is due to the Auto increment title column.When 2nd workflow triggers before completion of first workflow the "ID" is at discrepancy due to the fact that "ID" for the first workflow is not generated. For testing purpose give hardcoded name to the file and try to trigger 2 workflows at a same time.
I guess you need to map different column instead of ID to make your title. Use this approach to create auto increment column https://www.nothingbutsharepoint.com/2010/06/03/sharepoint-how-to-create-an-auto-incrementing-number...
running two instances of the workflow on two different items should be a problem.
... unless the workflow do make updates to the other item as well.
what's the error you get?
how do you implement auto increment?
can you post config of failing update action?
Workflow status : Error occured
More detail : The workflow could not update the item, because it is possible that the columns for this item requires a different type of information.
List A with a workflow : One item where title = "master" and myid = 1
List B with the main workflow : When an item was created, the workflow start. The workflow automatically get item from List A, item "master" and add "+1" to "myid" and finished by an update item
have you checked you get correct result from List A lookup query?
I do not know how do you ensure increment of master record on List A, but I would say this approach can not be reliable since within sharepoint you can not ensure that two lookups into list A made at (about) the same time do not read the same myid value.
I have seen this error happen before when the initiator doesn't have permission to do the update - could that be the case? Also are you making use of commit pending changes as appropriate?