I have a simple win32 console application (example.exe) which just printf's all its arguments. In the windows registry I've set up a file association so that the file extension ".myfile" invokes "example.exe %1".

In a CMD window running .\example.exe file.myfile displays the output in the cmd window. (this is good)
In a CMD window running .\file.myfile invokes example.exe and displays the output in the cmd window. (this is good)

In a Powershell window running .\example.exe file.myfile displays the output in the powershell window. (this is good)
In a powershell window running .\file.myfile opens a new cmd window, in which example.exe is run, and the output is printed. The cmd windows then closes. (this is NOT good). The console application should run inside the powershell window.

We've been lucky, from what I'm gathering from web searches! Until December last year, Exchange Online Powershell cmdlet help was available using Get-Help in the shell. However, after the Christmas break, the only response we get is:

Get-Help : Exception calling "Invoke" with "0" argument(s): "Cannot find path '' because it does
not exist."
At line:1 char:1
+ Get-Help Get-Mailbox
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~

+ CategoryInfo          : NotSpecified: (:) [Get-Help], MethodInvocationException

+ FullyQualifiedErrorId : CmdletInvocationException

It's the same issue irrespective of the cmdlet.

Consequently, I'm forced to contend with painful searches of the documentation website for information of the relevant cmdlets.

Raised this question on the Github Exchange documentation site (https://github.com/MicrosoftDocs/office-docs-powershell/issues/2440) and Chris Davis, who noticed the issue since June, suggested I raise a support case. So not sure this is the right place to do so.

Powershell 5.1 on both Windows 7/10

Encountering an issue with Start-Transcript, SQLDataReader and Passing it to a function for processing. This occurs in Powershell 6, started in 5.1, was not present in Windows Powershell 3 (Windows Powershell 4 has issues passing the SqlDataReader object to a function anyway).

When you call a function within a Start-Transcript block, and that function then fills a SqlDataReader object, and then passes it onto another function, it increments the record a number of times, as if calling the read() method 7 or 8 times. This causes a number of issues, firstly, a lot of data is skipped for processing, secondly, you end up trying to read data which isn't available, resulting in an error.

This only occurs when Start-Transcript is called before running (and only while the transcript is actually running), and only when passing the SqlDataReader object to another function.
Steps to reproduce

Run the following script. It will output 4 lots of values. The first one will error, the next 3 will not.

It attempts to run in the following manner -

Pass 1 (Fail) - SqlDataReader passed to a function within a Start-Transcript block
Pass 2 (Success) - SqlDataReader passed to a function
Pass 3 (Success) - SqlDataReader processed inline within a Start-Transcript block
Pass 4 (Success) - SqlDataReader processed inline

Replace the $SQLConnectionString string with a real connection string, any SQL database should do (so long as it's SQL 2012+), no data needed in there. Also point the $transcriptPath to a file which can be saved to.

$actualSql = "select top 25 cast(ROW_NUMBER() over(order by name) as nvarchar(255)) from sys.objects"
$SQLConnectionString = "<SQL Connection String Here>"
$transcriptPath = "<Transcript File Path Here>"
function get-Row{

param(

    [System.Data.SqlClient.SqlDataReader] $TempReader

)


$row = @{}

$row["FirstColumn"] = $TempReader.GetSqlValue(0)

return $row

}

function test-SQL{

param(

    [switch]$NoFunctionCall

)

$sqlConn = New-Object System.Data.SqlClient.SqlConnection

$sqlConn.ConnectionString = $SQLConnectionString

$sqlConn.Open()


$sourcecmd = New-Object System.Data.SqlClient.SqlCommand

$sourcecmd.Connection = $sqlConn

$sourcecmd.CommandText = $actualSql

$sourcecmd.CommandTimeout = 600

[System.Data.SqlClient.SqlDataReader] $reader = $sourcecmd.ExecuteReader();

try {

    if ($reader.HasRows -eq $true) {

        while ($reader.Read()) {

            if($NoFunctionCall){

                write-output $reader.GetString(0)

                $processed = @{}

                $processed["FirstColumn"] = $reader.GetSqlValue(0)

                write-output $reader.GetString(0)

                Write-Output $processed.Value

            }

            else{

                write-output $reader.GetString(0)

                $processed = get-Row $reader

                write-output $reader.GetString(0)

                Write-Output $processed.Value

            }

        }

    }

}

catch{

    Write-Error $_.Exception | format-list -force

}

}

Write-Output "Running With Transcript and Function"
Start-Transcript -Path $transcriptPath
test-SQL
Stop-Transcript

Write-Output "."
Write-Output "."
Write-Output "."
Write-Output "Running Without Transcript With Function"
test-SQL

Write-Output "."
Write-Output "."
Write-Output "."
Write-Output "Running With Transcript Without Function"
Start-Transcript -Path $transcriptPath
test-SQL -NoFunctionCall
Stop-Transcript

Write-Output "."
Write-Output "."
Write-Output "."
Write-Output "Running Without Transcript And Function"
test-SQL -NoFunctionCall

Since May 2019 Security Rollup for Windows Server 2016, access to .net object via powershell is very slow, when a powershell variable breakpoint is set in the powershell.

For example loading speed of [System.Environment] takes over ten times with breakpoint set against no breakpoint set.

Since the behavior only occurs with latest security updates installed (May 2019 (KB4494440) or June 2019 (KB4503267)) i think it is related to the update.

Did some troubleshooting with procmon until now. For me it looks like when PSBreakpoint is set, there are multiple reads from HKLM\System\CurrentControlSet\Control\Session Manager\Environment__PSLockdownPolicy can't repoduce this when there is no breakpoint set and can't reproduce this effect without one of the updates installed.

Following powershell code runs more than 10 times slower when i install Windows Security Rollup update Mai / June 2019 on my Windows Server 2016.

$measure1 = measure-command{
foreach($i in 1..10000){

[System.Environment]

}
} |select -ExpandProperty TotalSeconds

Set-PSBreakpoint -Variable "test" -Action {$null}

$measure2 = measure-command{
foreach($i in 1..10000){

[System.Environment]

}
} |select -ExpandProperty TotalSeconds

Write-Host "First measurement took $measure1 seconds, Second measurement took $measure2"

>>First measurement took 0.0482474 seconds, Second measurement took 0.8722697

Tested on:

PSVersion: 5.1.14393.2969
PSEdition: Desktop
PSCompatibleVersions: {1.0, 2.0, 3.0, 4.0...}
BuildVersion:10.0.14393.2969
CLRVersion:4.0.30319.42000
WSManStackVersion:3.0
PSRemotingProtocolVersion:2.3
SerializationVersion:1.1.0.1

Can anyone observe this behavior as well?

Do you have any suggestions to workaround this problem?

Is it related to some settings or installed software?