We have the original Nintex Workflow History List named "NintexWorkflowHistory" with more than 7 milliion items in one of our subsites, right now I created a new Nintex Workflow History list named "NintexWorkflowHistory2017" and pointed all the workflows to it.
We already purged the workflow database with the following command:
DECLARE @return_value int
EXEC @return_value = [dbo].[PurgeWorkflowData]
@WebID='guid', --Update to your Site Collection ID
@LastActivityDate = '2017-01-01', --Setting lastworkflowactivity time, this is actions executed older than the date specified
@state = 4 --Running = 2, Completed = 4, Cancelled = 8, Error = 64
SELECT 'Return Value' = @return_value
Now I want to purge the "NintexWorkflowHistory" with:
NWAdmin.exe –o PurgeHistoryListData -siteUrl http://siteurl -lastActivityBefore 2017-01-01 00:00 -state Completed
but I get the follwing message: "No matching workflow instance ids found in the Nintex Workflow database." and not even 1 item is removed.
I found a forum suggesting the parameter -clearAll but I am afraid it also clears the new list "NintexWorkflowHistory2017"
Thank you for your help!