Recovery Manager for SharePoint Premier Edition
Migration Manager for Sharepoint
Server Administrator for SharePoint
Migration Suite for SharePoint
Migrator for SharePoint Online
We have a qDiscussionView web part configured to only return 50 top level discussions per page. the discussion list it is using is quite large, over 115,000 items.
We have temporarily increased the threshold on the Prod site for testing.We have tested dropping this value back to the normal 5000 from 160000 and the same error occurs. Please be aware that this could cause the SQL servers to become unstable when the site is in use if left. what do you recommend.
I don't understand quite well what the error is.
You say "value back to the normal 5000 from 160000 and the same error occurs." What's the error? When it happens?
What's your QWP and SP version?
The error is what I put in the discussion title: “The attempted operation is prohibited because it exceeds the list view threshold enforced by the administrator”
QWP is 5.6 and SP2010 enterprise.
Did you ever find a way around this? Or a solution?
SharePoint limit the list view threshold to 5000(default) for performance consideration. Quick Apps for SharePoint is running on SharePoint, so it will effect by this limitation. I can provide below suggestions to solve this issue: