.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

list throttling issue

Posted By:      Posted Date: October 15, 2010    Points: 0   Category :SharePoint

List throttling Set to all users : 5000 (the magic number)

for Admin : 20000 

now I have around 5400+ items.


Thru Object model I want to get the items (all)  - for administrators it works.   For non administrators (contributors) its saying the expected "This view cannot be displayed because it exceeds the list view threshold "

Is there a way to override this ? I tried using  the Override property in the SPQuery

query .QueryThrottleMode = SPQueryThrottleOption.Override;

But still, the Override is helping, ie.,  The Threshold error comes.


View Complete Post

More Related Resource Links

Datalist with embedded Grid or List...Sub Totals issue with iteration


Let me see if one of you can assist with this one...


i have a similar situation, but mine does not use the selected item (item Command). Here is what the form is to do:


1. this is for an educational environment, so we use SID- NOT SSN's, but i use the SID as a filter in the subset as the grouping unique id.

2. I'm trying to inject a sub total row at the last line item of each SID (if more than one item in the report for that SID).

3. I'm looping thru the items in the Datalist Item Command with a for each (item i in Datalist2.Items).

Issue with List Definition of same base content type and deployed via same feature


I am trying to deploy two custom list definitions using only one single feature.  Below are the details of my issue.

  • Two custom list definitions
  • Each custom list definition has its own custom content type
  • Each custom content type inherits from the base content type Picture (Type = 109)
  • The custom list definitions are grouped together under one single feature
  • The custom content types are grouped together under a seperate single feature

When I deploy my solution in this configuration, the second list definition gets the first custom content type applied to it and the list schema from the first list definition is also applied to the second list definition.

What makes this more interesting, when I seperate both of the list definitions under two seperate features it all works fine.  Custom content types and list schemas get applied correctly.

Can anyone tell me why I can not deploy both list definitions under one single feature?

If you need me to post any of the origional code or XML to this post please let me know.



Compile issue with List<> and Linq

I am pretty sure this is some framework version issue but I am getting this on a (custom layout) page compile migrated over from MOSS. The following code complies in my MOSS 2007 environment but does not in my new 2010 environment. Thanks in advance for any help. Code section #1: private bool isSuccessReturnCode(string s) { bool bReturn = false; // Following line fails looking for ';' XDocument loaded = XDocument.Parse(s); var q = from c in loaded.Descendants("Node") select (string)c.Element("ReturnCode");   Code Section #2 private InvoiceItem getInvoiceItem(Guid ID) { List<InvoiceItem> InvoiceItems = ((List<InvoiceItem>)ViewState["INVOICEITEMS"]);

Reorder List Header Columns Issue

Hello to all, Today my senior told me to add functionality of Drag N Drop inside the GridView then i googled it and i found that Reorder List is the Same control i am looking for. But after doing Analysis on that i found that these templates are there in ReOrder List Control DragHandleTemplate EditItemTemplate EmptyListTemplate InsertItemTemplate ItemTemplate ReorderTemplate Its same as gridview or listview control but its dosent support paging in that.But i am not able to found Header Template inside that Control.   So Can any 1 Tell me how can i add header Template inside ReOrder List so Each Column will have its Rows. My sample example 1 Column is Eating all my columns and the rest of the columns are blank. I am looking any solution for this.   Waiting for a Solution   Regards    

Issue Adding a new Lookup Field to an existing List Instance

I have a code base that houses all of the column, content types, template, and list instance definitions. Am using the Update functionlaity a lot from version to version. Has been working well to this point. I just added two new columns (fields), one a Lookup and the other a Multi-Lookup. The fields are added fine on the update, columns look correct and the content type to which these were added also look fine. I can create a new List instance from the content type, and the new lookup columns are fine. The problem is this. Any existing list instances that were created from this same content type, now blow up when I try and access list items via the SP GUI. Something about a valid GUID, I dont't have the exect error anymore, but will repost it when I recreate the issue for the tenth time. I tried deleting the new lookup fields from this new list instance, thinking that I might be able to re-add them to fix the problem, but I get a new stack trace when I try and re-add them. Any hints on where I can start digging would be appreciated. I think I'll start with comparing the list instance schemas between an existing list and a newly created one.  

Relation List Lookup Issue

Hi, I have 2 lists that are related. List 1 - costs ----- cost - Number quarter - Drop Down Created By - Default SP Field List 2 - people ----- person - User/Group AD Lookup team - drop down I am trying to link these 2 lists so I can retrieve the users team from the people list in a view for the costs. I have tried making it so the user has manually select their name for each cost (instead of using the Created By field), but when I try to make this value a lookup it doesn't allow me to select the person or team field from the people list? Does a lookup only allow you to lookup text values and is there a work around? Many Thanks, Michael

Textbox and LIST<> issue


I would like to read data from a textbox, and then add every word to List<string> colletcion.

My problem is I can add to a List one big string and it always is of [0] index.


  List<string>lst1 = new List<string>();

How can i separate and add each word to a collection?

Calendar List View Issue - No Month, Week, Day Icons


I'm trying to setup a Calendar view for a list in SharePoint 2010. Everything is working the way I want, except there are no icons to change the view from Month, Week, or Day. Right now, if someone clicks on a date on the calendar, it switches to the Day view. But there is no way for them to go back to the month view.

I open the page in SharePoint Designer, and in the Design view I can see three icons on the Calendar (Month, Week, Day). But at no time do these icons show up anywhere except the design view.

I want it to have the arrow buttons, the month and year (which are already displaying) and then the icons to change the view. How do I get them to appear?

