SQL Server 2008 Add node setup hangs for hours at “Install SQL_DTS_VSTAConfiguration_install_Cpu64: RollbackCleanup: Removing backup files”


We recently encountered a situation while trying to ‘Add a node’ to the SQL 2008 Cluster

The installation hung for hours at Install SQL_DTS_VSTAConfiguration_install_Cpu64: RollbackCleanup: Removing backup files

It may also hang at Install_VS_Shell_Cpu32_Action: RollbackCleanup: Removing backup files

We do not see any error messages from the SQL setup, however the setup just hangs and does not proceed

• From the System logs we should see the VS template warning and the particular msi which is not letting the SQL setup go through

  

Log Name:      Application
    Source:        Visual Studio - VsTemplate
    Date:          2/7/2014 7:55:01 PM
    Event ID:      1
    Task Category: None
    Level:         Warning
    Keywords:      Classic
    User:          N/A
    Computer:      ABC.XYZ.LOCAL
    Description:
    Error in Template (C:\Program Files (x86)\Microsoft Visual Studio 9.0\Common7\IDE\ItemTemplates\CSharp\Code\1033\Class.zip), file (Class.vstemplate).  Unregistered ProjectType (CSharp).  This can be caused by an incorrect ProjectType or because the project type package is not installed.
    Event Xml:
    <Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
      <System>
        <Provider Name="Visual Studio - VsTemplate" />
        <EventID Qualifiers="49152">1</EventID>
        <Level>3</Level>
        <Task>0</Task>
        <Keywords>0x80000000000000</Keywords>
        <TimeCreated SystemTime="2014-02-07T18:55:01.000Z" />
        <EventRecordID>1046</EventRecordID>
        <Channel>Application</Channel>
        <Computer>ABC.XYZ.LOCAL</Computer>
        <Security />
      </System>
      <EventData>
        <Data>Error in Template (C:\Program Files (x86)\Microsoft Visual Studio 9.0\Common7\IDE\ItemTemplates\CSharp\Code\1033\Class.zip), file (Class.vstemplate).  Unregistered ProjectType (CSharp).  This can be caused by an incorrect ProjectType or because the project type package is not installed.</Data>
      </EventData>
    </Event>

  
  

Log Name:      Application
    Source:        MsiInstaller
    Date:          2/7/2014 7:52:49 PM
    Event ID:      1040
    Task Category: None
    Level:         Information
    Keywords:      Classic
    User:          TESTUSER\XYZSQLSVC
    Computer:      ABC.XYZ.LOCAL
    Description:
    Beginning a Windows Installer transaction: C:\SQL2008\x64\setup\vs_shell.msi. Client Process Id: 7512.
    Event Xml:
    <Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
      <System>
        <Provider Name="MsiInstaller" />
        <EventID Qualifiers="0">1040</EventID>
        <Level>4</Level>
        <Task>0</Task>
        <Keywords>0x80000000000000</Keywords>
        <TimeCreated SystemTime="2014-02-07T18:52:49.000Z" />
        <EventRecordID>1043</EventRecordID>
        <Channel>Application</Channel>
        <Computer>ABC.XYZ.LOCAL</Computer>
        <Security UserID="S-1-5-21-2648667412-578919172-3512332051-3665" />
      </System>
      <EventData>
        <Data>C:\SQL2008\x64\setup\vs_shell.msi</Data>
        <Data>7512</Data>
        <Data>(NULL)</Data>
        <Data>(NULL)</Data>
        <Data>(NULL)</Data>
        <Data>
        </Data>
        <Data>
        </Data>
      </EventData>
< /Event>

If you look at the detail.txt you may find it is stalled at the below point

SSIS: Running: C:\Program Files (x86)\Microsoft Visual Studio 9.0\Common7\IDE\vsta.exe /hostid SSIS_ScriptTask /setup

It does not indicate a  failed execution of the script. Infact running this from the Command prompt manually would work, but it still didn’t let us proceed with the setup

