Archive

Posts Tagged ‘BCS’

Increase the Default Throttle Size from 2000 for BCS in SharePoint 2010

January 26, 2011 Leave a comment

 

1) Open Microsoft SharePoint PowerShell

a) Go to Start>All Programs > SharePoint 2010 Products >

b) Right Click on SharePoint 2010 Management Shell to open the Powershell as an Administrator.

2) Type the following command:

Command # 1 :

$bdcProxy = Get-SPServiceApplicationProxy | where {$_.GetType().FullName –eq (‘Microsoft.SharePoint.BusinessData.SharedService.’ + ‘BdcServiceApplicationProxy’)}

Command #2 :

Get-SPBusinessDataCatalogThrottleConfig -Scope Database -ThrottleType Items -ServiceApplicationProxy $bdcProxy | Set-SPBusinessDataCatalogThrottleConfig -Maximum 100000000 -Default 500000

Command #3 :


Get-SPBusinessDataCatalogThrottleConfig -Scope Database -ThrottleType Items -ServiceApplicationProxy $bdcProxy

Verify that the output looks like this:

 

Scope : Database

ThrottleType : Items

Enforced : True

Default : 500000

Max : 100000000

Categories: PowerShell, SharePoint Tags: , ,