Errors while attempting to install SP2 on an existing SQL 2012 server in a cluster

  • The install process runs with out error, however at the end the Complete portion of the process shows no features at all. When I check the version of sqlservr.exe it remains 11.0.2100.60.

    Any ideas on what is going on here? Here are some snippets from the log files:

    This is what I am seeing in the summary log file:

    Instance QSQLVM overall summary:

    Final result: The patch installer has failed to update the shared features. To determine the reason for failure, review the log files.

    Exit code (Decimal): -2068578302

    Exit facility code: 1204

    Exit error code: 2

    Exit message: The cluster group cannot be determined for the instance name 'QSQLVM'. This indicates there is a problem with the product registry setting for ClusterName, with product discovery, or the cluster resources.

    Start time: 2014-08-12 11:02:41

    End time: 2014-08-12 11:03:20

    Requested action: Patch

    The detail log looks pretty normal until this point:

    (01) 2014-08-12 11:03:24 Slp: Process returned 0

    (01) 2014-08-12 11:03:24 Slp: Cluster log generation completed successfully

    (01) 2014-08-12 11:03:24 Slp: Dumping final cluster state.

    (01) 2014-08-12 11:03:26 Slp: There was an issue determining the cluster debugging information. Setup will continue.

    (01) 2014-08-12 11:03:26 Slp: The following is an exception stack listing the exceptions in outermost to innermost order

    (01) 2014-08-12 11:03:26 Slp: Inner exceptions are being indented

    (01) 2014-08-12 11:03:26 Slp:

    (01) 2014-08-12 11:03:26 Slp: Exception type: System.InvalidOperationException

    (01) 2014-08-12 11:03:26 Slp: Message:

    (01) 2014-08-12 11:03:26 Slp: There was an error generating the XML document.

    (01) 2014-08-12 11:03:26 Slp: HResult : 0x80131509

    (01) 2014-08-12 11:03:26 Slp: Stack:

    (01) 2014-08-12 11:03:26 Slp: at System.Xml.Serialization.XmlSerializer.Serialize(XmlWriter xmlWriter, Object o, XmlSerializerNamespaces namespaces, String encodingStyle, String id)

    (01) 2014-08-12 11:03:26 Slp: at System.Xml.Serialization.XmlSerializer.Serialize(Stream stream, Object o, XmlSerializerNamespaces namespaces)

    (01) 2014-08-12 11:03:26 Slp: at Microsoft.SqlServer.Configuration.ClusterConfiguration.DiscoverClusterDataAction.ExecuteAction(String actionId)

    (01) 2014-08-12 11:03:26 Slp: Inner exception type: Microsoft.SqlServer.Configuration.Cluster.ClusterResourcesLookupException

    (01) 2014-08-12 11:03:26 Slp: Message:

    (01) 2014-08-12 11:03:26 Slp: There was an error to lookup cluster resources. Error: There was a failure to call cluster code from a provider. Exception message: Generic failure . Status code: 4118. Description: .

    (01) 2014-08-12 11:03:26 Slp: HResult : 0x86d80014

    (01) 2014-08-12 11:03:26 Slp: FacilityCode : 1752 (6d8)

    (01) 2014-08-12 11:03:26 Slp: ErrorCode : 20 (0014)

    (01) 2014-08-12 11:03:26 Slp: Data:

    (01) 2014-08-12 11:03:26 Slp: errorMessage = There was a failure to call cluster code from a provider. Exception message: Generic failure . Status code: 4118. Description: .

    (01) 2014-08-12 11:03:26 Slp: WatsonData = Microsoft.SqlServer.Configuration.Cluster.ClusterResourcesLookupException@20

    (01) 2014-08-12 11:03:26 Slp: Stack:

    (01) 2014-08-12 11:03:26 Slp: at Microsoft.SqlServer.Configuration.Cluster.WindowsCluster.get_ResourcesByType()

    (01) 2014-08-12 11:03:26 Slp: at Microsoft.Xml.Serialization.GeneratedAssembly.XmlSerializationWriter1.Write70_WindowsCluster(String n, String ns, WindowsCluster o, Boolean isNullable, Boolean needType)

    (01) 2014-08-12 11:03:26 Slp: at Microsoft.Xml.Serialization.GeneratedAssembly.XmlSerializationWriter1.Write226_WindowsCluster(Object o)

    (01) 2014-08-12 11:03:26 Slp: Inner exception type: Microsoft.SqlServer.Configuration.Cluster.ClusterProviderDetailedException

    (01) 2014-08-12 11:03:26 Slp: Message:

    (01) 2014-08-12 11:03:26 Slp: There was a failure to call cluster code from a provider. Exception message: Generic failure . Status code: 4118. Description: .

    (01) 2014-08-12 11:03:26 Slp: HResult : 0x86d70002

    (01) 2014-08-12 11:03:26 Slp: FacilityCode : 1751 (6d7)

    (01) 2014-08-12 11:03:26 Slp: ErrorCode : 2 (0002)

    (01) 2014-08-12 11:03:26 Slp: Data:

    (01) 2014-08-12 11:03:26 Slp: ExceptionMessage = Generic failure

    (01) 2014-08-12 11:03:26 Slp: StatusCode = 4118

    (01) 2014-08-12 11:03:26 Slp: Description =

    (01) 2014-08-12 11:03:26 Slp: WatsonData = Microsoft.SqlServer.Configuration.Cluster.ClusterProviderDetailedException@2

    (01) 2014-08-12 11:03:26 Slp: ManagementPath = MSCluster_Resource.Name="ccqa"

    (01) 2014-08-12 11:03:26 Slp: Stack:

    (01) 2014-08-12 11:03:26 Slp: at Microsoft.SqlServer.Configuration.Cluster.WmiClusterResource.get_ResourceTypeName()

    (01) 2014-08-12 11:03:26 Slp: at Microsoft.SqlServer.Configuration.Cluster.WindowsCluster.get_ResourcesByType()

    (01) 2014-08-12 11:03:26 Slp: Inner exception type: System.Management.ManagementException

    (01) 2014-08-12 11:03:26 Slp: Message:

    (01) 2014-08-12 11:03:26 Slp: Generic failure

    (01) 2014-08-12 11:03:26 Slp: HResult : 0x80131501

    (01) 2014-08-12 11:03:26 Slp: Data:

    (01) 2014-08-12 11:03:26 Slp: WmiErrorCode = Failed

    (01) 2014-08-12 11:03:26 Slp: WatsonData = Failed@4118

    (01) 2014-08-12 11:03:26 Slp: Operation = GetObject

    (01) 2014-08-12 11:03:26 Slp: ParameterInfo = MSCluster_Resource.Name="ccqa"

    (01) 2014-08-12 11:03:26 Slp: ProviderName = MS_CLUSTER_PROVIDER

    (01) 2014-08-12 11:03:26 Slp: StatusCode = 4118

    (01) 2014-08-12 11:03:26 Slp: Stack:

    (01) 2014-08-12 11:03:26 Slp: at System.Management.ManagementException.ThrowWithExtendedInfo(ManagementStatus errorCode)

    (01) 2014-08-12 11:03:26 Slp: at System.Management.ManagementObject.Initialize(Boolean getObject)

    (01) 2014-08-12 11:03:26 Slp: at System.Management.ManagementBaseObject.get_Properties()

    (01) 2014-08-12 11:03:26 Slp: at System.Management.ManagementBaseObject.GetPropertyValue(String propertyName)

    (01) 2014-08-12 11:03:26 Slp: at Microsoft.SqlServer.Configuration.WMIInterop.Resource.get_Type()

    (01) 2014-08-12 11:03:26 Slp: at Microsoft.SqlServer.Configuration.Cluster.WmiClusterResource.get_ResourceTypeName()

    (01) 2014-08-12 11:03:26 Slp: Completed dumping final cluster state.

    (01) 2014-08-12 11:03:28 Slp:

    (01) 2014-08-12 11:03:28 Slp:

    (01) 2014-08-12 11:03:28 Slp: ----------------------------------------------------------------------

    (01) 2014-08-12 11:03:28 Slp:

    (01) 2014-08-12 11:03:28 Slp: Error result: -2068578302

    (01) 2014-08-12 11:03:28 Slp: Result facility code: 1204

    (01) 2014-08-12 11:03:28 Slp: Result error code: 2

    (01) 2014-08-12 11:03:28 Slp: SQM Service: Sqm does not have active session.

  • I was assisting on a similar error message as well. Did you manage to fix this?

    In my case, this was occurring on a single node windows cluster.

    Initially the service pack file was located on the driver which is part of the cluster resource. Tried to apply using the SP file from the C:\ driver of the physical server where it failed with the error message similar to the one you have.

    Resolved it by extracting the service pack files (using the /X:<destination> switch) to a temporary folder and the installer completed its work.

    Cheers,

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply