# Pipeline multiple parameters fails

**URL:** <https://forums.powershell.org/t/pipeline-multiple-parameters-fails/11428>\
**Category:** PowerShell Help\
**Created:** [October 6, 2018, 9:08am UTC](https://forums.powershell.org/t/pipeline-multiple-parameters-fails/11428 "2018-10-06T09:08:17Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![firmbyte](https://avatars.discourse-cdn.com/v4/letter/f/e68b1a/32.png) [@firmbyte](https://forums.powershell.org/u/firmbyte)\
**Post date:** [October 6, 2018, 9:08am UTC](https://forums.powershell.org/t/pipeline-multiple-parameters-fails/11428/1 "2018-10-06T09:08:17Z")

</div>

I’m trying to create a Function, that will accept multiple parameters from the pipeline. The idea is to provide a list of servers and databases and ensure each database is set to Simple.

```
Function Set-RecoveryModel

{

[CmdletBinding()]

param (

[Parameter(Mandatory=$true, ValuefromPipelineByPropertyName=$true,Position=0)]

[Alias('IPAddress','CN')]

[string]$SqlServer ,

[Parameter(Mandatory=$true, ValuefromPipelineByPropertyName=$true,Position=1)]

[string]$Database ,

[Parameter(Mandatory=$false, ValuefromPipelineByPropertyName=$true,Position=2)]

[string]$Recovery = "Simple"

)

BEGIN {

Write-Verbose $SqlServer

Write-Verbose $Database

Write-Verbose $Recovery

Write-Verbose "Loading Module"

[System.Reflection.Assembly]::LoadWithPartialName("Microsoft.SqlServer.SMO") | out-null

$Srv = New-Object ('Microsoft.SqlServer.Management.Smo.Server') $SqlServer

}

PROCESS {

Write-Verbose "Setting recovery"

$Srv.Databases[$Database].RecoveryModel = $Recovery

Try {

$Srv.Databases[$Database].Alter()

} catch {

Write-Verbose "Error: $($_.Exception.Message)`r`n$($_.Exception.ItemName)"

Continue

}

$Srv.Databases[$Database].Rfresh

}

END {

Write-Verbose "All Done"

}

}
```

When I run it passing the parameter values directly, it works as expected.

```
$SqlServer = "SqlServer\DEV"

$Database = "ContosoRetailDW"

$Recovery = "Simple"

Set-RecoveryModel -SqlServer $SqlServer -Database $Database -Recovery $Recovery
```

But when I try and pipe the parameter values, it errors.

```
$DbInfo = @{

SqlServer = 'SqlServer\DEV'

Database = 'ContosoRetailDW'

Recovery = 'Simple'

}

[PSCustomObject]$DbInfo | Set-RecoveryModel -Verbose
```

…and

```
@([pscustomobject]@{

SqlServer = "SqlServer\DEV";

Database = "ContosoRetailDW";

Recovery = "Simple";},

[pscustomobject]@{

SqlServer = "SqlServer\DEV";

Database = "DBARepository";

Recovery = "Simple";}) | Set-RecoveryModel
```

&nbsp;

I can see that the parameter values I’m passing are not being passed to the Function but I don’t know why.

Both return the same error

```
VERBOSE:

VERBOSE:

VERBOSE: Simple

VERBOSE: Loading Module

VERBOSE: Setting recovery

The property 'RecoveryModel' cannot be found on this object. Verify that the property exists and can be set.

At line:25 char:1

+ $Srv.Databases[$Database].RecoveryModel = $Recovery

+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

+ CategoryInfo : InvalidOperation: (:) [], RuntimeException

+ FullyQualifiedErrorId : PropertyNotFound

VERBOSE: Error: You cannot call a method on a null-valued expression.
```

&nbsp;

I don’t understand why this is happening.

All advice and comments greatfully received.

---

<div class="post-metadata">

**Author:** ![kvprasoon](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.powershell.org/kvprasoon/32/4449_2.png) [@kvprasoon](https://forums.powershell.org/u/kvprasoon)\
**Post date:** [October 6, 2018, 9:38am UTC](https://forums.powershell.org/t/pipeline-multiple-parameters-fails/11428/2 "2018-10-06T09:38:41Z")

</div>

Are you in PowerShell version 2.0 ? [PSCustomObject] type behaviour is different in v 2.0.  
User Trace-Command to see what is happening in Parameter binding.

```
Trace-Command ParameterBinding { [PSCustomObject]$DbInfo | Set-RecoveryModel } -PSPath
```

---

<div class="post-metadata">

**Author:** ![js2010](https://avatars.discourse-cdn.com/v4/letter/j/ebca7d/32.png) [@js2010](https://forums.powershell.org/u/js2010)\
**Post date:** [October 6, 2018, 10:33am UTC](https://forums.powershell.org/t/pipeline-multiple-parameters-fails/11428/3 "2018-10-06T10:33:34Z")

</div>

It should work fine, but the begin block isn’t going to see any of the parameters from the pipe. You have to work with them in the process block. Notice that the verbose messages are blank when you pipe them.

---

<div class="post-metadata">

**Author:** ![firmbyte](https://avatars.discourse-cdn.com/v4/letter/f/e68b1a/32.png) [@firmbyte](https://forums.powershell.org/u/firmbyte)\
**Post date:** [October 6, 2018, 11:45am UTC](https://forums.powershell.org/t/pipeline-multiple-parameters-fails/11428/4 "2018-10-06T11:45:44Z")

</div>

Thanks JS that indeed solved the problem.

---

<div class="post-metadata">

**Author:** ![firmbyte](https://avatars.discourse-cdn.com/v4/letter/f/e68b1a/32.png) [@firmbyte](https://forums.powershell.org/u/firmbyte)\
**Post date:** [October 6, 2018, 12:14pm UTC](https://forums.powershell.org/t/pipeline-multiple-parameters-fails/11428/5 "2018-10-06T12:14:40Z")

</div>

Thanks for the help. I wasn’t aware of that Trace-Command.

&nbsp;

---

<div class="post-metadata">

**Author:** ![firmbyte](https://avatars.discourse-cdn.com/v4/letter/f/e68b1a/32.png) [@firmbyte](https://forums.powershell.org/u/firmbyte)\
**Post date:** [October 6, 2018, 12:19pm UTC](https://forums.powershell.org/t/pipeline-multiple-parameters-fails/11428/6 "2018-10-06T12:19:26Z")

</div>

Here’s what I ended up with, confirmed functioning as wanted.

```
Invoke-SqlCmd -ServerInstance $SqlServer -Query "Select [SqlServer] = @@Servername, [Database] = name, [Recovery] = 'Simple' from master.sys.databases where database_id > 4 AND name like 'reporting_%' AND state_desc = 'ONLINE' AND user_access_desc = 'MULTI_USER' AND recovery_model_desc != 'SIMPLE'" | Set-RecoveryModel -Verbose
```

```
Function Set-RecoveryModel

{

[CmdletBinding()]

param (

[Parameter(Mandatory=$true, ValuefromPipelineByPropertyName=$true,Position=0)]

[Alias('IPAddress','CN')]

[string]$SqlServer ,

[Parameter(Mandatory=$true, ValuefromPipelineByPropertyName=$true,Position=1)]

[string]$Database ,

[Parameter(Mandatory=$false, ValuefromPipelineByPropertyName=$true,Position=2)]

[string]$Recovery = "Simple"

)

BEGIN {

Write-Verbose "Loading Module"

[System.Reflection.Assembly]::LoadWithPartialName("Microsoft.SqlServer.SMO") | out-null

}

PROCESS {

Write-Verbose $SqlServer

Write-Verbose $Database

Write-Verbose $Recovery

Write-Verbose "Setting recovery"

$Srv = New-Object ('Microsoft.SqlServer.Management.Smo.Server') $SqlServer

$Srv.Databases[$Database].RecoveryModel = $Recovery

Try {

$Srv.Databases[$Database].Alter()

} catch {

Write-Verbose "Error: $($_.Exception.Message)`r`n$($_.Exception.ItemName)"

Continue

}

$Srv.Databases[$Database].Refresh()

}

END {

Write-Verbose "All Done"

}

}
```

---

<div class="post-metadata">

**Author:** ![dotnVo](https://avatars.discourse-cdn.com/v4/letter/d/4af34b/32.png) [@dotnVo](https://forums.powershell.org/u/dotnVo)\
**Post date:** [May 16, 2024, 8:34pm UTC](https://forums.powershell.org/t/pipeline-multiple-parameters-fails/11428/7 "2024-05-16T20:34:29Z")

</div>