Previous Version 3.2.0

Known Issues

This page documents the limitations of the current release, v3.2.0

SQL 2014 RTM install

The released version of SQL FineBuild has been configured to work with SQL 2014 CTP2. If you want to install SQL 2014 RTM you must add the following parameters at run time:
/MenuSQL2014:"Microsoft SQL Server 2014" /SPLevel:RTM

SQL 2005 Cluster Install

The process to add a second node to a SQL 2005 cluster fails with a logon error when trying to schedule tasks on the remote machine.

You will see this problem in the SQL Server install log files folder, in the file with a name ending ...Core(Local).txt with the following message:
Error: 0x80070050 TaskScheduler::NewWorkItem for SQL Server Remote Setup

The major cause of this is a bug in FineBuild2InstallSQL.vbs

Edit this routine and find the lines:
  Select Case True
    Case strClusterName = ""
      ' Nothing
    Case strSQLVersion <> "SQL2005"
      ' Nothing
    Case Left(strOSVersion, 1) >= "6"
      ' Nothing
    Case Else
      strListOpts   = strListOpts & " ADMINPASSWORD=""" & strAdminPassword & """ "
  End Select

Change these to:
  Select Case True
    Case strClusterName = ""
      ' Nothing
    Case strSQLVersion <> "SQL2005"
      ' Nothing
    Case strAdminPassword = ""
      ' Nothing
    Case Else
      strListOpts   = strListOpts & " ADMINPASSWORD=""" & strAdminPassword & """ "
  End Select

Investigation is still proceeding to confirm if this is the only problem. If the problem still exists after this fix, the following command may be necessary on all nodes in your cluster. Replace ROOT\Local with the domain and account name used to run SQL Server installs at your organisation.
Ntrights -u "ROOT\Install" +r SeBatchLogonRight

Installation of SQL 2008 and above clusters is not affected by this problem and works successfully.

SSAS configuration not performed for second SSAS Instance

If multiple SSAS instances are installed on a server, the FineBuild configuration is not performed for the second and subsequent SSAS instances.

The cause of this is a bug in FineBuild5ConfigureSQL.vbs

Edit this routines and find the lines:
  Dim strSetupOLAP
  strSetupOLAP      = GetBuildfileValue("SetupOLAP")
  Select Case True
    Case err.Number <> 0
      ' Nothing
    Case strProcessId > "5BFA"
      ' Nothing
    Case strSetupOLAP <> "YES"
      ' Nothing
    Case strAction = "ADDNODE"
      ' Nothing
    Case strMainInstance <> "YES"
      ' Nothing
    Case Else
      Call ConfigSSASInstance()
  End Select

  Dim strSetupOLAPAPI
  strSetupOLAPAPI   = GetBuildfileValue("SetupOLAPAPI")
  Select Case True
    Case err.Number <> 0
      ' Nothing
    Case strProcessId > "5BFB"
      ' Nothing
    Case strSetupOLAPAPI <> "YES"
      ' Nothing
    Case strSQLVersion = "SQL2005"
      ' Nothing
    Case strAction = "ADDNODE"
      ' Nothing
    Case strMainInstance <> "YES"
      ' Nothing
    Case Else
      Call ConfigSSASManagementAPI()
  End Select

Change these to:
  Dim strSetupOLAP
  strSetupOLAP      = GetBuildfileValue("SetupOLAP")
  Select Case True
    Case err.Number <> 0
      ' Nothing
    Case strProcessId > "5BFA"
      ' Nothing
    Case strSetupOLAP <> "YES"
      ' Nothing
    Case strAction = "ADDNODE"
      ' Nothing
    Case Else
      Call ConfigSSASInstance()
  End Select

  Dim strSetupOLAPAPI
  strSetupOLAPAPI   = GetBuildfileValue("SetupOLAPAPI")
  Select Case True
    Case err.Number <> 0
      ' Nothing
    Case strProcessId > "5BFB"
      ' Nothing
    Case strSetupOLAPAPI <> "YES"
      ' Nothing
    Case strSQLVersion = "SQL2005"
      ' Nothing
    Case strAction = "ADDNODE"
      ' Nothing
    Case Else
      Call ConfigSSASManagementAPI()
  End Select

Copyright © 2012 - 2014 Edward Vassie. License and Acknowledgements

Last edited Mar 31 at 11:02 AM by EdVassie, version 18

Comments

No comments yet.