Vadim Tabakman

Over the years, I've come across the issue of the missing workflow status column a number of time and I really had no idea why that happened.  On one list, a workflow would run and the column would get created and updated, while on another list, the column would never appear.

In all my cases, it turned out to be a configuration in my web application for List View Lookup Threshold.  By default, SharePoint has this set to 8.  What this means, is that if you have 8 lookup-type columns (lookup, person/group, managed metadata or workflow status column), then any other lookup-type columns will not appear.  You can ofcourse increase this value to something higher.

To see the current List View Lookup Threshold value, navigate to Central Administration > Manage Web Applications, click on your web application and select Resource Throtling from the General Settings ribbon drop down:

CA

You can see that in my test environment, the default value is set to 8:

Threshold

To test this out, I changed the value to 3.  This should mean that the list only allows 3 lookup-type fields.

I created a list with a Lookup field and a Person field. 

List

On this list, I also designed 2 very simple workflows, "Workflow1" and "Workflow2".

I ran both workflows and they both succeeded.

Missing Column

The first workflow status column appears, but the second one did.  If I look at the workflow history, you can see both workflows ran:

Completed Workflows

Conclusion

If you find that the workflow status column is not appearing, update the Resource Throttling page and increase the List View Lookup Threshold.  I did find that even if you increase the threshold and rerun the second workflow, the status column will not be created.

If anyone knows how to get SharePoint to create that column, let me know :).

The only thing I could come up with, is to rename the current workflow, publish it and run it.  Then SharePoint will create that new column.

Posted by Vadim Tabakman Thursday, February 21, 2013 9:40:00 AM Categories: Nintex Nintex Workflow Nintex Workflow 2013
Copyright Vadim Tabakman
Rate this Content 0 Votes

Comments

Thursday, February 21, 2013 11:24:17 AM
dan

re: Nintex Workflow - Missing Workflow Status Column

Interesting, I've come across this before as well.. And now I know why I had over 10 workflow running on the library.. I wonder if there is some powershell command to refresh columns
Thursday, February 21, 2013 11:25:45 AM

re: Nintex Workflow - Missing Workflow Status Column

Hi Dan,

That would be nice actually. There has to be a way to refresh it.  One day we'll find it :)

Vadim

Thursday, February 21, 2013 12:10:11 PM
Kevin

re: Nintex Workflow - Missing Workflow Status Column

I've had the opposite issue.  If you have a list/library that already has a workflow status column and then save it as a list/library, the import that into another farm it will keep that status column, but not the workflow.  Then if you pushlish a workflow it will create a second status column with the same name.

Any ideas on how to prevent this, without first removing the workflow prior to saving as a template?

Tuesday, October 21, 2014 3:03:35 AM
Kai
Gravatar

re: Nintex Workflow - Missing Workflow Status Column

Hi Vadim,

From my experience this issue only occurs, when the default view of the list or library already contains the number of lookup fields specified in the List View Lookup Threshold.

No new workflow status column will be created when the workflow runs the first time, because this would exceed the number of lookups defined in the List View Lookup Threshold.

To prevent this to happen make sure the number of lookup fields in the default view is less the number defined in the List View Lookup Threshold. Than the new workflow column will be created.

Instead of renaming the workflow and republishing it, you could also export the existing workflow which is misssing the workflow status column, delete this workflow from the list and import and republish it again.

Kai

Tuesday, October 21, 2014 3:47:23 AM
Kai
Gravatar

re: Nintex Workflow - Missing Workflow Status Column

Hi Vadim,

From my experience the creation of a new workflow status column will only fail, if the number of lookup fields in the default view of the list or library already equals the number of lookup fields in the List View Lookup Threshold. Because in this Scenario the new workflow status column would exceed the List View Lookup Threshold.

To prevent this to happen simply make sure to remove enough lookup fields from the default view before running the new workflow the first time. With this means I have never faced the above issue. In our farm the List View Lookup Threshold is defined with 8 and I have several list with more than 10 workflow status columns. Ofcourse I cannot show all of the workflow status columns in one view ;)

Best regards,

Kai

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

Statistics

  • Entries (279)
  • Comments (1769)

Categories