Skip to main content

[SOLVED] : Microsoft.SharePoint.SPFieldMap.GetColumnNumber(String strFieldName, Boolean bThrow) at Microsoft.SharePoint.SPListItemCollection.GetColumnNumber(String groupName, Boolean bThrowException) at Microsoft.SharePoint.SPListItemCollection.GetRawValue(String fieldname, Int32 iIndex, Boolean bThrow) at Microsoft.SharePoint.SPListItem.GetValue(SPField fld, Int32 columnNumber, Boolean bRaw, Boolean bThrowException) at Microsoft.SharePoint.SPListItem.GetValue(String strName, Boolean bThrowException) at Microsoft.SharePoint.SPListItem.get_Item(String fieldName) at XPoint.Base.Extensions.c_SPExtensions.GetFieldValue

I wanted to retrieve a SPListItem  value and got error while debugging as- "   at Microsoft.SharePoint.SPFieldMap.GetColumnNumber(String strFieldName, Boolean bThrow)    at Microsoft.SharePoint.SPListItemCollection.GetColumnNumber(String groupName, Boolean bThrowException)    at Microsoft.SharePoint.SPListItemCollection.GetRawValue(String fieldname, Int32 iIndex, Boolean bThrow)    at Microsoft.SharePoint.SPListItem.GetValue(SPField fld, Int32 columnNumber, Boolean bRaw, Boolean bThrowException)    at Microsoft.SharePoint.SPListItem.GetValue(String strName, Boolean bThrowException)    at Microsoft.SharePoint.SPListItem.get_Item(String fieldName)    at XPoint.Base.Extensions.c_SPExtensions.GetFieldValue"


I started banging my head like anything. because for another column of  same field type it was working fine and for one of the column of same field type it was giving this error. Those fields i have created through schema. So i created one more column of same type and tried to work on that.Errr!!.. still same error.

After doing thorough debug and analysis i realized about the root cause of issue. Yes yes yes!!.. We have  one lookup field already and we are saving values in few fields through workflow and event receiver. This is also kind of look up process.  By default SharePoint  has its own settings and we can extend it .

This was causing because the "List View Lookup Threshold". By default its value is 8. We can further increase it to required number. In my case i made it as 13. and the result is AILAAAA!!!.. working fine.. :)

Here i have mentioned steps to fix this issue:

1. Open sharepoint 2010 central administration site and select the web application which is having your site causing the issue.Click on General Settings and select Resource throttling












2.Scroll down till List view lookup Threshold and change the number from 8 to any upper value..Here i have mentioned 13 for my purpose





















Now save this change and check.!!!


Hope this may help someone

cheers

pradeepa achar

Comments

Post a Comment

Popular posts from this blog

error occurred in deployment step 'recycle iis application pool' :object reference not set to an instance of an object

While deploying using Visual studio, we may get an error "error occurred in deployment step 'recycle iis application pool' :object reference not set to an instance of an object" Solution:  Don't get  panic ..Simply restart the visual studio with the solution which you wanted to deploy on to the site This may help some one. -cheers pradeepa achar
5 comments
Continue »

The Fastest way to Export Schema of Sharepoint List

Many of my SharePoint Developer friends are struggling to get the Schema.xml file of a newly created list. The schema.xml file has the list's metadata information, by using the schema.xml, we can create the lis definition and paste this contents of Schema.xml to the Schema.xml file of the newly created List definition, so that you can deploy the list definition on another site. In order to do this, you guys might be following the procedure bu saving the site template and get the site definition solution. After this, you will open visual studio and import this solution and wait for few minutes. THIS IS A CRAPPY PROCEDURE..Why do you invest your time to get a schema of one or few list  by taking entire site definition?..If that site has lots of lists, then it will take lots of time. In my Research, i have found a the BEST  and quicker way to get schema.xml file of a particular list which you need Schema.xml. Follow the following procedure : Go to your site  click ...
Post a Comment
Continue »

The attempted operation is prohibited because it exceeds the list view threshold enforced by the administrator

You might have developed a functionality where data is being saved in a SharePoint list. By the time you developed this functionality it was working fine.As users adds the data , some day your functionality doesn't work. That means, the data which is present in the list is not being retrieved. Don't be panic. Just open the LOG file which is present in 14 hive folder. You will come to know about this bug with the statement -"The attempted operation is prohibited because it exceeds the list view threshold enforced by the administrator". Now what you have to do is, go to central administration site.  1.Click on Manage web application 2.Select the web application on which your sitecollection is created. 3.Click on General settings and select Resource throttling 4.by default list view threshold would be 5000. your list might have data more than 5000. So , increase the number to required threshold limit. you can make it 10000, 20000 like this. Do a i...
2 comments
Continue »