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.


No comments:

Post a Comment