SharePoint provides the great capability of discovering contents, discussions, people, etc from your SharePoint environment, which leverages the Search service. Though this is a quite useful feature, there are a few limitations that sometimes need to be handled in order to meet the requirements and desired results/output.Maximum search results returned limitation
SharePoint 2010 search has a default limit of 10000 maximum results for the submitted queries.
This is something the developer might not be aware of initially but will encounter an exception if tried to get results more than 10000 results using the RowLimit of FullTextSqlQuery.
If RowLimit is not specified, only 50 results will be returned by default.
See the below line from developer code.
query.RowLimit = 15000;
ResultTableCollection queryResults = query.Execute();
In this code, the developer wants to get 15000 results for the provided query, but the code throws an exception as Exception from HRESULT: 0x80040E01.
This is because the default limit set by SharePoint is 10000, moreover this cannot be changed through Central Administration. One way to change this setting is by using below PowerShell command.
$ssa = Get-SPEnterpriseSearchServiceApplication
Now if the above code is executed, the query will return a maximum of 15000 results. The limit can be set of 10000 again using the same PowerShell script as above and changing Config:qp_MaxResultsReturned to 10000.Important Note
This PowerShell script will modify the related Search Service Application configuration for the entire FARM, so please consult your SharePoint Admin before making any updates. This is not recommended in live Production environments and such changes should be made only by the Admins.
- Setup synonyms or alias or thesaurus in SharePoint
- How to redirect SharePoint Site Collection to different URL
- How to hide quick launch in SharePoint
- SharePoint 2010 DataForm Unable to display this Web Part System.StackOverflowException
- SharePoint Server 2016 Preview installation error - This Product Key isn't a valid Microsoft Office 2016 Product Key. Check that you've entered it correctly.
- How to delete SharePoint List Item programmatically
- SharePoint Server 2016 IT Preview Deprecated Removed features
- Create SharePoint Site Collection using PowerShell New-SPSite
- How to create SharePoint List Item programmatically
- See actual SharePoint error exception modify web.config
- SharePoint Server 2016 installation System Hardware requirements
- [Solved] SharePoint Illegal operation attempted on a registry key that has been marked for deletion
- SharePoint Designer Workflow error - Coercion Failed: Input cannot be null for this coercion
- [Solved] SharePoint Access Denied error editing Document Name
- SharePoint 2016 error - Could not find file ManageUserProfileServiceApplicationTenantSimplified.xml
- Bypass domain name for IIS site (SharePoint)
- SharePoint PowerShell Merge-SPLogFile filter by time using StartTime EndTime
- Recover SharePoint if the SQL Server IP changes
- SharePoint CAML query error - The XML source is not correct
- How to enable disable SharePoint Developer Dashboard for tracing troubleshooting
- Change SharePoint search results FullTextSqlQuery RowLimit 10000
- Update Created By (Author) column of SharePoint document using PowerShell
- SharePoint Server 2016 error - Failed to connect to the configuration database
- The service instance
- SharePoint Managed Metadata Hidden Taxonomy List - TaxonomyHiddenList
- Hide files and folders on Mac OS X - Mac-OS-X
- Android : Execute some code after back button is pressed - Android
- Bootstrap Nav Menu Dropdown on hover - Bootstrap
- Changing Android Intent Tittle using java code - Android
- Share Image and Text on Instagram from Android App using Share Dialog - Android
- Error 404 Tomcat homepage http://localhost:8080/ not displayed - Tomcat
- Hyperlink in html (anchor tag) without a underline - Html
- Change Max and Min Value of Android Seekbar Programmatically - Android
- Channel 50 SMSes received every few minutes Android Phones - Android
- [Solved] SharePoint Search Internal server error exception - SharePoint
- Adding Sub Headings to Bootstrap Header tags - Html
- How to insert image into Google Sheets cell - Google
- [IRCTC] Indian railways official eRail API 1.1 for developers to get train info - HowTos
- Add Text at Start and End of Each Line Notepad++ - NotepadPlusPlus
- Android AlertDialog Programatically Example - Android