Skip to main content
Nintex Community Menu Bar

PurgeWorkflowData : Items deleted so far 0

  • August 23, 2022
  • 1 reply
  • 24 views

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.

1 reply

SimonMuntz
Nintex Employee
Forum|alt.badge.img+23
  • Nintex Employee
  • August 29, 2022
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