PowerShell integrated Console - version no.

[rebornix]

From @lw-schick on March 22, 2017 13:4

Description

I can't import the PowerShell module SSASCMDLETS from SQL Server Analytics Service.

Steps to Reproduce:

• VSCode Version: 1.10.2
• OS Version: Windows 7 64x

1. Install SQL Server with Analytics Service
2. Run Import-Module SSASCMDLETS

Results in:

PS C:\myfolder> Import-Module SQLASCMDLETS
Import-Module : The current Windows PowerShell host is: 'Visual Studio Code Host' (version 0.10.1). The module 'C:\Program Files (x86)\Microsoft SQL
Server\110\Tools\PowerShell\Modules\SQLASCMDLETS\SQLASCMDLETS.psd1' requires a minimum Windows PowerShell host version of '1.0' to run.
At line:1 char:1
+ Import-Module SQLASCMDLETS
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~
    + CategoryInfo          : ResourceUnavailable: (C:\Program File...LASCMDLETS.psd1:String) [Import-Module], InvalidOperationException
    + FullyQualifiedErrorId : Modules_InsufficientPowerShellHostVersion,Microsoft.PowerShell.Commands.ImportModuleCommand

PS C:\myfolder>

The PSVersionTable looks OK:

PS C:\myfolder> $PSVersionTable

Name                           Value
----                           -----
PSVersion                      5.0.10586.117
PSCompatibleVersions           {1.0, 2.0, 3.0, 4.0...}
BuildVersion                   10.0.10586.117
CLRVersion                     4.0.30319.42000
WSManStackVersion              3.0
PSRemotingProtocolVersion      2.3
SerializationVersion           1.1.0.1


PS C:\myfolder>

Copied from original issue: microsoft/vscode#23017

[rebornix]

It's very likely a Powershell issue, please file against the powershell extension you are using :)

[daviwil]

This seems like an unnecessary limitation of the SQL module, it is throwing an error because the $host.Version reported inside of the Integrated Terminal is below 1.0. I'm reluctant to bump our host version to 1.0 just to make the SQL module happy but I doubt they'd be able to respond to this in the short term to unblock you. I'll fix it for 0.11.0, coming out later today.

[lw-schick]

Thanks @daviwil

[daviwil]

@lw-schick did the 0.11.0 update fix it for you?

[lw-schick]

Yes:

Starting PowerShell...

PS C:\git\OlapDbMetaData> Import-Module SQLASCMDLETS
PS C:\git\OlapDbMetaData>

now all is fine

[daviwil]

Great, thanks for confirming!

[szhivotovsky]

Ran across this closed case. I'm running into the same issue with a different module. I'm on v0.12.2.

import-module : The current Windows PowerShell host is: 'Visual Studio Code Host' (version 1.0.0). The module
'/usr/local/microsoft/powershell/6.0.0-alpha.18/Modules/Okta-PSModule-master/Okta.psd1' requires a minimum Windows PowerShell host version of '3.0' to run.
At line:1 char:1

PS /usr/local/microsoft/powershell/6.0.0-alpha.18/Modules> $host

Name : Visual Studio Code Host
Version : 1.0.0

Can anything be done here? Thanks!

[daviwil]

@szhivotovsky Do you know why the module is looking for a specific host and host version? That seems like a bad idea in general because it prevents that module from being loaded in any other host. Can you ask the module author to loosen their check?

[vikashdaya]

@szhivotovsky ... found this while looking for the same issue.
If you change the version of the host in the Okta.psd1 file to 1.0, the module with load and work...

Minimum version of the Windows PowerShell host required by this module
PowerShellHostVersion = '1.0'