Here’s how the Detail.txt would look like

14-02-08 04:39:57 Slp: Sco: Attempting to open registry subkey SOFTWARE\Microsoft\Microsoft SQL Server\100\SSIS
2014-02-08 04:39:57 Slp: Sco: Attempting to set value LogPackageExecutionToEventLog
2014-02-08 04:39:57 Slp: SetValue: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\100\SSIS, Name = LogPackageExecutionToEventLog
2014-02-08 04:39:57 Slp: Sco: Attempting to create base registry key HKEY_LOCAL_MACHINE, machine
2014-02-08 04:39:57 Slp: Sco: Attempting to open registry subkey
2014-02-08 04:39:57 Slp: Sco: Attempting to open registry subkey SOFTWARE\Microsoft\Microsoft SQL Server\100\SSIS
2014-02-08 04:39:57 Slp: Sco: Attempting to set value LogPackageExecutionToEventLog
2014-02-08 04:39:57 Slp: SetValue: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\100\SSIS, Name = LogPackageExecutionToEventLog
2014-02-08 04:39:57 SSIS: SetRegistryValues() done
2014-02-08 04:39:57 SSIS: STATUS: Install_ConfigNonRC completed
2014-02-08 04:39:57 SSIS: SSIS_Config: Install Timing: ConfigNonRC completed
2014-02-08 04:39:57 Slp: SlpConfigAction.ExecuteAction(actionId: SSISConfigAction_install_postmsi_Cpu64) completed
2014-02-08 04:39:57 Slp: Checkpoint: INSTALL:CONFIGNONRC:SQL_DTS_FULL
2014-02-08 04:39:57 Slp: Completed Action: SSISConfigAction_install_postmsi_Cpu64, returned True
2014-02-08 04:39:57 Slp: ---- Flush datastore cache before calling configuration action 'SQL_DTS_VSTAConfiguration_install_Cpu64'
2014-02-08 04:39:57 Slp: ---- Flush datastore cache before calling configuration action 'SQL_DTS_VSTAConfiguration_install_Cpu64'
2014-02-08 04:39:57 Slp: ----------------------------------------------------------------------
2014-02-08 04:39:57 Slp: Running Action: SQL_DTS_VSTAConfiguration_install_Cpu64
2014-02-08 04:39:57 Slp: Action Data:
2014-02-08 04:39:57 Slp:   Feature = SQL_DTS_Full_sql_is_Cpu64
2014-02-08 04:39:57 Slp:   Scenario = install
2014-02-08 04:39:57 Slp:   Timing = ConfigNonRC
2014-02-08 04:39:57 Slp:   ConfigObjectType = Microsoft.SqlServer.Configuration.SSIS.VSTAConfigurationPrivate
2014-02-08 04:39:57 Slp:   FeatureName = SQL_DTS_Full
2014-02-08 04:39:57 Slp:   FeatureCpuType = Cpu64
2014-02-08 04:39:57 Slp:   FeaturePackageId = sql_is
2014-02-08 04:39:58 Slp: Sco: Attempting to create base registry key HKEY_LOCAL_MACHINE, machine
2014-02-08 04:39:58 Slp: Sco: Attempting to open registry subkey
2014-02-08 04:39:58 Slp: Sco: Attempting to open registry subkey SOFTWARE\Microsoft\NET Framework Setup\NDP\v3.5
2014-02-08 04:39:58 Slp: Sco: Attempting to get registry value InstallPath
2014-02-08 04:39:58 SSIS: Running: c:\Windows\Microsoft.NET\Framework\v3.5\AddInUtil.exe -PipelineRoot:"C:\Program Files (x86)\Common Files\microsoft shared\VSTA\Pipeline" -Rebuild
2014-02-08 04:39:58 SSIS: Application succeded: c:\Windows\Microsoft.NET\Framework\v3.5\AddInUtil.exe -PipelineRoot:"C:\Program Files (x86)\Common Files\microsoft shared\VSTA\Pipeline" -Rebuild
2014-02-08 04:39:58 Slp: Sco: Attempting to create base registry key HKEY_LOCAL_MACHINE, machine
2014-02-08 04:39:58 Slp: Sco: Attempting to open registry subkey
2014-02-08 04:39:58 Slp: Sco: Attempting to open registry subkey SOFTWARE\Microsoft\VSTA\9.0
2014-02-08 04:39:58 Slp: Sco: Attempting to get registry value InstallDir
2014-02-08 04:39:58 SSIS: Running: C:\Program Files (x86)\Microsoft Visual Studio 9.0\Common7\IDE\vsta.exe /hostid SSIS_ScriptTask /setup

