Vadim Tabakman

If you've been using Nintex Workflow for quite some time, you'll find that your NintexWorkflowHistory list can grow quite rapidly.  There are some limitations in SharePoint in regards to performance of lists that grow to be quite large.  The NintexWorkflowHistory list will inherit these limitations.

With Nintex Workflow 2010 and now Nintex Workflow 2013, you can create other history lists and configure workflows to use those.  This means easier maintenance of workflow history.  Periodically, you will need to do some maintenance, whether it's on the Nintex Workflow database or on the Nintex Workflow history.

This process, like having multiple Nintex Workflow content database, spreads the load to multiple locations and results in a longer period of time between maintenance schedules.

Firstly, let's start with which product do your want to see? Click the appropriate link below

 |

Nintex Workflow 2013
 
Out of the box, you get a single hidden list on your site that gets created when you activate the Nintex Workflow site feature.  The list is called "NintexWorkflowHistory".  In order to create a new list, you need to go to Site Settings.  There you will find a Nintex Workflow group of links and you need to click on the "Manage workflow history lists" link.
Site Settings
Once you click on that, you'll see a list of the existings History lists and you'll be able to create a list, enable, disable and purge.  You'll find these options on the SharePoint ribbon.
 
Manage History Lists
 
We can see in the above screenshot that we have the out of the box list and it already has a number of items in it.
Now we click on the "New" button in the ribbon so that we can create a new History list for Nintex Workflow.
 
Create History List
 
For this example, we will be creating a list specifically for our Finance Approval group of workflows.  Make sure you give it a legible name and I like to click the Hidden check box.  This will make the list hidden and less likely for a user to try to access it and modify the contents manually.
 
Create Finance History List
 
When you click the Create button, a few moments later, you will be presented with the Manage History List page again and you will see our new list.
 
New List
 
That's it for creating a new History list.  We can now create a new workflow, or modify an existing one and configure it to use this history list for any future workflow instances.
 
Workflow Settings
 
This workflow will have one action, just for this test and it will be a Log in the History List action.  After we publish and run the workflow, we can go back to the Manage Workflow History Lists in Site Settings and we'll see that the number of items in our new list has increased.
 
History Item Count

Purging History List Data

You will enevitably need to purge some data from the History List.  You can this at the Management page as you see the Purge Items button in the ribbon above.

Or, you could use the NWAdmin command line tool, which has a -o PurgeHistoryListData operation, with a bunch of other parameters it supports. One of the great parameters is the -silent. This means you will get no confirmation requests when running it.  So if you want to add it to a maintenance script, you can do it.

Here's a link to the NWAdmin White Paper : http://connect.nintex.com/files/folders/technical_and_white_papers_nw2010/entry12004.aspx

Conclusion

It's not that hard to manage your Nintex Workflow history lists and it's a great idea to look into this so that you minimize the risk of comping across issues in the future.

Posted by Vadim Tabakman Tuesday, December 18, 2012 3:07:00 PM Categories: Log in the History List Nintex Nintex Workflow Nintex Workflow 2013
Copyright Vadim Tabakman
Rate this Content 2 Votes

Comments

Tuesday, August 13, 2013 11:36:28 PM
chandru

re: Nintex Workflow - Nintex Workflow History List Management

hi vadimtabakman,

i'm new to nintex workflow i want to get all the workflow history to make a report i tried through accessing the GetWorkflowHistory() method always it return 0 logs please help me to fix this thanks in advance.

Wednesday, August 14, 2013 8:44:22 AM

re: Nintex Workflow - Nintex Workflow History List Management

Hi Chandru,

GetWorkflowHistory takes a fileurl, which is a document url where a workflow ran.

If you're working with a list, look at using the GetWorkflowHistoryForListItem web method instead.

cheers,

Vadim

Thursday, October 3, 2013 3:53:22 AM
sonali

re: Nintex Workflow - Nintex Workflow History List Management

Hi,

I am trying to purge a nintex workflow history for a particular site. I have used below command -

NWAdmin.exe –o PurgeHistoryListData -siteUrl http://......./sites/sitename -lastActivityBeforeLocal 2013-09-15 00:00 -state All

