Reason:
In most cases, this would be because of default throttling limit set in the Business Data Catalog system. When the query is fired to the backend system, if the query returns more number of result than the default limit set for the Business Data Catalog system, we would see the above error message. In my case, I implemented all CRUD operations on the “Customer” table of “AdventureWorks” sample database and the default query returns more than 2000 records. 2000 is the default item limit set and if the results we get from the backend system exceeds this limit, we would face the above error when trying to browse to the external list.
First approach
We can configure the default item throttling limit for the BCS application to allow more than 2000 records. We can do that through SharePoint 2010 Management Console.
Second approach
The other approach is to set a limit parameter in the BCS model file. SPD2010 is the favorite tool for creating BCS models, so I’ll show how to set it using it, but I assume this can also be done using VS2010. I’ll assume that we have already created the BCS model and show how to edit in that case as by the time we encounter the above error message, we would have already had our model built.
