Solved

Workflow fails randomly, after an update action.

  • 13 April 2023
  • 2 replies
  • 333 views

Badge +4

My workflow fails randomly, after an update action. Gives error “failed to update one or more column nintex workflow error”. I have added commit pending changes, but not helping. So through one article got a solution to add a pause.I added a pause of 0.2 minutes.Is it 12 seconds, I feel like it takes more than 12 seconds.Also adding pause after every update delays the workflow too much.This resolves the issue, but why exactly is this issue happening. Is there any other solution(I am using 2016 On-Prem version).

icon

Best answer by SimonMuntz 17 April 2023, 01:28

View original

2 replies

Userlevel 6
Badge +22

Hi,

 

For SharePoint on premise, Nintex uses SharePoints legacy workflow engine.  As that is the case, Nintex experiences all the quirks of that engine.

Pauses.

When you use a pause action, the delay you specify is not how long the workflow pauses before continuing. The delay is how long the workflow waits before adding the workflow back into the workflow timer service queue. The workflow timer service runs every five minutes so yes, your delay is longer than 12 seconds.

Why? 

This issue occurs because your environment is very fast. When SharePoint performs an operation on an item it puts a lock on the item so that no other process can make changes at the same time. In this case, SharePoint has not released the lock before the next action starts its operation so an error occurs.

Fix

As you have seen, the only fix is to wait for SharePoint to release its lock (pause) before performing the next action.

Badge +4

@SimonMuntz  Thank you for the detailed explaination

Reply