Before submitting a bug report:

• [ x] Ensure you are able to reproduce it on the latest released version (we release often)
• [ x] Verified this bug is not already reported in an issue
• [ ?] Verified errors are not related to permissions
• [ x] Can reproduce in a clean PowerShell session (clean = powershell -NoProfile)

Steps to Reproduce

Install-DbaWhoIsActive -SqlInstance SESTODS030 -Database maintenance -Force -EnableException

This fails on some of our servers but works on most of them. I can also run the same command remotely from a client and it works.

Expected Behavior

I expect to get WhoIsActive installed

Actual Behavior

Exception calling "ExecuteNonQuery" with "1" argument(s): "ExecuteNonQuery failed for Database 'maintenance'. "
At C:\Program Files\WindowsPowerShell\Modules\dbatools\0.9.439\allcommands.ps1:99210 char:9

•     throw $records[0]
  

•     ~~~~~~~~~~~~~~~~~
  

  • CategoryInfo : NotSpecified: (SESTODS030:String) [], Exception
  • FullyQualifiedErrorId : dbatools_Install-DbaWhoIsActive

Environmental data

Name Value

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

• PowerShell:
• • SQL Server:
    Microsoft SQL Server 2014 (SP2-CU12) (KB4130489) - 12.0.5589.7 (X64) Jun 9 2018 11:17:15 Copyright (c) Microsoft Corporation Standard Edition (64-bit) on Windows NT 6.3 (Build 14393: ) (Hypervisor)