We found that the the following Visual studio components were previously installed on the server before installing SQL Server

  • Visual Studio Tools for Applications 2.0
  • Visual Studio 2008 Shell (integrated mode)

The above issue happens to be due to the incompatibility of SQL Server with either a Visual Studio or .NET framework component

The incompatibility is explained in detail the blog :http://blogs.msdn.com/b/psssql/archive/2008/08/11/sql-server-2008-visual-studio-2008-sp1-and-net-framework-3-5-sp1-explained.aspx

We see these Stalls in the setup when it is trying to install the below components only

  • Business Intelligence Development Studio
  • Integration Services
  • Management Tools (Either Basic or Full)

Since this was a new server which was going to be a dedicated SQL server we Uninstalled the following components from the control panel

Visual Studio Tools for Applications 2.0
Visual Studio 2008 Shell (integrated mode)
SQL server Compact Edition

Repaired the .NET Framework 3.5 SP1 and then re-run the SQL setup

In most cases the issue is very clear with the Setup giving us a failed rule
Rule "Previous releases of Microsoft Visual Studio 2008" failed

image

But in our case, the setup only hung with No error messages or failed rule except for the  the warning for VS template in the System log .

As summarized in the blog : http://blogs.msdn.com/b/psssql/archive/2008/08/11/sql-server-2008-visual-studio-2008-sp1-and-net-framework-3-5-sp1-explained.aspx we could follow the below steps based on environment (However If this dedicated Database server the easiest option would be uninstall the VS components before installing SQL server and reinstall them after the SQL setup is complete)

1) If you don't have Visual Studio 2008 installed and have never installed a SQL Server 2008 CTP build, SQL Server 2008 RTM comes with everything you need and you should not encounter this problem.

2) If have Visual Studio 2008 installed, you must install VS 2008 SP1 before you install SQL Server 2008 RTM (or don't pick features that require it -BIDS, Management Studio, SSIS)

3) If you do not have VS 2008 installed but are encountering this problem, do not attempt to install VS 2008 SP1. Rather, uninstall Visual Studio 2008 Shell (integrated mode) and Visual Studio Tools for Applications 2.0. You should then be allowed to proceed with the installation.

4) SQL Server 2008 RTM comes with the .Net Framework 3.5 SP1 final release. This requirement is independent of the binaries we need from VS 2008 SP1. There is no need for you to run any update to the .Net Framework after installing SQL Server 2008.

5) If you install Visual Studio 2008 RTM after installing SQL Server 2008 RTM, you must install VS 2008 SP1 to be supported if you are using the features in SQL Server that depend on VS 2008 SP1 (BIDS, Integration Services, or Management Tools

Related Blogs : http://blogs.msdn.com/b/guil/archive/2008/12/14/sql-server-2008-installation-dependency-problems-with-visual-studio-2008-sp1.aspx

http://blogs.msdn.com/b/psssql/archive/2008/08/11/sql-server-2008-visual-studio-2008-sp1-and-net-framework-3-5-sp1-explained.aspx


Comments (1)

  1. Akash Gautam says:

    Thanks Pooja, Your blog helped me

Skip to main content