cancel
Showing results for 
Search instead for 
Did you mean: 

Purging Workflow Progress Table

TOPIC
How to purge the workflow progress table.
INSTRUCTIONS
To purge the dbo.WorkflowProgress table in the Nintex Content database use the steps below:
***Make sure to purge Workflow History lists BEFORE Workflow Progress***
  1. It is recommended that a database backup be taken before performing the workflow data purge, as once it has been completed, there is not a way to restore the workflow data.
  2. On the server hosting Central Administration open a SharePoint Management Shell as administrator
  3. Run: 'NWAdmin.exe -o PurgeWorkflowData' with associated filtering switches (full usage at bottom)
    1. Example: NWAdmin.exe -o PurgeWorkflowData -state Cancelled -siteCollectionUrl http://contoso/sites/home -lastActivityBeforeLocal 1/1/2016 -timeout 600
    2. The above will purge workflow data from all cancelled workflows on the 'Home' site collection prior to Jan 1st 2016
  4. Once the command has completed, you will see that the record count on the Workflow Progress table will have dropped. 
Full usage:
NWAdmin.exe -o PurgeWorkflowData [-workflowName workflowName] [-state [All|Running|Completed|Cancelled|Error]] [-url teamsiteUrl [-listName listName]] [-siteCollectionUrl siteCollectionUrl] [-deletedLists] [-lastActivityBeforeUTC lastActivityBeforeDateUTC (" + DateFormat + ") | -lastActivityBeforeLocal lastActivityBeforeDateLocal (" + DateFormat + ")] [- listId listId] [-itemId itemId] [-instanceId workflowInstanceId] [-initiator loginname] [-timeout seconds] [-silent] [-purgeAll | -deletedSites]

After this command has run, Nintex Workflow will no longer have any record that the affected workflows were executed. The affected workflow instances will:
  • No longer be listed as having run on the ‘view workflow history’ page.
  • No longer be able to have their graphical status of detailed history viewed.
  • No longer affect statistics or reports.
  • No longer appear in web parts.
  • No longer have viewable tasks (the task item will exist, but clicking on it will receive and error about not being able to find the ID in the database).
  • No longer be able to have history list items associated with them purged using the ‘PurgeHistoryListData’ command unless the–clearall switch is used.
ADDITIONAL INFORMATION
NWAdmin 2013 Operations Guide: https://community.nintex.com/docs/DOC-1026
RELATED LINKS
Labels: (1)
Version history
Revision #:
1 of 1
Last update:
‎11-19-2018 10:35 AM
Updated by: