Finding a Workflow by InstanceID from ULS Logs

Document created by butlerj Support on Nov 20, 2018
Version 1Show Document
  • View in full screen mode
How to locate a workflow in ULS logs using the InstanceID.
  1. In the message column of the ULS logs, find a line similar to the following: Processing 1 events for workflow instance: 4b0d579c-2036-4080-aeb9-9fb0623f436e
  2. Using that instance ID, locate text similar to the following in the message column: Opening connection : Data Source=prodcontentdb;Initial Catalog=01_NintexDB_03;Integrated Security=True (Build:3070)
  3. Note the Nintex database and use this query in SQL to find the workflow SiteID, WebID and ListID:
    USE NW2010DB //Update to the name of your Nintex Content Database obtained from the ULS logs. SELECT * FROM dbo.WorkflowInstance WHERE WorkflowInstanceID = '408c7d6a-b919-4c84-b7b8-e410e6b3d2d3' //Change Workflow Instance ID to track additional workflows
  4. Run this set of Power-Shell commands to find the URL of the workflow:
    $siteid = 'GUID of the SiteID' $webid = 'GUID of the WebID' $listid = 'GUID of the ListID'  /* Used for list workflows */ Add-PSSnapin Microsoft.SharePoint.PowerShell -ErrorAction SilentlyContinue $list = $(Get-SPSite -Identity $siteid).Allwebs[[System.Guid]$webid].Lists[[System.Guid]$listid] $list = $(Get-SPWeb http://URL).Lists[[System.Guid]listid] $list.url $list.title  /* Used for Site Workflows */ Add-PSSnapin Microsoft.SharePoint.PowerShell -ErrorAction SilentlyContinue $site = $(Get-SPSite -Identity $siteid).Allwebs[[System.Guid]$webid] $site.url $site.title