However its giving me below notification - "No matching workflow instance ids found in the Nintex Workflow database."

Could you please help me in this ???

thanks in advance.

Regards,

Sonali

Friday, January 3, 2014 7:36:09 AM
Rahul

re: Nintex Workflow - Nintex Workflow History List Management

Dear Team,

I have created one history list so how can associate this history list with my reusable workflow. any idea???

 

 

 

Thursday, July 10, 2014 8:02:38 AM
Thijs Deschepper
Gravatar

re: Nintex Workflow - Nintex Workflow History List Management

Hi Vadim,

I am busy learning more about managing the history list in Nintex (just came across a list with 4+ million items in it...).

Do you know of a way to find the URLs to ALL Nintex Workflow History Lists in a SharePoint farm? Would be great to see where there are lists with a large amount of items. 

I tried looking in the Nintex DB, but couldn't find anything.

Thanks

Thijs 

Tuesday, April 21, 2015 7:48:26 AM
Terry K
Gravatar

re: Nintex Workflow - Nintex Workflow History List Management

Hi Vadim,

Is there a way to change what is recorded in the default history list settings?

Can we change it from recording the GUID to recording the name of the workflow or list? Or can we create another column and have it record that information there?

 

Thanks,

Terry

Tuesday, April 21, 2015 7:55:02 AM

re: Nintex Workflow - Nintex Workflow History List Management

Hi Terry,

no, unfortunately you don't have the ability to manipulate the list and what goes in it.

Potentially, you could add other fields and have some other workflow go through and update that new field.. I haven't done this though.

cheers,

Vadim

Tuesday, June 23, 2015 12:50:39 PM
Tausif
Gravatar

re: Nintex Workflow - Nintex Workflow History List Management

Hi Vadim,

You are doing great work for the nintex community. Thanks for your help.

One question I wanted to ask that if its possible to get the current state of the running workflow by passing the list item id.

let me tell you the background of the requirement:

we have multiple subsites and each subsites is having a list and Nintex WF is running on those lists. It has different state approval process ( 5 states WF).

we have one site page and there we just want to pass the list name and list item id or any unique id and it should give me the current state of the WF. I want to achieve it using Nintex API.

Please let me know if its possible.

 

Thanks,

Tausif

 

 

 

 

 

 

Monday, November 9, 2015 2:38:58 PM
Carlos
Gravatar

re: Nintex Workflow - Nintex Workflow History List Management

Hello,

I have a Nintex workflow where a form is filled out and submitted.  A flexi task is used to have a url to the form data submitted to a shared email box.  The shared email box is required to approve or reject the data on the form.  How can I use the workflow or form ID to search for the data on the form?  For example if I wanted to see what was submitted on a form by a workflow 2 months ago.  Thank you

 

Monday, November 9, 2015 3:39:56 PM

re: Nintex Workflow - Nintex Workflow History List Management

Hi Carlos,

you need to figure out how to find the form from two months ago, then if the controls are linked to fields, just query for that field.  But if a Nintex Form is used and you have controls that are not connected, you'll need to query the FormData or NFFormData field.  This is XML, so use the Query XML action to get the data you need out of it.

Cheers,

Vadim

Monday, November 16, 2015 6:23:27 AM
Sarika gupta
Gravatar

re: Nintex Workflow - Nintex Workflow History List Management

Hi Vadim,

I have 3 levels of approval in Nintex workflow. All approvals is approved then it is failing into log to workflow history list. Even we are writing static text in to Workflow login history, There is no custom value is writing in login history though It is failing and giving following error. Issue occurred for approx 8 documents in same time. Please help on that. Thanks in advance.

Nintex.Workflow.NWActionExecutionException: Failed to log to history list. ---> System.ArgumentNullException: Value cannot be null. 

