SQLPSX icon indicating copy to clipboard operation
SQLPSX copied to clipboard

Issues running - import-module sqlpsx

Open eliassal opened this issue 9 years ago • 0 comments

Hi Mike, when I run the command ◾import-module sqlpsx Several modules succesflyu get imported but I get several errors as follows(my PS version is 5 on win 10)

Loading SQLPSX Module - SQLmaint
Loading SQLPSX Module - SQLServer
Loading SQLPSX Module - Agent
Loading SQLPSX Module - Repl
add-type : Could not load file or assembly 'Microsoft.SqlServer.Rmo, Version=9.0.242.0, Culture=neutral, 
PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified.
At C:\Users\salam.SALAM\Documents\WindowsPowerShell\Modules\Repl\Repl.psm1:17 char:8
+ catch {add-type -AssemblyName "Microsoft.SqlServer.Rmo"}
+        ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    + CategoryInfo          : NotSpecified: (:) [Add-Type], FileNotFoundException
    + FullyQualifiedErrorId : System.IO.FileNotFoundException,Microsoft.PowerShell.Commands.AddTypeCommand

Loading SQLPSX Module - SSIS
add-type : Cannot add type. The assembly 'Microsoft.SqlServer.ManagedDTS, Version=10.0.0.0, Culture=neutral, 
PublicKeyToken=89845dcd8080cc91' could not be found.
At C:\Users\salam.SALAM\Documents\WindowsPowerShell\Modules\SSIS\SSIS.psm1:21 char:5
+     add-type -AssemblyName "Microsoft.SqlServer.ManagedDTS, Version=1 ...
+     ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    + CategoryInfo          : ObjectNotFound: (Microsoft.SqlSe...9845dcd8080cc91:String) [Add-Type], Exception
    + FullyQualifiedErrorId : ASSEMBLY_NOT_FOUND,Microsoft.PowerShell.Commands.AddTypeCommand

add-type : Cannot add type. One or more required assemblies are missing.
At C:\Users\salam.SALAM\Documents\WindowsPowerShell\Modules\SSIS\SSIS.psm1:21 char:5
+     add-type -AssemblyName "Microsoft.SqlServer.ManagedDTS, Version=1 ...
+     ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    + CategoryInfo          : InvalidData: (:) [Add-Type], InvalidOperationException
    + FullyQualifiedErrorId : ASSEMBLY_LOAD_ERRORS,Microsoft.PowerShell.Commands.AddTypeCommand

Loading SQLPSX Module - Showmbrs
Loading SQLPSX Module - SQLParser
Loading SQLPSX Module - adolib
Loading SQLPSX Module - SQLIse
Exception calling "GetUserStoreForAssembly" with "0" argument(s): "Unable to determine granted permission for 
assembly."
At C:\Users\salam.SALAM\Documents\WindowsPowerShell\Modules\SQLIse\Library-UserStore.ps1:6 char:5
+     $userStore = [System.IO.IsolatedStorage.IsolatedStorageFile]::Get ...
+     ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    + CategoryInfo          : NotSpecified: (:) [], MethodInvocationException
    + FullyQualifiedErrorId : IsolatedStorageException

You cannot call a method on a null-valued expression.
At C:\Users\salam.SALAM\Documents\WindowsPowerShell\Modules\SQLIse\Library-UserStore.ps1:8 char:9
+     if ($userStore.GetDirectoryNames($dirName))
+         ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    + CategoryInfo          : InvalidOperation: (:) [], RuntimeException
    + FullyQualifiedErrorId : InvokeMethodOnNull

Exception calling "GetUserStoreForAssembly" with "0" argument(s): "Unable to determine granted permission for 
assembly."
At C:\Users\salam.SALAM\Documents\WindowsPowerShell\Modules\SQLIse\Library-UserStore.ps1:38 char:5
+     $userStore = [System.IO.IsolatedStorage.IsolatedStorageFile]::Get ...
+     ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    + CategoryInfo          : NotSpecified: (:) [], MethodInvocationException
    + FullyQualifiedErrorId : IsolatedStorageException

You cannot call a method on a null-valued expression.
At C:\Users\salam.SALAM\Documents\WindowsPowerShell\Modules\SQLIse\Library-UserStore.ps1:40 char:9
+     if (-not $userStore.GetDirectoryNames($dirName))
+         ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    + CategoryInfo          : InvalidOperation: (:) [], RuntimeException
    + FullyQualifiedErrorId : InvokeMethodOnNull

You cannot call a method on a null-valued expression.
At C:\Users\salam.SALAM\Documents\WindowsPowerShell\Modules\SQLIse\Library-UserStore.ps1:65 char:9
+         $file.Close()
+         ~~~~~~~~~~~~~
    + CategoryInfo          : InvalidOperation: (:) [], RuntimeException
    + FullyQualifiedErrorId : InvokeMethodOnNull

You cannot call a method on a null-valued expression.
At C:\Users\salam.SALAM\Documents\WindowsPowerShell\Modules\SQLIse\Library-UserStore.ps1:66 char:9
+         $userStore.Close()
+         ~~~~~~~~~~~~~~~~~~
    + CategoryInfo          : InvalidOperation: (:) [], RuntimeException
    + FullyQualifiedErrorId : InvokeMethodOnNull

Exception calling "GetUserStoreForAssembly" with "0" argument(s): "Unable to determine granted permission for 
assembly."
At C:\Users\salam.SALAM\Documents\WindowsPowerShell\Modules\SQLIse\Library-UserStore.ps1:6 char:5
+     $userStore = [System.IO.IsolatedStorage.IsolatedStorageFile]::Get ...
+     ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    + CategoryInfo          : NotSpecified: (:) [], MethodInvocationException
    + FullyQualifiedErrorId : IsolatedStorageException

Exception calling "GetUserStoreForAssembly" with "0" argument(s): "Unable to determine granted permission for 
assembly."
At C:\Users\salam.SALAM\Documents\WindowsPowerShell\Modules\SQLIse\Library-UserStore.ps1:77 char:5
+     $userStore = [System.IO.IsolatedStorage.IsolatedStorageFile]::Get ...
+     ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    + CategoryInfo          : NotSpecified: (:) [], MethodInvocationException
    + FullyQualifiedErrorId : IsolatedStorageException

Read-UserStore : Cannot open file SQLIse\options.txt
At C:\Users\salam.SALAM\Documents\WindowsPowerShell\Modules\SQLIse\SQLIse.psm1:43 char:12
+ $options = Read-UserStore -fileName "options.txt" -dirName "SQLIse" - ...
+            ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    + CategoryInfo          : NotSpecified: (:) [Write-Error], WriteErrorException
    + FullyQualifiedErrorId : Microsoft.PowerShell.Commands.WriteErrorException,Read-UserStore

Loading SQLPSX Modules is Done!

eliassal avatar Jun 27 '16 10:06 eliassal