List view threshold and columns manage metadata problems
Hi
We have problem in our company since we have more files in library than is set in List view Threshold.
I have created index on column "year" and create view filter: Year is equal 2015.
and I get famous error: this view cannot be displayed because....
I haven`t find any limitations on column type: manage metadata?
January 29th, 2015 11:50am
If you've got more documents tagged with '2015' than the threshold limit then you'll get caught by it. If you've only got 20 or so documents with that tag then it's highly likely that there's something wrong, or odd, in the view you've built.
I'm not sure what you mean by limitations on the column type. It should be fine for use in filtered view.
January 29th, 2015 12:05pm
Hi
I have only 1 file tagged with Year = 2013
my view has no Totals, gruop by and so on.
Filter is set:
January 29th, 2015 12:12pm
The sort order can influence the lookup size as well if I remember right.
Also, you've got an 'OR' operator there, unless it's a blank value below that could be an issue.
January 29th, 2015 12:26pm
Hi
here is no sort and OR is blank
January 29th, 2015 12:34pm
Hi,
As I understand, you encountered the issue after you created view filter.
Every column type has the default number that can be created. You should go to check the number of your column created is less than the number by default.
Per my test, I can achieve it without exceeding list view threshold.
Check things below:
1. You can increase the number of the list view threshold, and after that, you can try again to see the same situation will occur.
2. Go to create another managed metadata column year, and create index on column "year", and create view filter in the same list to see the issue will occur.
3. Check ULS log to see the details about the cause of the issue.
Best regards,
Sara Fan
January 30th, 2015 5:40pm
Hi,
How is everything going?
Is there anything update about this issue?
Best regards.
Thanks
February 8th, 2015 9:39pm
Hi
I created new term store with name "year1" and create new column (manage metadata) and error is the same.
I will try to post logs here.
February 9th, 2015 2:42am