Skip to content

Install-DbaMaintenanceSolution Write-Progress never closes #9668

Open
@SaintNick2023

Description

@SaintNick2023

Verified issue does not already exist?

No, I did not search

What error did you receive?

In VS Code, when calling dbatools\Install-DbaMaintenanceSolution, its Write-Progress banner obscures other underlying terminal output and persists without ever closing.

Image

Could it be that Install-DbaMaintenanceSolution could and should issue the following?

Write-ProgressHelper -Completed

Steps to Reproduce

$paramsOla = @{
    SqlInstance = ""                      # Updated in loop per instance
    Database = $BackupDatabase            # Database for installation of Maintenance Solution 
    Solution = "All"                      # Install which solutions (All, Backup, IntegrityCheck, IndexOptimize)
    ReplaceExisting = $true               # Overwrite existing solution
    InstallParallel = $false              # Install in parallel if supported (dbatools param)
    InstallJobs = $false                  # DO NOT Create Ola's default jobs; we create our own.
    LogToTable = $false                   # Log operations to table
    BackupLocation = $LocalBackupLocation # Default backup path 

$null = dbatools\Install-DbaMaintenanceSolution @paramsOla -EnableException | Out-Null

Please confirm that you are running the most recent version of dbatools

Name Version


dbatools 2.1.30

Other details or mentions

No response

What PowerShell host was used when producing this error

VS Code (integrated terminal)

PowerShell Host Version

$PSVersionTable | Out-String

Name Value


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

SQL Server Edition and Build number

Microsoft SQL Server 2017 (RTM-CU31-OD) (KB5050533) - 14.0.3490.10 (X64) Feb 19 2025 12:19:28 Copyright (C) 2017 Microsoft Corporation Standard Edition (64-bit) on Windows Server 2016 Datacenter 10.0 (Build 14393: ) (Hypervisor)

.NET Framework Version

.NET Framework 4.8.4785.0

Metadata

Metadata

Assignees

No one assigned

    Labels

    bugs lifetriage requiredNew issue that has not been reviewed by maintainers

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions