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|improve this question

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|improve this answer
    
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|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.