January 17, 2011 at 8:17 am
I'm trying to install SP2 for SQL 2008 on a Windows 2008 cluster, everything is 64 bit, but the installation fails a few seconds into the process. I've tried to follow the recommended "rolling patch and service pack" process but I can't seem to get past this one point in the initialization of the setup. I see the following in the Detail log file:
2011-01-16 11:11:46 Slp: Initializing rule : Cluster Resource DLL Update Restart Check
2011-01-16 11:11:46 Slp: Rule applied features : ALL
2011-01-16 11:11:46 SQLEngine: --FacetResourceDLLUpdateRestartCheck: Engine_ResourceDLLUpdateRestartCheck: Installing/upgrading/patching instance '', version 10.2.4000.0.
2011-01-16 11:11:46 Slp: Error: Action "GatherUserSettings" threw an exception during execution.
2011-01-16 11:11:46 Slp: Microsoft.SqlServer.Setup.Chainer.Workflow.ActionExecutionException: Thread was being aborted. ---> System.Threading.ThreadAbortException: Thread was being aborted.
2011-01-16 11:11:46 Slp: at System.Threading.WaitHandle.WaitOneNative(SafeHandle waitableSafeHandle, UInt32 millisecondsTimeout, Boolean hasThreadAffinity, Boolean exitContext)
2011-01-16 11:11:46 Slp: at System.Threading.WaitHandle.InternalWaitOne(SafeHandle waitableSafeHandle, Int64 millisecondsTimeout, Boolean hasThreadAffinity, Boolean exitContext)
2011-01-16 11:11:46 Slp: at Microsoft.SqlServer.Configuration.UIExtension.Request.Wait()
2011-01-16 11:11:46 Slp: at Microsoft.SqlServer.Configuration.UIExtension.UserInterfaceProxy.SubmitAndWait(Request request)
2011-01-16 11:11:46 Slp: at Microsoft.SqlServer.Chainer.Infrastructure.Action.Execute(String actionId, TextWriter errorStream)
2011-01-16 11:11:46 Slp: at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionInvocation.InvokeAction(WorkflowObject metabase, TextWriter statusStream)
2011-01-16 11:11:46 Slp: at Microsoft.SqlServer.Setup.Chainer.Workflow.PendingActions.InvokeActions(WorkflowObject metaDb, TextWriter loggingStream)
2011-01-16 11:11:46 Slp: --- End of inner exception stack trace ---
2011-01-16 11:11:46 Slp: at Microsoft.SqlServer.Setup.Chainer.Workflow.PendingActions.InvokeActions(WorkflowObject metaDb, TextWriter loggingStream)
2011-01-16 11:11:47 Slp: Received request to add the following file to Watson reporting: C:\Users\chsaha1\AppData\Local\Temp\tmp8DA.tmp
2011-01-16 11:11:47 Slp: The following is an exception stack listing the exceptions in outermost to innermost order
2011-01-16 11:11:47 Slp: Inner exceptions are being indented
2011-01-16 11:11:47 Slp:
2011-01-16 11:11:47 Slp: Exception type: System.IO.FileNotFoundException
2011-01-16 11:11:47 Slp: Message:
2011-01-16 11:11:47 Slp: The system cannot find the file specified. (Exception from HRESULT: 0x80070002)
2011-01-16 11:11:47 Slp: Stack:
2011-01-16 11:11:47 Slp: at MSClusterLib.ISClusResource.get_CommonROProperties()
2011-01-16 11:11:47 Slp: at Microsoft.SqlServer.Configuration.Cluster.ClusterResource.get_Name()
2011-01-16 11:18:14 Slp: Watson Bucket 1
Original Parameter Values
2011-01-16 11:18:14 Slp: Parameter 0 : SQL2008@RTM@KB2285068
2011-01-16 11:18:14 Slp: Parameter 1 : MSClusterLib.ISClusResource.get_CommonROProperties
2011-01-16 11:18:14 Slp: Parameter 2 : MSClusterLib.ISClusResource.get_CommonROProperties
2011-01-16 11:18:14 Slp: Parameter 3 : System.IO.FileNotFoundException@-2147024894
2011-01-16 11:18:14 Slp: Parameter 4 : System.IO.FileNotFoundException@-2147024894
2011-01-16 11:18:14 Slp: Parameter 5 : GatherUserSettings
2011-01-16 11:18:14 Slp:
Final Parameter Values
2011-01-16 11:18:14 Slp: Parameter 0 : SQL2008@RTM@KB2285068
2011-01-16 11:18:14 Slp: Parameter 1 : 0x76862258
2011-01-16 11:18:14 Slp: Parameter 2 : 0x76862258
2011-01-16 11:18:14 Slp: Parameter 3 : 0xB7EAF00B
2011-01-16 11:18:14 Slp: Parameter 4 : 0xB7EAF00B
2011-01-16 11:18:14 Slp: Parameter 5 : GatherUserSettings
2011-01-16 11:18:17 Slp: Sco: Attempting to write hklm registry key SOFTWARE\Microsoft\Microsoft SQL Server to file C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20110116_111127\Registry_SOFTWARE_Microsoft_Microsoft SQL Server.reg_
2011-01-16 11:18:17 Slp: Sco: Attempting to write hklm registry key SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall to file C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20110116_111127\Registry_SOFTWARE_Microsoft_Windows_CurrentVersion_Uninstall.reg_
2011-01-16 11:18:17 Slp: Sco: Attempting to write hklm registry key SOFTWARE\Microsoft\MSSQLServer to file C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20110116_111127\Registry_SOFTWARE_Microsoft_MSSQLServer.reg_
2011-01-16 11:18:17 Slp: Sco: Attempting to write hklm registry key SOFTWARE\Wow6432Node\Microsoft\Microsoft SQL Server to file C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20110116_111127\Registry_SOFTWARE_Wow6432Node_Microsoft_Microsoft SQL Server.reg_
2011-01-16 11:18:17 Slp: Sco: Attempting to write hklm registry key SOFTWARE\Wow6432Node\Microsoft\Windows\CurrentVersion\Uninstall to file C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20110116_111127\Registry_SOFTWARE_Wow6432Node_Microsoft_Windows_CurrentVersion_Uninstall.reg_
2011-01-16 11:18:17 Slp: Sco: Attempting to write hklm registry key SOFTWARE\Wow6432Node\Microsoft\MSSQLServer to file C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20110116_111127\Registry_SOFTWARE_Wow6432Node_Microsoft_MSSQLServer.reg_
2011-01-16 11:18:18 Slp: The system cannot find the file specified. (Exception from HRESULT: 0x80070002)
2011-01-16 11:18:18 Slp: Watson bucket for exception based failure has been created
2011-01-16 11:18:18 Slp: Sco: Attempting to create base registry key HKEY_LOCAL_MACHINE, machine
2011-01-16 11:18:18 Slp: Sco: Attempting to open registry subkey
2011-01-16 11:18:18 Slp: Sco: Attempting to open registry subkey Software\Microsoft\PCHealth\ErrorReporting\DW\Installed
2011-01-16 11:18:18 Slp: Sco: Attempting to get registry value DW0201
2011-01-16 11:18:48 Slp: Submitted 1 of 1 failures to the Watson data repository
2011-01-16 11:18:50 Slp:
2011-01-16 11:18:50 Slp: ----------------------------------------------------------------------
2011-01-16 11:18:50 Slp:
2011-01-16 11:18:50 Slp: Error result: 1045947921
2011-01-16 11:18:50 Slp: Result facility code: 1623
2011-01-16 11:18:50 Slp: Result error code: 58897
but I haven't been able to figure out what file it is trying to find or even what user setting "GatherUserSettings" is trying to read. I've had no luck doing searches on this, does anyone else have any ideas?
January 17, 2011 at 8:37 am
I would call MS on this. It almost looks like something might be misconfigured on the cluster. Does this happen on both nodes?
January 17, 2011 at 8:44 am
Steve,
Yes, out of despiration yesterday I did try running the service pack on the active node and it looks like it got stuck at the same point:
2011-01-16 10:30:39 Slp: v:\32cf33b380ccdcc7d679ca\x64\FixSqlRegistryKey_x86.exe exit code: 0
2011-01-16 10:30:39 Slp: Rule 'AclPermissionsFacet' detection result: AreSqlAclPermissionsCanonical= True
2011-01-16 10:30:39 Slp: Evaluating rule : AclPermissionsFacet
2011-01-16 10:30:39 Slp: Rule running on machine: FHL-SOAR2
2011-01-16 10:30:39 Slp: Rule evaluation done : Succeeded
2011-01-16 10:30:39 Slp: Rule evaluation message: SQL Server registry keys are consistent and can support SQL Server installation or upgrade.
2011-01-16 10:30:39 Slp: Send result to channel : RulesEngineNotificationChannel
2011-01-16 10:30:39 Slp: Initializing rule : Not clustered or the cluster service is up and online.
2011-01-16 10:30:39 Slp: Rule applied features : ALL
2011-01-16 10:30:39 Slp: Rule is will be executed : True
2011-01-16 10:30:39 Slp: Init rule target object: Microsoft.SqlServer.Configuration.Cluster.Rules.ClusterServiceFacet
2011-01-16 10:30:39 Slp: Rule 'Cluster_IsOnlineIfClustered' detection result: Is Cluster Online Results = True; Is Cluster Verfication complete = False; Verfication Has Warnings = True; Verification Has Errors = True; on Machine FHL-SOAR2
2011-01-16 10:30:39 Slp: Evaluating rule : Cluster_IsOnlineIfClustered
2011-01-16 10:30:39 Slp: Rule running on machine: FHL-SOAR2
2011-01-16 10:30:39 Slp: Rule evaluation done : Succeeded
2011-01-16 10:30:39 Slp: Rule evaluation message: The computer is either not clustered or the cluster is up and online.
2011-01-16 10:30:39 Slp: Send result to channel : RulesEngineNotificationChannel
2011-01-16 10:30:39 Slp: Initializing rule : Cluster group owned by local computer
2011-01-16 10:30:39 Slp: Rule applied features : ALL
2011-01-16 10:30:39 Slp: Rule is will be executed : True
2011-01-16 10:30:39 Slp: Init rule target object: Microsoft.SqlServer.Configuration.Cluster.Rules.NodeClusterGroupFacet
2011-01-16 10:30:40 Slp: Locally owned group 'SQL Server (MSSQLSERVER)' contains the online service 'SQL Server Agent'
2011-01-16 10:30:40 Slp: Locally owned group 'SQL Server (MSSQLSERVER)' contains the online service 'SQL Server'
2011-01-16 10:30:40 Slp: Locally owned group 'SQL Server (MSSQLSERVER)' contains the online service 'GxClusPlugIn (fhl-soar) (Instance001)'
2011-01-16 10:30:40 Slp: Rule 'Cluster_IsLocalNodeGroupOwner' detection result: NodeOwnsClusterGroup=True
2011-01-16 10:30:40 Slp: Evaluating rule : Cluster_IsLocalNodeGroupOwner
2011-01-16 10:30:40 Slp: Rule running on machine: FHL-SOAR2
2011-01-16 10:30:40 Slp: Rule evaluation done : Warning
2011-01-16 10:30:40 Slp: Rule evaluation message: The local computer is an owner of a cluster group that contains the SQL Server service, Analysis Services service or a generic service for a failover cluster instance. If you continue, the SQL Server instances may be taken offline causing downtime while the patch is being applied.
2011-01-16 10:30:40 Slp: Send result to channel : RulesEngineNotificationChannel
2011-01-16 10:30:40 Slp: Initializing rule : Cluster Resource DLL Update Restart Check
2011-01-16 10:30:40 Slp: Rule applied features : ALL
2011-01-16 10:30:40 SQLEngine: --FacetResourceDLLUpdateRestartCheck: Engine_ResourceDLLUpdateRestartCheck: Installing/upgrading/patching instance '', version 10.2.4000.0.
2011-01-16 10:30:40 Slp: Error: Action "GatherUserSettings" threw an exception during execution.
2011-01-16 10:30:40 Slp: Microsoft.SqlServer.Setup.Chainer.Workflow.ActionExecutionException: Thread was being aborted. ---> System.Threading.ThreadAbortException: Thread was being aborted.
2011-01-16 10:30:40 Slp: at System.Threading.WaitHandle.WaitOneNative(SafeHandle waitableSafeHandle, UInt32 millisecondsTimeout, Boolean hasThreadAffinity, Boolean exitContext)
2011-01-16 10:30:40 Slp: at System.Threading.WaitHandle.InternalWaitOne(SafeHandle waitableSafeHandle, Int64 millisecondsTimeout, Boolean hasThreadAffinity, Boolean exitContext)
2011-01-16 10:30:40 Slp: at Microsoft.SqlServer.Configuration.UIExtension.Request.Wait()
2011-01-16 10:30:40 Slp: at Microsoft.SqlServer.Configuration.UIExtension.UserInterfaceProxy.SubmitAndWait(Request request)
2011-01-16 10:30:40 Slp: at Microsoft.SqlServer.Chainer.Infrastructure.Action.Execute(String actionId, TextWriter errorStream)
2011-01-16 10:30:40 Slp: at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionInvocation.InvokeAction(WorkflowObject metabase, TextWriter statusStream)
2011-01-16 10:30:40 Slp: at Microsoft.SqlServer.Setup.Chainer.Workflow.PendingActions.InvokeActions(WorkflowObject metaDb, TextWriter loggingStream)
2011-01-16 10:30:40 Slp: --- End of inner exception stack trace ---
2011-01-16 10:30:40 Slp: at Microsoft.SqlServer.Setup.Chainer.Workflow.PendingActions.InvokeActions(WorkflowObject metaDb, TextWriter loggingStream)
2011-01-16 10:30:41 Slp: Received request to add the following file to Watson reporting: C:\Users\chsaha1\AppData\Local\Temp\tmpC737.tmp
2011-01-16 10:30:41 Slp: The following is an exception stack listing the exceptions in outermost to innermost order
2011-01-16 10:30:41 Slp: Inner exceptions are being indented
2011-01-16 10:30:41 Slp:
2011-01-16 10:30:41 Slp: Exception type: System.IO.FileNotFoundException
2011-01-16 10:30:41 Slp: Message:
2011-01-16 10:30:41 Slp: The system cannot find the file specified. (Exception from HRESULT: 0x80070002)
2011-01-16 10:30:41 Slp: Stack:
2011-01-16 10:30:41 Slp: at MSClusterLib.ISClusResource.get_CommonROProperties()
2011-01-16 10:30:41 Slp: at Microsoft.SqlServer.Configuration.Cluster.ClusterResource.get_Name()
2011-01-16 10:30:46 Slp: Watson Bucket 1
January 17, 2011 at 9:23 am
It would almost seem to be some persmissions/security issue, but I would hesitate to "play" with the cluster. I'd call MS, let them work through it.
January 20, 2011 at 2:11 pm
check the local security policy > Local Policies and verify there isn't any Global Policy that was pushed that.. if you are using GPO.
Silly question here did you try to run the repair option?
I had this problem awhile back, going through my old notes i'll post again once i find them if this is still an issue.
January 21, 2011 at 9:02 am
If you are installing the service pack from a network/shared resource, it may be going away during the SP install. A service pack install may stop the clust services, which will make the shared drives disappear, and the the service pack will suddenly not be able to find its files. I wrote about this at http://shaunjstuart.com/archive/2010/06/failure-when-upgrading-cluster-to-sql-2008-sp1-cu7/[/url]. If you tried upgrading on the non-active node first though, I don't this this would apply.
January 21, 2011 at 10:23 am
Thanks for the feedback folks. In my previous attempts I had copied the service pack install file to the C:\ drive of the individual nodes to avoid any network weirdness issues. Unfortunately to answer the other questions, I'm working in an environment that was setup before I got here and is slim on documentation. I haven't been able to get time with the network administrator this week either.
The only major change I'm aware of to this cluster since it was setup in September was they took away the W:\ drive which was only holding the backups anyway. (those were moved to the K: drive). Once I can go through the setup with the network admin hopefully we'll be able to straighten out whatever setup is looking for. I'll try peeking at the policies though in the mean time.
April 28, 2011 at 1:57 pm
I got the same problem! anybody help me as my sytem is standalone
2011-04-24 21:31:06 Slp: C:\Windows\Installer\43a6c7.msi
2011-04-24 21:31:06 Slp: Watson bucket for exception based failure has been created
2011-04-24 21:31:06 Slp: Sco: Attempting to create base registry key HKEY_LOCAL_MACHINE, machine
2011-04-24 21:31:06 Slp: Sco: Attempting to open registry subkey
2011-04-24 21:31:06 Slp: Sco: Attempting to open registry subkey Software\Microsoft\PCHealth\ErrorReporting\DW\Installed
2011-04-24 21:31:06 Slp: Sco: Attempting to get registry value DW0201
2011-04-24 21:31:17 Slp: Submitted 1 of 1 failures to the Watson data repository
2011-04-24 21:31:18 Slp:
2011-04-24 21:31:18 Slp: ----------------------------------------------------------------------
2011-04-24 21:31:18 Slp:
2011-04-24 21:31:18 Slp: Error result: 1045947921
2011-04-24 21:31:18 Slp: Result facility code: 1623
2011-04-24 21:31:18 Slp: Result error code: 58897
April 29, 2011 at 10:32 am
Oops, forgot I never posted back what we did... After having Microsoft inspect the cluster, they determined there was corruption in the cluster setup database (nothing to do with SQL Server). To fix it, our network admin had to use the Failover Cluster Management tool to take everything out of the cluster, re-add the disks and DTS, then use SQL Server's installation to add SQL Server back to the cluster (fortunately not a full re-install). Hope this helps.
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply