PowerShell脚本删除MSI文件遭占用错误的解决方法

问题根源是你通过Windows Installer COM对象打开MSI数据库后，未显式关闭相关资源，导致系统持续锁定文件，无法执行删除操作。需在删除文件前手动关闭打开的视图、数据库，并释放COM对象，解除文件锁。

修改后的完整脚本如下：

$signalsciencesAgent= Get-Item -Path "C:\Users\Shamim Reza\Desktop\zipfolderpath\sigsci-agent_latest.msi"
if (!(Test-Path $signalsciencesAgent.FullName)) {
    throw "File '{0}' does not exist" -f $signalsciencesAgent.FullName
}

# 初始化COM资源变量，方便后续判断释放
$windowsInstaller = $null
$database = $null
$View = $null
$record = $null
 
try {
    $windowsInstaller = New-Object -com WindowsInstaller.Installer
    $database = $windowsInstaller.GetType().InvokeMember(
        "OpenDatabase", "InvokeMethod", $Null,
        $windowsInstaller, @($signalsciencesAgent.FullName, 0) 
    )
 
    $q = "SELECT Value FROM Property WHERE Property = 'ProductVersion'"
    $View = $database.GetType().InvokeMember(
        "OpenView", "InvokeMethod", $Null, $database, ($q)
    )
 
    $View.GetType().InvokeMember("Execute", "InvokeMethod", $Null, $View, $Null) 
    $record = $View.GetType().InvokeMember( "Fetch", "InvokeMethod", $Null, $View, $Null ) 
    $signalsciencesagentversion = $record.GetType().InvokeMember( "StringData", "GetProperty", $Null, $record, 1 )

    # 可选：输出获取到的版本信息
    Write-Host "MSI产品版本: $signalsciencesagentversion"

} catch {
    throw "获取MSI版本失败: {0}." -f $_
}

Finally
{
    # 按顺序关闭并释放所有COM资源
    if ($View) {
        $View.GetType().InvokeMember("Close", "InvokeMethod", $Null, $View, $Null)
        [System.Runtime.Interopservices.Marshal]::ReleaseComObject($View) | Out-Null
    }
    if ($database) {
        [System.Runtime.Interopservices.Marshal]::ReleaseComObject($database) | Out-Null
    }
    if ($windowsInstaller) {
        [System.Runtime.Interopservices.Marshal]::ReleaseComObject($windowsInstaller) | Out-Null
    }

    # 强制触发垃圾回收，确保未释放的资源被清理
    [System.GC]::Collect()
    [System.GC]::WaitForPendingFinalizers()

    # 确认文件存在后执行删除
    if (Test-Path $signalsciencesAgent.FullName) {
        Remove-Item $signalsciencesAgent -Force
    }
}

核心修改说明：

• 提前初始化所有COM对象变量为$null，便于后续判断是否需要释放
• 在finally块中先关闭View（调用Close方法），再通过ReleaseComObject逐一释放View、database、windowsInstaller等COM对象
• 调用垃圾回收强制清理残留资源，确保文件锁完全解除
• 删除前增加文件存在检查，避免无意义的错误抛出

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