List Item “value does not fall within the expected range” error--strange behavior

Question

I am getting the error on the following line for a timer job:

if (listItem["Department"] != null)

Normally this error indicates that it cannot find the field, but there are no spaces and the field label name and strong name are the same. Furthermore, if I write it like this:

if (listItem.Fields["Department"] != null)

I no longer get the error.

The problem is I am trying to call TaxonomyFieldValueCollection on the object and cannot call it by Fields. Is there some nuanced difference between the two that I'm missing that's causing this error?

EDIT: I figured out the problem. I had set query.ViewFieldsOnly = true; and "Department" was a new field and was not set in the ViewFields, so as far as the timer job could tell the field didn't exist. I simply needed to add the field into the list of fields in ViewField.

Answer 1

I figured out the problem. I had set query.ViewFieldsOnly = true; and "Department" was a new field and was not set in the ViewFields, so as far as the timer job could tell the field didn't exist. I simply needed to add the field into the list of fields in ViewField.

Answer 2

The first line checks if the value of the data in the column "Department" is null for that specific list item.

The second line checks if the SPField object "Department" is null.

If the SPField exists on the list, it should never be null, but the data stored in that field for a specific list item may be.

Answer 3

This error System.ArgumentException: Value does not fall within the expected range with exception message Microsoft.SharePoint.SPFieldMap.GetColumnNumber(String strFieldName, Boolean bThrow) is due to throttling limit set at List View Lookup Threshold settings in WebApplication.

To resolve this error, Open the SharePoint Central Administration site and click “Manage Web Application” link located under Application Management Group. Select the web application that has the problem. Select the “Resource Throttling” link under the “General Settings”

Navigate to List View Lookup Threshold section and change the value to a higher value depending on the count of Lookup, Person/Group, or workflow status field available in the list that caused the issue.