Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Issues running - import-module sqlpsx #13

Open
eliassal opened this issue Jun 27, 2016 · 0 comments
Open

Issues running - import-module sqlpsx #13

eliassal opened this issue Jun 27, 2016 · 0 comments

Comments

@eliassal
Copy link

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!
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant