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

How to get the SharePoint central admin url programmaticaly via C#?

I had come across a situation where i had to get the sharepoint central admin's url.. You can follow the following snippet of the code. At the begining add the namespace  using Microsoft.SharePoint.Administration; SPAdministrationWebApplication centralAdminFarmUrl =  Microsoft.SharePoint.Administration.SPAdministrationWebApplication.Local ; String  centralAdminUrl = centralAdminFarmUrl.Sites[0].Url;  This may help someone -Cheers Pradeepa Achar
1 comment
Continue »

Programmatically read the value from web.config file

Here is a situation where you need to keep a key value pair element in the web.config file and read them during the run time. I suggest, better keep key /value pair under <appSettings> element and read it programmatically . <appSettings>   <add key=" LicenseKey " value=" 987jKouterhsk " /> </appSettings> Assume , you have added a license key as above in the web.config file. You need the license key during run time. You can access the license key class named "ConfigurationManager". write a property  called getLicenseKey and return the corresponding license key. public string GetLicenseKey {    get{   return  ConfigurationManager.AppSettings[" LicenseKey "]; } } Now the property GetLicenseKey will have the value 987jKouterhsk. Use this value as per your requirement. -Cheers Pradeepa Achar
Post a Comment
Continue »