Skip to main content
Nintex Community Menu Bar

I've run this script several times and kicked the Nintex timer jobs but always the same result : "Items deleted so far 0."

SCRIPT:

NWAdmin.exe –o PurgeHistoryListData -siteUrl $farm.Url -lastActivityBefore 2022-07-01 00:00 -state Error -verbose -batchSize 1000 -Silent

OUTPUT:
Parameters to purge workflow data:

Workflow Name: All workflows
State: Error
Last activity was before: 2022-07-01 12:00 AM Local
Site: http://blahblah.com 
10 workflow instance ids found in the Nintex Workflow database that match the filter criteria.
The following workflow instance ids have been selected from the Nintex content database(s):
98c19b93-2e1d-4a50-8fe7-83370f1f86d2 .... (I truncated this info here)
Querying Items in "NintexWorkflowHistory" on site http://blahblah.com
Items to process in this batch... 8
Items deleted so far 0.

 

How do you "commit" as SQL would say.  Thank you.

Hi,

If the NWAdmin tool is not working for you please try the SQL script listed on this blog. https://community.nintex.com/t5/Blog/How-to-purge-large-Nintex-Workflow-History-list-and-dbo/ba-p/78098

Reply