Manoj468
Scholar

Move-Spsite site failing because of Nintex workflows - How can we pause in progress Nintex workflows

We are trying to move a large Sharepoint site 60 GB from one content database to another :: but Move-spsite is failing becuase of the database deadlock at source content database level on below stored procedures . It looks like some in progress workflow in caisng the problem. 

Below are the 3 stored procedure where we are seeing the deadlocks. 

  1. dbo.ScheduledWorkItems
  2. dbo.proc_GetRunnableWorkItems
  3. dbo.proc_DeleteInProgressWorkItems

 

Questions i have :

1. How can we avoid suck deadlocks at content database level while using the move-spsite . 

 

2. Is there any way, we can pause all the "in progress" nintex workflows before using move-spsite and resume them once the Site is moved to new content database, 

0 Kudos
Reply
1 Reply
SimonMuntz
Nintex How-To Center Expert
Nintex How-To Center Expert

Re: Move-Spsite site failing because of Nintex workflows - How can we pause in progress Nintex workf

You could try stopping the Workflow Timer Service on all the servers where it is found.
0 Kudos
Reply