Friday, September 14, 2007

Fun SQL Server 2005 error for Friday

Here's a good one. This is what the user sees if you attempt to uninstall a clustered SQL Server instance when the cluster disk is offline:



Digging through the logfile reveals the following:

Article: Minimum MDAC Version Requirement, Result: CheckPassed

0
Loaded DLL:C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\sqlsval.dll Version:2005.90.1399.0
Warning: Disk resource Disk F: is not Online
Please bring it Online if it is needed
Error: Action "InvokeSqlSetupDllAction" threw an exception during execution. Error information reported during run:
Source File Name: datastore\cachedpropertycollection.cpp
Compiler Timestamp: Fri Jul 29 01:13:49 2005
Function Name: CachedPropertyCollection::findProperty
Source Line Number: 130
----------------------------------------------------------
Failed to find property "ComputerList" {"SqlComputers", "", ""} in cache
Source File Name: datastore\clusterinfocollector.cpp
Compiler Timestamp: Fri Sep 16 13:20:12 2005
Function Name: ClusterInfoCollector::collectClusterVSInfo
Source Line Number: 883
----------------------------------------------------------
Failed to detect VS info due to datastore exception.
Source File Name: datastore\clustergroupsproperties.cpp
Compiler Timestamp: Fri Jul 29 01:13:49 2005
Function Name: ClusterGroupScope.SharedDisks
Source Line Number: 56
----------------------------------------------------------
Failed to find a cluster group that owned shared disk: F:
WinException : 2
Error Code: 0x80070002 (2)
Windows Error Text: The system cannot find the file specified.

Source File Name: datastore\clustergroupsproperties.cpp
Compiler Timestamp: Fri Jul 29 01:13:49 2005
Function Name: ClusterGroupScope.SharedDisks
Source Line Number: 56

This might be a nice error to tell the user about, you know, in the GUI....