Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

I am just trying to fix something to get my BCS external list created. All indications are that the server has too many rows for BCS so here is what I put into the Powershell IDE running as administrator:

$bdc = Get-SPServiceApplicationProxy
    | Where {$_ -match "Business Data Connectivity"}
    $throttle = Get-SPBusinessDataCatalogThrottleConfig -ThrottleType Connections
        -Scope Global
        -ServiceApplicationProxy $bdc
Set-SPBusinessDataCatalogThrottleConfig -Enforced $false -Identity $throttle

Here is the error I got back:

An empty pipe element is not allowed.
At     D:\Troubleshooting\Powershell\DisableThrottleForBCS\FixToGetWalkthroughForBCSExternalListWorking.ps1:2 char:9
+ | <<<< Where {$_ -match "Business Data Connectivity"}
+ CategoryInfo : ParserError: (:) [], ParentContainsErrorRecordException
+ FullyQualifiedErrorId : EmptyPipeElement

Please help if you can see the error.

EDIT update to original post:

After more research and trials, I got this to work:

$bdc = Get-SPServiceApplicationProxy  | ? Where {$_.Name -like 'Business Data Connectivity Service'}
$throttle = Get-SPBusinessDataCatalogThrottleConfig -ThrottleType Connections -Scope    Global -ServiceApplicationProxy $bdc
Set-SPBusinessDataCatalogThrottleConfig -Enforced $false -Identity $throttle
share

2 Answers 2

I think it should be

...$_.Property -match...

In this case $_.TypeName?

This error comes from the pipe not having a variable to compare against I believe, again not a very clear error message, no shock there!

share
    
Thanks for the ideas. I am still stuck with same error message as in original post. I have tried the following syntax after the pipe operator: Where {$_.TypeName -match "Business Data Connectivity"} also Where {$_.ProcessName -match "Business Data Connectivity"} –  John Adams Sep 12 '12 at 19:09
up vote 0 down vote accepted

I got this to work:

$bdc = Get-SPServiceApplicationProxy  | ? Where {$_.Name -like 'Business Data Connectivity Service'}
$throttle = Get-SPBusinessDataCatalogThrottleConfig -ThrottleType Connections -Scope Global -ServiceApplicationProxy $bdc
Set-SPBusinessDataCatalogThrottleConfig -Enforced $false -Identity $throttle
share

This site is currently not accepting new answers.

Not the answer you're looking for? Browse other questions tagged .