reading sharepoint 2013 list item field error: value does not fall within the expected rage

Question

Salam All,

I have a SharePoint Task List with 2 custom fields
- Category :lookup from category list
- OriginalAssignedTo : User picker Allow multi, Users only

When i try to read these 2 fields it keep gives me the below error

"Value Does not fall within the expected Range"

iam getting items using SPQuery without determine the fields and check if the fields exist in the item then check if the field is not null

if(item.Fields.ContainsField("Category"))
if(item["Category"] != null)
    item["Category"].ToString(); //----> here i get the error

I have tried the following as well
- read the FormattedValue and check if its null before i read it but the same
- read the field using : item.properties["Category"].ToString();

NOTE: I have another custom field and I am reading it just fine and the returned items have a value for these fields

Answer 1

you need to debug item["Category"].ToString(); and find out what is the value?

"Value Does not fall within the expected Range"

that denotes the casting is wrong or your looking at index 2 when there is only index o and 1.

so how are you getting the value?

string val = em["Category"].ToString();

but....what I belive is that your code is fine and there is somthing wrong with the lookup, the issue is resource throttling for lookup in your case! (as iv said index issue)

goto Central Admin, within Application Management click Manage Web Applications amd pick the web application in question. Now within the ribbon click on General Settings and pick Resource Throttling from hte dropdown menu. You should see List View Lookup Threshold and increase it's value to a reasonable number.

more detailed info can be found here on the subject:

http://blogs.msdn.com/b/dinaayoub/archive/2010/04/22/sharepoint-2010-how-to-change-the-list-view-threshold.aspx

the above is in 2010! sorry missed the title 2013! for your case you can use this in code!

SPList.EnableThrottling = false;

(splist is the list name that you have set!)

http://msdn.microsoft.com/en-us/library/microsoft.sharepoint.splist.enablethrottling.aspx

if this is not the case and it doesnt work out, is it happing for any user or selected users? this could be because of a known bug that has been fixed in one of the sp2013 updates! if you update sharepoint it would solve your issue if the first solution doesnt work!

look at august update that solves the bug!

http://technet.microsoft.com/en-us/sharepoint/jj891062.aspx

Answer 2

Run code in SPSecurity.RunWithElevatedPrivileges