Nintex Inventory Page breaks after domain user migration

Problem Description:

After we migrated the user account from sourcedomain\first.last to targetdomain\first.last​ the Nintex workflow inventory page stopped working for ALL users.
Cause: in the Nintex config DB the old user was still the “author” of the workflows what caused the page load to break, because the user couldn’t be resolved.

Directly in Nintex config DB update the value for the author of the affected user (support from Nintex gave OK).

Update NW2013DB.dbo.Workflows set Author = ‘i:0#.w|targetdomain\first.last’ where Author = ‘i:0#.w|sourcedomain\first.last’​

1 Star2 Stars3 Stars4 Stars5 Stars (No Ratings Yet)
Loading...

Terminate SharePoint Workflows via PowerShell

Problem Description:

​Workflow cannot be terminated in the GUI

Resolution:

Stop the workflow on PowerShell

$web = Get-SPWeb “WebUrl”
$web.AllowUnsafeUpdates = $true;

$list = $web.Lists[“Listname”];

$wfm=New-object Microsoft.SharePoint.WorkflowServices.WorkflowServicesManager($web)
$workflowInstanceService=$wfm.GetWorkflowInstanceService()
$workflowInstance=$workflowInstanceService.EnumerateInstancesForListItem($list.ID,ItemID)
$workflowInstance

$mywfi = $workflowInstanceService.EnumerateInstancesForListItem($list.ID,ItemID) | where ID -eq WFIID

$workflowInstanceService.TerminateWorkflow($mywfi)
$web.Dispose()

1 Star2 Stars3 Stars4 Stars5 Stars (No Ratings Yet)
Loading...