Troubleshooting Actions for SharePoint 2013 Workflows


Workflow Execution Issues

    1. Look in the Workflow History list, eg "http://sp2013/Lists/Workflow History". Do you find any errors in there?
    2. Is the user account starting the workflow correctly synchronized in the user profile database?
    3. Is the user account starting the workflow different from the Worflow Manager setup account? (more info at http://technet.microsoft.com/en-us/library/jj658588.aspx#section7)
    4. Are the User Profile Service and App Management Service started? See the green frames in the screenshot below, taken from Central Administration \Manage Services on Server:Services Started
    5. Are the App Management Service Application and User Profile Service Application started? Their proxies should be started as well. See the green frames in the screenshot below, taken from Central Administration \ Manage Services on Server:
    Service Applications Started


    How to Retrieve an Exception in the Workflow Manager Database

        Note that this is unsupported in a production environment, but very useful in a test environment!  
    In the SharePoint page workstat.aspx, copy the field requestor id
    1. In the URL query parameter from the worsktat.aspx page, copy theinstanceid field
    2. Open the WFInstanceManagementDB database with SQLManagement Studio, then request from the DebugTrace table
    3. The exception is in the WorkflowStatusDetail column


    Is SharePoint 2013 server connected?

        In Central Admin\ Service Applications \ Workflow Service Application Proxy: check the status. Does it read Workflow is Connected as in the below screenshot?  
    Workflow Status

    Is the Worflow Manager farm running?

        On a server member of the Workflow Manager farm:
    1. Start Workflow Manager PowerShell
    2. Run the get-WFStatus command
    3. Are the statuses Running, as on the screenshot below?
    Workflow Status PowerShell


    Is the Oauth Metadata information published and accessible from the SharePoint server?

        On the SharePoint 2013 server, start Internet Explorer, and check whether the Oauth metadata is accessible. The url is like http://wfm1:12291/$SYSTEM/$Metadata/json/1 . Below an example:  
    OAuth JSon Info


    Are the Scopes registered in the Workflow Manager farm?

    It is possible to check from Internet Explorer that the scopes are registered. It is also possible to navigate the workflow data. The example URLs below allow to check these elements:
    http://wfm1:12291/$ChildScopes
    http://wfm1:12291/SharePoint/default/659f1e87-c228-420e-9eb6-c2ca4b5b7cf8/aa605c44-734b-4bd4-b961-2afd253d1c3d/$ChildScopes
    http://wfm1:12291/SharePoint/default/659f1e87-c228-420e-9eb6-c2ca4b5b7cf8/aa605c44-734b-4bd4-b961-2afd253d1c3d/$Workflows
    http://wfm1:12291/SharePoint/default/659f1e87-c228-420e-9eb6-c2ca4b5b7cf8/aa605c44-734b-4bd4-b961-2afd253d1c3d/$Workflows/0ce48b29-b821-4785-ab12-34564e7332a3/$Instances

    Notes

    The GUIDs in the above URLs are not static.
    The tool below provides an easy navigation in the workflow manager data:
    http://code.msdn.microsoft.com/windowsdesktop/Workflow-Resource-Browser-a67b1d27
    On a Workflow Manager server, you have to run the Workflow-Resource-Browser as administrator.


    Activate Workflow Manager Logs

      1. Start Event Viewer
      2. Expand Applications and Services Logs \ Microsoft-Workflow
      3. In the menu View \ Show Analytical and Debug logs
      4. Select the Debug log, then right-click enable LogWorkflow EVTX5. Reproduce the issue
      6. Select the Debug log, righ-click Disable Log. (The point is to avoid filling the platform with logs)
      7. It is then possible to save the le log in the EVTX format

    I hope this checklist will help you while setting up and troubleshooting workflow!

    Comments

    Post a Comment

    Popular posts from this blog

    SharePoint 2013 Keyword Query (KQL) Content Class Property Restrictions

    Using property restrictions in your KQL queries, you can restrict your search to only pull back certain things like calendar events for instance. This is a very powerful way to limit search results  and get exactly what you are looking for. You can use these in your query like this: " lunch contentclass:STS_ListItem_Events " This will return only calendar events with the word "lunch" in them.  Pretty powerful and pretty simple. Here is a list of available content class items: STS_Site –  Site Collection STS_Web  –  Site (Web) STS_List_850  –  Page Library STS_ListItem_850  –  Page STS_List_DocumentLibrary  –  Document Library STS_ListItem_DocumentLibrary  –  Document Library Items STS_List  –  Custom List STS_ListItem  –  Custom List Item STS_List_Links  –  Links List STS_ListItem_Links  –  Links List Item STS_List_Tasks  –  Tasks List STS_ListItem_Tasks  –  Tasks List Item STS_List_Events  –  Events List STS_ListItem_Events 
    Read more

    Filtering the Sharepoint List Taxonomy Column using Rest API

    I ran into a strange issue today when using the SharePoint 2013 REST API for Lists with Managed Metadata columns    but I just had a ‘clever workaround’ moment with SharePoint’s oData/REST implementation when it comes to filtering list items based on taxonomy (managed metadata) columns. Now I do not consider myself a developer, so this article is probably a little verbose for some readers, but should be helpful to power users or IT pros. 1. To filter the Taxonomy columns in SharePoint list using Rest API call we need to use the Post method. 2. The Rest API call will give errors some times when the Rest API Query string crosses limit 260 characters that time we will use the Query in the body. Those things are clearly explained in the below example clearly. 3. WE can use the CAMEL Query in the Rest API call this example come under that. < script src = "https://cdnjs.cloudflare.com/ajax/libs/jquery/3.4.1/jquery.min.js" ></ script > < script > $(do
    Read more

    SharePoint CSOM to Create Folders and Sub Folders based on Excel Data

    Contents: 1. Reading data from the Excel sheet. 2. Connecting to SharePoint Online Site & Checking the SharePoint list is available or not. 3. Creating the SharePoint Library Folders and Sub Folders. 4. Conclusion. 1. Reading data from the Excel sheet: a. Open Visual Studio, Select New Project Creation and Select C# Console application and provide the appropriate Solution name. b. First add the required references like below.     I . using Microsoft.SharePoint.Client;     II. using System.Configuration; (Used to read the data from the App.config file)     III. using Microsoft.Office.Interop.Excel; (Excel supported file reference)     Note: If above references and not able to add please install the references from the NuGet Package  Manager Console. To Read the values from the App.config file use the below  and declare all the fields globally for re-usability.                 public   static   string  userName = ConfigurationManager.AppSettings[ "Username&qu
    Read more