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 »

“An exception of type Microsoft.SharePoint.Upgrade.SPUpgradeException was thrown. Additional exception information: Failed to call GetTypes on assembly Microsoft.Office.Server.Search, Version=14.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c. Could not load file or assembly 'System.Web.DataVisualization, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35' or one of its dependencies. The system cannot find the file specified.”

While running the product configuration wizard of Sharepoint foundation 2010, if you have come across the following error “ An exception of type Microsoft.SharePoint.Upgrade.SPUpgradeException was thrown. Additional exception information: Failed to call GetTypes on assembly Microsoft.Office.Server.Search, Version=14.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c. Could not load file or assembly 'System.Web.DataVisualization, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35' or one of its dependencies. The system cannot find the file specified.” Here is the solution to overcome the issue,. Open the SQL server configuration manager.Select the SQL Server Network Configuration and select the Protocols for MSSQLSERVER. Make sure that TCP/IP protocol is enabled. If it is disabled, make it enable by right clicking on the TCP/IP ,Click on Enable option. Hope ...
1 comment
Continue »

The server was unable to process the request due to an internal error. For more information about the error, either turn on IncludeExceptionDetailInFaults

Hi Guys,   I came across this issue  today. I was totally blank. Later i started observing the issue and realised that, this issue is caused just because of  mismatch of assembly version or any attribute  in Security token service's web.config file (C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\14\WebServices\SecurityToken). Actual issue was i upgraded the assembly version and didn't do changes in web.config file of security token service This blog helped me to fix my issue http://underthehood.ironworks.com/2011/05/sharepoint-2010-an-exception-occurred-when-trying-to-issue-security-token-the-server-was-unable-to-p-1.html thanks pradeepa achar
Post a Comment
Continue »