This view cannot be displayed because the number of lookup and workflow status columns it contains exceeds the threshold (8) enforced by the administrator
Sharepoint by default support 8 Lookup columns in a List view. If you create more then 8 lookup columns in the List you will get this error.
Person Or Group column comes under the lookup column category.
I have created 5 Person Or Group Column in my List. And sharepoint by default has Create By and Modified By as Lookup column along with other Lookup columns like Title (Linked with Menu) etc.
So the Count becomes greater then 8 which is threshold limit set under CA for a List View.
To Fix this issue
Go To Central Administration > Application Management > Manager Web Application > Your Web Application > General Settings > Resource Throttling.
Under Resource Throttling Check for List View Lookup Threshold. By default it's set to 8.
Change the value with 10 and save it. This will resolve this issue
Each lookup column in a list view causes a join with another table. Each additional lookup column in a view increases the complexity of metadata navigation and list view queries. In addition to standard lookup columns, single-value managed metadata, multiple-value managed metadata, single-value people and group columns, and multiple-value people and group columns count as lookup columns. Adding lookup columns to a view does not cause a gradual or linear decrease in performance, rather performance is somewhat stable until after eight columns when it rapidly degrades.
Sharepoint by default support 8 Lookup columns in a List view. If you create more then 8 lookup columns in the List you will get this error.
Person Or Group column comes under the lookup column category.
I have created 5 Person Or Group Column in my List. And sharepoint by default has Create By and Modified By as Lookup column along with other Lookup columns like Title (Linked with Menu) etc.
So the Count becomes greater then 8 which is threshold limit set under CA for a List View.
To Fix this issue
Go To Central Administration > Application Management > Manager Web Application > Your Web Application > General Settings > Resource Throttling.
Under Resource Throttling Check for List View Lookup Threshold. By default it's set to 8.
Change the value with 10 and save it. This will resolve this issue
Each lookup column in a list view causes a join with another table. Each additional lookup column in a view increases the complexity of metadata navigation and list view queries. In addition to standard lookup columns, single-value managed metadata, multiple-value managed metadata, single-value people and group columns, and multiple-value people and group columns count as lookup columns. Adding lookup columns to a view does not cause a gradual or linear decrease in performance, rather performance is somewhat stable until after eight columns when it rapidly degrades.
No comments:
Post a Comment