InfoPath list form publish issue when URL changes



We have a problem with publishing SharePoint InfoPath List Forms when site's or some top level site's URL is changed. After someone changes the URL that change does not affect to the InfoPath list form's publish URL value and you are not able to publish the form anymore. I got the following error message and if I change the URL back what it was before then publish works fine again. I don't know is this a feature or bug but does someone know is it possible to somehow update the publish URL to the form so that the possible site URL changes won't break the form publishing? 

The SOAP response indicates that an error occurred on the server:

Exception of type 'Microsoft.SharePoint.SoapServer.SoapServerException' was thrown.
<detail><errorstring xmlns="http://schemas.microsoft.com/sharepoint/soap/">There is no Web named "/sites/......./_vti_bin/Lists.asmx".</errorstring></detail>



Bulk editing issue - list cannot be displayed in Datasheet view



On a sharepoint page i click on 'Actions' tab then select 'Edit in Datasheet'  and i see the following error message


"The list cannot be displayed in Datasheet view for one or more of the following reasons: A datasheet component compatible with Windows SharePoint Services is not installed, your browser does not support ActiveX controls, or support for ActiveX controls is disabled. "


I am using XP professional, IE 6.02 to access the sharepoint site.


I was hoping that the hot fix KB938888 would fix that issue, but it did not. bulk editing is a nice feature that i would like to use but i have never been able to. The link to export data to Excel works fine.


if anyone has suggestions, thanks in advance


Issue with People and Groups type of column in datasheet view of shrepoint list.


We have a list created in MOSS 2007 which has a column of type people and groups. When we open the list in datasheet view and try to add records for people and groups type of column the column shows only records from All People section of the site collection. I have verified this for another site collection within the same web application where I am able to see all the users though they are not in the All people section of site collection.
Could anyone please let me know if I am missing any setting or if there is any change required to see all the user names in the people and groups type of column in datasheet view.

Thanks ,

SharePoint 2007 list having more than 5000 records - Performance issue


Hi Guys, 

I have a list which has more than 5000 records,it has 45 fields which includes some 12 lookup fields. I have used this list to display records using webparts and also used to display records in custom web pages.

The retrieval of the records has become slow now, initially i have paged and got some improvement, but again after a month the display has become slow now.

How do i work out on this performance issue. I get close to 750 records per month.


Please give me some tips to tackle the performance issue.





Share Point List Issue


I have created a list for a small quiz.  The list includes columns with questions 1 through 5 which are choice columns with multiple answers or single answers.  I am trying to score the quiz and have tried adding additionl columns between the questions.  It allows me to add a calculated column for the questions that have single answers and the formula menu includes a slection of that "question 2" number from the list to add to your formula.  The questions that have multiple choice answers do not appear in the list for you to select to add to your formula for that question. 

Example: Question 2 - Single answer
Formula: Score 2 - =IF([Question 2:]="true",5,0)  This formula scores 5 points if the answer is Correct and = true if it is incorrect it is 0 points.

Problem: Question 4 - Multiple answers
Formula: Score 4 =IF([Question 4:]="A;,B;,D", 5,0)  This does not work.  I have tried writing my own formula but I get an error everytime.  Error Message. One or more column references are not allowed, because the columns are defined as a data type that is not supported in formulas. 

I do not generally work with formulas and this is farely new for me.  This is Microsoft Share Point Moss 2007 .C

Issue Tracking List


Is there any way to enable incoming Email settings in “Issue Tracking List”?????

I don’t want third party tools.

Thank you | Shilambuselvan

sharepoint list issue



actually in my site im using one  webpart to disaply users announcement these announcement are coming from sharepoint list but this announcement are displaying with html tags in the page..

eg:  <div>In keeping with our strategic focus on Healthy Vision and to further drive growth, innovation and efficiencies, effective ,  team will be reporting into <strong>raj</strong>,  Business Improvement. </div> <div>&nbsp;</div>

like this only its displaying in the page please help me to sort out this issue,its very critical

thanks in advance

Custom List Calendar Issue


This seems like it should be pretty simple, but I have no idea how to make it work... I've created a custom list which includes a Date field (Date only).  The default view is set to Calendar.  I have set the Time Interval Begin and End dates to my custom date field.  I was expecting that when I click on a day (then New) or a time on the Calendar, that my date field would be populated with the selected date/time that picked... however, it stays blank.  This functionality works with a Calendar list, but not my custom list... How can I fix this?


Issue Displaying Data from Oracle using Business Data List WebPart


I have issue retrieving data from a remote oracle database using Business Data List WebPart. I have created an BDC definition
file using the BDC Meta Man tool. Then I imported this defination file into the Shared Services, so no issue it successfully
imported the file.

Now when I try to display the data using Business Data List WebPart, it fails to display any data. It gets the column headings
but no data. I get an error stating "An error occurred while retrieving data from OracleInstance. Administrators, see the server
log for more information."

The SharePoint log has the following exception:

Exception handed to HandleRuntimeException.HandleException System.Exception: System.Data.OracleClient requires Oracle client software version 8.1.7 or greater.     at System.Data.OracleClient.OCI.DetermineClientVersion()     at System.Data.OracleClient.OracleInternalConnection.OpenOnLocalTransaction(String userName, String password, String serverName, Boolean integratedSecurity, Boolean unicode, Boolean omitOracleConnectionName)     at System.Data.OracleClient.OracleInternalConnection..ctor(OracleConnectionString connectionOptions)     at System.Data.OracleClient.OracleConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConn

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend