Value does not fall within the expected range

Hi folks,

This week I faced an error that was a real pain, and because of that I decided to create this post. To alert others about this.

I was developing a Silverlight Application in SharePoint and all of a sudden started getting the error message: Value does not fall within the expected range.

As I am using the Silverlight Object Model, I decided to see more details about this error through Fiddler. I got this:

Figure 1 – Fiddler analysis

It simply didn’t help at all. Really hard to identify what it is. Sad smile

Solution

In a different environment the same code was working perfectly fine, so I eliminated any issues with the code.

Luckily (or not), by checking the Lists I found this error message in my view:

This view cannot be displayed because the number of lookup and workflow status columns it contains exceeds the threshold (8) enforced by the administrator.

In order to solve this “other” issue I was obliged to set the Resource Throttling value up for “List View Lookup Threshold”.

Go to the Central Admin > Application Management > Manage web applications

Figure 2 – Manage web applications

Select the web application that needs to be changed, and then go to General Settings > Resource Throttling

Figure 3 – Resource Throttling

Increase the value of the List View Lookup Threshold, according to the Figure 4:

Figure 4 – List View Lookup Threshold

By saving this change, when I got back to the List, the error message disappeared and hence the issue with application was eliminated! My application just worked fine! Smile