Thursday 11 February 2016

Not enough storage is available to process this command. (Exception from HRESULT 0x80070008)


When executing a PowerShell script using the invoke-command to remotely access several web servers, I encountered the following error message emanating from one of the servers.


The error message means the quota management of the remote shell is limited the amount of memory allocated to that shell. This allows the system to handle resource more efficiently. To resolve this issue it involves accessing the server locally and manually change the PowerShell MaxMemoryPerShellMB settings directly.

To resolve this error, login locally to the server, open a PowerShell session and run the following. 

sl WSMan:\localhost\Shell

Then check the size of memory allocated by running this

dir | Where-Object {$_.name -eq 'MaxMemoryPerShellMB' }

or the shorter version

get-item MaxMemoryPerShellMB

Below you can see the PowerShell memory setting was set to 100Mb.

I increased this with an extra 100mb set to total 200mb.

Set-Item WSMan:\localhost\Shell\MaxMemoryPerShellMB 200


So now when i run invoke-command remotely, the error did not occur and get the result I wanted.


Sunday 24 January 2016

Setup Error for SSIS installation on Clustered Environment.

  

During an installation of SSIS on a passive clustered node, the SCC was generating the errors below in the setup logs. This was preventing the installation of the SSIS engine on the passive node.

After some investigation, it was discovered there was a previous uninstalled Sql instance that did not appear to be removed cleanly.

The error message was referencing a disk that did not exist anymore on the clustered environment.

Failed to find a cluster group that owned shared disk: R:

Loaded DLL:C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\sqlsval.dll Version:2005.90.4035.0
Error: Action "InvokeSqlSetupDllAction" threw an exception during execution.  Error information reported during run:
  Source File Name: datastore\cachedpropertycollection.cpp
Compiler Timestamp: Mon Nov 17 17:05:55 2008
     Function Name: CachedPropertyCollection::findProperty
Source Line Number: 130
----------------------------------------------------------
Failed to find property "ComputerList" {"SqlComputers", "", ""} in cache
      Source File Name: datastore\clusterinfocollector.cpp
    Compiler Timestamp: Mon Nov 17 17:05:55 2008
         Function Name: ClusterInfoCollector::collectClusterVSInfo
    Source Line Number: 888
    ----------------------------------------------------------
    Failed to detect VS info due to datastore exception.
          Source File Name: datastore\clustergroupsproperties.cpp
        Compiler Timestamp: Mon Nov 17 17:05:55 2008
             Function Name: ClusterGroupScope.SharedDisks
        Source Line Number: 56
        ----------------------------------------------------------
        Failed to find a cluster group that owned shared disk: R:
WinException : 2
        Error Code: 0x80070002 (2)
Windows Error Text: The system cannot find the file specified.
  Source File Name: datastore\clustergroupsproperties.cpp
Compiler Timestamp: Mon Nov 17 17:05:55 2008
     Function Name: ClusterGroupScope.SharedDisks
Source Line Number: 56







Solution:

The solution was to re-introduce a new disk named R: to the cluster available storage.




Then running SSIS setup again, the installation ran smoothly without error.
Issue resolved.