Testing a pilot of a recent SharePoint 2010 to SharePoint 2013 upgrade I encountered a message reading: “This view cannot be displayed because the number of lookup and workflow status columns it contains exceeds the threshold (8) enforced by the administrator”
This seems to be resource throttling introduced in the web application to limit the number of items in a list view, which roughly means “woah, whats with the large database query dude”
I was able to locate where this throttling setting is located.
Open Central Administration > Application Management > Manage Web Applications (choose the application)> General Settings (a drop-down list should show, now select) > Resource Throttling
Scroll down and locate ‘List View Lookup Threshold‘ The default value is 8
Honestly, I have no idea how large this should be. I didn’t design the list. However Microsoft has some details of creating lists here. The only major concern here is obvious “Resources”.
So what I did was double the value that was the default
Please note that this solution by far is not 100% correct as I just tossed resources at an issue to resolve it. However without prior knowledge of list design this solution works.
Error seen on end user side: