當使用 SharePoint 2010 中的 Business Connectivity Services (BCS) 連接外部資料庫時,預設傳回的資料量是有數量限制的 (2000筆),超過的話,External List 這個 webpart 就無法正常顯示,就會出現下列錯誤:
Unable to display this Web Part. To troubleshoot the problem, open this Web page in a Microsoft SharePoint Foundation-compatible HTML editor such as Microsoft SharePoint Designer. If the problem persists, contact your Web server administrator. Correlation ID:b944db82-81bd-40a0-8a1a-ba24c57c1eac
##ReadMore##
可以使用 PowerShell 來放寬限制:
Add-PSSnapin Microsoft.SharePoint.PowerShell
Get-SPServiceApplicationProxy
Get-SPBusinessDataCatalogThrottleConfig
-Scope Database
-ThrottleType Items
-ServiceApplicationProxy 28739dbe-cc48-44e3-b7aa-8693e52d4843$bdc = Get-SPBusinessDataCatalogThrottleConfig
-Scope Database
-ThrottleType Items
-ServiceApplicationProxy 28739dbe-cc48-44e3-b7aa-8693e52d4843Set-SPBusinessDataCatalogThrottleConfig
-Identity $bdc
-Maximum 50000
-Default 50000