Parameter name: value   
 at System.String.IndexOf(String value, Int32 startIndex, Int32 count, StringComparison comparisonType)   
 at Nintex.Workflow.Common.StringFunctionParser.Execute(String Input, SPWeb web)   
 at Nintex.Workflow.HumanApproval.Message.AddContextDataToString(String input, NWContextDataCollection data, Boolean escapeValuesForSql, Boolean decodeInput, Boolean

allowSensitive, Boolean escapeValuesString, Fxo= constantReplaceMode)   
 at Nintex.Workflow.HumanApproval.Message.AddContextDataToString(String input, NWContextDataCollection data, Boolean escapeValuesForSql, Boolean decodeInput)   
 at Nintex.Workflow.Activities.WriteToHistoryListActivity.Execute(ActivityExecutionContext executionContext)   
 at System.Workflow.ComponentModel.ActivityExecutor`1.Execute(T activity, ActivityExecutionContext executionContext)   
 at System.Workflow.ComponentModel.ActivityExecutor`1.Execute(Activity activity, ActivityExecutionContext executionContext)   
 at System.Workflow.ComponentModel.ActivityExecutorOperation.Run(IWorkflowCoreRuntime workflowCoreRuntime)   
 at System.Workflow.Runtime.Scheduler.Run()     -

Monday, November 16, 2015 7:00:19 AM

re: Nintex Workflow - Nintex Workflow History List Management

How is your Log action configured?

Vadim

Monday, November 16, 2015 11:14:47 PM
Sarika
Gravatar

re: Nintex Workflow - Nintex Workflow History List Management

I am using "Request Approval" Component for approval then using nintex workflow's "Log in History List" component for login history.

Thanks

sarika

Tuesday, November 17, 2015 4:42:21 AM
sarika
Gravatar

re: Nintex Workflow - Nintex Workflow History List Management

Hi Vadim,

Also executed same workflow in same document, this time it is working fine. No error. I want to know why this error occurred earlier.

Thanks & Regards

Sarika

 

Tuesday, November 17, 2015 8:48:44 AM

re: Nintex Workflow - Nintex Workflow History List Management

That's really odd.  If it happens again, check your SP logs for "Workflow Infrastructure" error messages.  That might help explain the cause.  Then reach out to support@nintex.com.

cheers,

Vadim

Wednesday, November 18, 2015 2:23:32 AM
sarika
Gravatar

re: Nintex Workflow - Nintex Workflow History List Management

Thanks Vadim for your reply

Sarika

Monday, December 14, 2015 2:11:56 AM
Sarika
Gravatar

re: Nintex Workflow - Nintex Workflow History List Management

Hi Vadim,

I have raised query with Nintex Support, Please elaborate what does you mean with "Workflow Infrastructure" error messages.

Regards

Sarika

Monday, December 14, 2015 8:07:08 AM

re: Nintex Workflow - Nintex Workflow History List Management

Hi Sarika,

if a workflow fails without much information in the workflow history, you need to look in your SharePoint ULS logs.

In those logs, the messages are broken up into categories.  Most workflow errors go into the "Workflow Infrastructure" category.  That's what you would search for.

Vadim

Thursday, March 31, 2016 12:30:35 PM
Amaresh Lele
Gravatar

re: Nintex Workflow - Nintex Workflow History List Management

Is it possible to retrieve the workflow history items for current item within the workflow.

I have a multi-level approval workflow and the business requirement is to show who approved the first part of the workflow and at what time while the workflow is in the middle of approvals.

 

Thursday, March 31, 2016 4:48:03 PM

re: Nintex Workflow - Nintex Workflow History List Management

Hi Amaresh,

your workflow can call the Nintex Workflow web service and get GetWorkflowHistoryForListItem.

I hope that helps.

Vadim

Friday, April 22, 2016 12:47:39 PM
Andrea
Gravatar

re: Nintex Workflow - Nintex Workflow History List Management

Hi, Vadim.

If you purge the workflow history, does it leave all the tasks associated with the workflow or do those get deleted as well?

Friday, May 6, 2016 9:26:12 AM
Rich
Gravatar

re: Nintex Workflow - Nintex Workflow History List Management

Hi Vadim,

 

Is it possible to create and to assign the list to assign the nintex workflow history list via powershell when we setup out sites and add workflows to them via powershell?

 

Thanks!

You must sign in to this site to post comments.
Already Registered?
Sign In
Not Yet Registered?
Register





 

Statistics

  • Entries (276)
  • Comments (1769)

Categories