执行AFDiag.exe提示未被识别的PowerShell脚本问题排查

我编写了一个PowerShell脚本，用于携带参数执行AFDiag.exe，示例命令如下：

AFDiag.exe /Database:"Distributed SYS_Test" /Template:"STS-Heartbeat" /DelEF:"2024-06-01 00:00:00";"2024-06-03 15:00:00"

但脚本执行时始终报错：The term 'AFDiag.exe' is not recognized as the name of a cmdlet, function, script file, or operable program。尝试切换到AFDiag.exe所在目录后直接调用，问题依然存在。以下是脚本代码及完整错误信息：

脚本代码 #

# Define paths and parameters
$AFDiagPath = "D:\Program Files\PIPC\AF\AFDiag.exe"
$TemplatesFile = "D:\Scripts\PI AF Monthly Cleanup\cfg\PIAF MDB Cleanup Templates.csv"
$AFDatabase = "Distributed SYS_Test"
$OutputFolder = "D:\Scripts\PI AF Monthly Cleanup\log"

# Calculate date range (today and last 30 days)
$EndDate = Get-Date
$StartDate = $EndDate.AddDays(-30)

# Format dates for AFDiag
$StartDateFormatted = $StartDate.ToString("yyyy-MM-dd")
$EndDateFormatted = $EndDate.ToString("yyyy-MM-dd")

# Read template names from CSV file
$TemplateNames = Import-Csv -Path $TemplatesFile | Select-Object -ExpandProperty AFTemplates

# Create a timestamp for the log file
$Timestamp = Get-Date -Format "yyyyMMdd-HHmmss"
$LogFileName = "piaf-mdbc-log-$Timestamp.txt"
$LogFile = Join-Path -Path $OutputFolder -ChildPath $LogFileName

# Iterate through template names and execute AFDiag command
foreach ($TemplateName in $TemplateNames) {
    # $AFDiagCommand = "AFDiag.exe /Database:`"$AFDatabase`" /Template:`"$TemplateName`" /DelEF:`"$StartDateFormatted`";`"$EndDateFormatted`""
    $AFDiagCommand = "$AFDiagPath /Database:`"$AFDatabase`" /Template:`"$TemplateName`" /DelEF:`"$StartDateFormatted`";`"$EndDateFormatted`""
    $Result = Invoke-Expression $AFDiagCommand

    # Append result to the log file
    $Result | Out-File -Append -FilePath $LogFile
}

# Display a message
Write-Host "AFDiag commands executed. Results logged in $LogFile"

错误信息 #

AFDiag.exe : The term 'AFDiag.exe' is not recognized as the name of a cmdlet, function, script file, or operable program. Check the spelling of the name, or if a path was 
included, verify that the path is correct and try again.
At line:1 char:1
+ AFDiag.exe /Database:"Distributed SYS_Test" /Template:"STS-Heartbea ...
+ ~~~~~~~~~~
    + CategoryInfo          : ObjectNotFound: (AFDiag.exe:String) [], CommandNotFoundException
    + FullyQualifiedErrorId : CommandNotFoundException

排查与解决 #

问题根源 #

1. 路径空格解析错误：$AFDiagPath包含空格（Program Files），使用Invoke-Expression拼接字符串时，PowerShell会将路径拆分，导致无法识别完整的可执行文件路径。
2. 参数分隔符冲突：/DelEF参数中的分号;是PowerShell的命令分隔符，直接拼接会导致参数被错误拆分。

修复方案 #

替换Invoke-Expression为直接调用可执行文件的方式，同时规范参数传递：

foreach ($TemplateName in $TemplateNames) {
    # 构建完整参数数组，避免解析歧义
    $params = @(
        "/Database:`"$AFDatabase`"",
        "/Template:`"$TemplateName`"",
        "/DelEF:`"$StartDateFormatted`";`"$EndDateFormatted`""
    )
    # 使用&调用带空格路径的可执行文件，捕获输出
    $Result = & $AFDiagPath $params
    $Result | Out-File -Append -FilePath $LogFile
}

额外验证步骤 #

1. 手动在PowerShell中执行& "D:\Program Files\PIPC\AF\AFDiag.exe"，确认程序能正常启动，排除路径错误或权限问题。
2. 若仍报错，检查PowerShell位数：如果AFDiag是32位程序，需使用32位PowerShell（C:\Windows\SysWOW64\WindowsPowerShell\v1.0\powershell.exe）执行脚本，反之亦然。

内容的提问来源于stack exchange，提问作者NanoNet