SQL 2014 SP1 CU2 Error on patch installation (Network Steve Forum)

SQL 2014 SP1 CU2 Error on patch installation

Trying to Patch SQL 2014 as the hotfix seemed to have some of the current issues we are experiencing on the version. We currently have 12.1.4416 and I am attempting to patch to 12.1.4422. Upon launch of KB (either from exe or cmd) I get the following error:

TITLE: SQL Server Setup failure.
------------------------------
SQL Server Setup has encountered the following error:
There was a failure to calculate the applicability of setting INSTALLSHAREDDIR.
Error code 0x85640002.
For help, click: http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft%20SQL%20Server&EvtSrc=setup.rll&EvtID=50000&EvtType=0xE8049925%25400x42B4DED7

The original installation, SP1, and previous patch went in without issue but something seems to be an issue. I am running a two node ACT/STBY Win2012R2 cluster. I get the same error on both nodes. Summary.txt from C:\Program Files\Microsoft SQL Server\120\Setup Bootstrap\Log is below.

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): -2057043966
Exit facility code: 1380
Exit error code: 2
Exit message: There was a failure to calculate the applicability of setting INSTALLSHAREDDIR.
Start time: 2015-08-20 12:21:42
End time: 2015-08-20 12:30:16
Requested action: Patch
Exception help link: http://go.microsoft.com/fwlink?LinkId=20476&ProdName=Microsoft+SQL+Server&EvtSrc=setup.rll&EvtID=50000&ProdVer=12.0.4422.0&EvtType=0xE8049925%400x42B4DED7&EvtType=0xE8049925%400x42B4DED7

Machine Properties:
Machine name: SQL-NODE2
Machine processor count: 32
OS version: Windows Server 2012
OS service pack:
OS region: United States
OS language: English (United States)
OS architecture: x64
Process architecture: 64 Bit
OS clustered: Yes

Package properties:
Description: Microsoft SQL Server 2014
ProductName: SQL Server 2014
Type: RTM
Version: 12
SPLevel: 1
KBArticle: KB3075950
KBArticleHyperlink: http://support.microsoft.com/?kbid=3075950
PatchType: QFE
AssociatedHotfixBuild: 0
Platform: x64
PatchLevel: 12.1.4422.0
ProductVersion: 12.1.4100.1
GDRReservedRange: 12.0.2200.0:12.0.2290.0;12.0.4200.0:12.0.4299.0
Installation location: c:\d1a36c205f36e4eb60b9\x64\setup\

User Input Settings:
ACTION: Patch
ALLINSTANCES: false
CLUSTERPASSIVE: false
CONFIGURATIONFILE:
ENU: true
ERRORREPORTING: false
HELP: false
IACCEPTSQLSERVERLICENSETERMS: false
INDICATEPROGRESS: false
INSTANCEID: <empty>
INSTANCENAME: <empty>
QUIET: false
QUIETSIMPLE: false
SQMREPORTING: false
UIMODE: Normal
X86: false

Rules with failures:

Global rules:

There are no scenario-specific rules.

Rules report file: The rule result report file is not available.

Exception summary:
The following is an exception stack listing the exceptions in outermost to innermost order
Inner exceptions are being indented

Exception type: Microsoft.SqlServer.Chainer.Infrastructure.CalculateSettingApplicabilityException
Message:
There was a failure to calculate the applicability of setting INSTALLSHAREDDIR.
HResult : 0x85640002
FacilityCode : 1380 (564)
ErrorCode : 2 (0002)
Data:
SettingId = INSTALLSHAREDDIR
WatsonData = Microsoft.SqlServer.Chainer.Infrastructure.CalculateSettingApplicabilityException@2
HelpLink.EvtType = 0xE8049925@0x42B4DED7
DisableWatson = true
Stack:
at Microsoft.SqlServer.Chainer.Infrastructure.Setting.CalculateApplicability()
at Microsoft.SqlServer.Chainer.Infrastructure.InputSettingService.CalculateAllSettings(Boolean chainerSettingOnly)
at Microsoft.SqlServer.Configuration.SetupExtension.FinalCalculateSettingsAction.ExecuteAction(String actionId)
at Microsoft.SqlServer.Chainer.Infrastructure.Action.Execute(String actionId, TextWriter errorStream)
at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionInvocation.<>c__DisplayClasse.<ExecuteActionWithRetryHelper>b__b()
at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionInvocation.ExecuteActionHelper(ActionWorker workerDelegate)
Inner exception type: Microsoft.SqlServer.Chainer.Infrastructure.CalculateSettingValueException
Message:
There was a failure to calculate the default value of setting INSTALLSHAREDDIR.
HResult : 0x85640001
FacilityCode : 1380 (564)
ErrorCode : 1 (0001)
Data:
SettingId = INSTALLSHAREDDIR
WatsonData = Microsoft.SqlServer.Chainer.Infrastructure.CalculateSettingValueException@1
Stack:
at Microsoft.SqlServer.Chainer.Infrastructure.Setting`1.CalculateValue()
at Microsoft.SqlServer.Deployment.PrioritizedPublishing.PublishingQueue.CallQueuedSubscriberDelegates()
at Microsoft.SqlServer.Deployment.PrioritizedPublishing.PublishingQueue.Publish(Publisher publisher)
at Microsoft.SqlServer.Chainer.Infrastructure.Setting.CalculateApplicability()
Inner exception type: System.Management.ManagementException
Message:
Invalid parameter
HResult : 0x80131501
Stack:
at System.Management.ManagementException.ThrowWithExtendedInfo(ManagementStatus errorCode)
at System.Management.ManagementPath.CreateWbemPath(String path)
at System.Management.ManagementPath..ctor(String path)
at Microsoft.SqlServer.Configuration.WMIInterop.ClusterToResource.get_PartComponent()
at Microsoft.SqlServer.Configuration.Cluster.ClusterProvider.<get_Resources>d__28.MoveNext()
at Microsoft.SqlServer.Configuration.Cluster.WindowsCluster.get_Resources()
at Microsoft.SqlServer.Configuration.ClusterConfiguration.ClusterDiskPublicConfigObject.get_AllDiskResources()
at Microsoft.SqlServer.Configuration.ClusterConfiguration.ClusterDiskPublicConfigObject.get_AllSharedDiskDriveLetters()
at Microsoft.SqlServer.Configuration.ClusterConfiguration.ClusterDiskPublicConfigObject.IsPathOnSharedDisk(String path)
at Microsoft.SqlServer.Configuration.SetupExtension.InstallDirSetting.ValidatePathNotOnSharedDiskInCluster(String path)
at Microsoft.SqlServer.Configuration.SetupExtension.InstallSharedDirSetting.DefaultValue()
at Microsoft.SqlServer.Deployment.PrioritizedPublishing.PublishingQueue.CallFunctionWhileAutosubscribing[T](SubscriberDelegate subscriberDelegate, Int32 priority, AutosubscribingFunctionDelegate`1 function)
at Microsoft.SqlServer.Chainer.Infrastructure.Setting`1.CalculateValue()

Additional info from the last successful patch! THIS summary.txt has Cluster properties as a section which is now not there??

Overall summary:
Final result: Passed
Exit code (Decimal): 0
Start time: 2015-07-15 11:28:04
End time: 2015-07-15 11:35:57
Requested action: Patch

Instance MSSQLSERVER overall summary:
Final result: Passed
Exit code (Decimal): 0
Start time: 2015-07-15 11:30:07
End time: 2015-07-15 11:35:38
Requested action: Patch

Cluster properties:
Machine name: SQL-NODE2
Product Instance Instance ID Feature Language Edition Version Clustered Configured
SQL Server 2014 MSSQLSERVER MSSQL12.MSSQLSERVER Database Engine Services 1033 Enterprise Edition 12.1.4213.0 Yes Yes
SQL Server 2014 MSSQLSERVER MSSQL12.MSSQLSERVER SQL Server Replication 1033 Enterprise Edition 12.1.4213.0 Yes Yes
SQL Server 2014 MSSQLSERVER MSSQL12.MSSQLSERVER Full-Text and Semantic Extractions for Search 1033 Enterprise Edition 12.0.2000.8 Yes Yes
SQL Server 2014 MSSQLSERVER MSSQL12.MSSQLSERVER Data Quality Services 1033 Enterprise Edition 12.1.4213.0 Yes Yes
SQL Server 2014 Management Tools - Basic 1033 Enterprise Edition 12.1.4213.0 No Yes
SQL Server 2014 Management Tools - Complete 1033 Enterprise Edition 12.1.4213.0 No Yes
SQL Server 2014 Client Tools Connectivity 1033 Enterprise Edition 12.1.4213.0 No Yes
SQL Server 2014 Client Tools Backwards Compatibility 1033 Enterprise Edition 12.1.4213.0 No Yes
SQL Server 2014 Client Tools SDK 1033 Enterprise Edition 12.1.4213.0 No Yes
SQL Server 2014 SQL Server Data Tools - Business Intelligence for Visual Studio 2013 1033 12.0.2430.0 No Yes
SQL Server 2014 Integration Services 1033 Enterprise Edition 12.1.4213.0 No Yes

Machine name: SQL-NODE1
Product Instance Instance ID Feature Language Edition Version Clustered Configured
SQL Server 2014 MSSQLSERVER MSSQL12.MSSQLSERVER Database Engine Services Enterprise Edition 12.1.4213.0 Yes Yes
SQL Server 2014 MSSQLSERVER MSSQL12.MSSQLSERVER SQL Server Replication Enterprise Edition 12.1.4213.0 Yes Yes
SQL Server 2014 MSSQLSERVER MSSQL12.MSSQLSERVER Full-Text and Semantic Extractions for Search Enterprise Edition 12.0.2000.8 Yes Yes
SQL Server 2014 MSSQLSERVER MSSQL12.MSSQLSERVER Data Quality Services Enterprise Edition 12.1.4213.0 Yes Yes
SQL Server 2014 Management Tools - Basic 1033 Enterprise Edition 12.1.4213.0 No Yes
SQL Server 2014 Management Tools - Complete 1033 Enterprise Edition 12.1.4213.0 No Yes
SQL Server 2014 Client Tools Connectivity 1033 Enterprise Edition 12.1.4213.0 No Yes
SQL Server 2014 Client Tools Backwards Compatibility 1033 Enterprise Edition 12.1.4213.0 No Yes
SQL Server 2014 Client Tools SDK 1033 Enterprise Edition 12.1.4213.0 No Yes
SQL Server 2014 SQL Server Data Tools - Business Intelligence for Visual Studio 2013 1033 12.0.2430.0 No Yes
SQL Server 2014 Integration Services 1033 Enterprise Edition 12.1.4213.0 No Yes

Machine Properties:
Machine name: SQL-NODE2
Machine processor count: 32
OS version: Windows Server 2012
OS service pack:
OS region: United States
OS language: English (United States)
OS architecture: x64
Process architecture: 64 Bit
OS clustered: Yes

Product features discovered:
Product Instance Instance ID Feature Language Edition Version Clustered Configured
SQL Server 2014 MSSQLSERVER MSSQL12.MSSQLSERVER Database Engine Services 1033 Enterprise Edition 12.1.4213.0 Yes Yes
SQL Server 2014 MSSQLSERVER MSSQL12.MSSQLSERVER SQL Server Replication 1033 Enterprise Edition 12.1.4213.0 Yes Yes
SQL Server 2014 MSSQLSERVER MSSQL12.MSSQLSERVER Full-Text and Semantic Extractions for Search 1033 Enterprise Edition 12.0.2000.8 Yes Yes
SQL Server 2014 MSSQLSERVER MSSQL12.MSSQLSERVER Data Quality Services 1033 Enterprise Edition 12.1.4213.0 Yes Yes
SQL Server 2014 Management Tools - Basic 1033 Enterprise Edition 12.1.4213.0 No Yes
SQL Server 2014 Management Tools - Complete 1033 Enterprise Edition 12.1.4213.0 No Yes
SQL Server 2014 Client Tools Connectivity 1033 Enterprise Edition 12.1.4213.0 No Yes
SQL Server 2014 Client Tools Backwards Compatibility 1033 Enterprise Edition 12.1.4213.0 No Yes
SQL Server 2014 Client Tools SDK 1033 Enterprise Edition 12.1.4213.0 No Yes
SQL Server 2014 SQL Server Data Tools - Business Intelligence for Visual Studio 2013 1033 12.0.2430.0 No Yes
SQL Server 2014 Integration Services 1033 Enterprise Edition 12.1.4213.0 No Yes

Package properties:
Description: Microsoft SQL Server 2014
ProductName: SQL Server 2014
Type: RTM
Version: 12
SPLevel: 1
KBArticle: KB3067839
KBArticleHyperlink: http://support.microsoft.com/?kbid=3067839
PatchType: QFE
AssociatedHotfixBuild: 0
Platform: x64
PatchLevel: 12.1.4416.0
ProductVersion: 12.1.4100.1
GDRReservedRange: 12.0.2200.0:12.0.2290.0;12.0.4200.0:12.0.4299.0
Installation location: c:\d8bebb059f45da1847\x64\setup\

Updated product edition:
Instance Edition
MSSQLSERVER Enterprise

User Input Settings:
ACTION: Patch
ALLINSTANCES: false
CLUSTERPASSIVE: false
CONFIGURATIONFILE:
ENU: true
ERRORREPORTING: true
HELP: false
IACCEPTSQLSERVERLICENSETERMS: true
INDICATEPROGRESS: false
INSTANCEID: <empty>
INSTANCENAME: <empty>
QUIET: false
QUIETSIMPLE: false
SQMREPORTING: true
UIMODE: Normal
X86: false

Rules with failures:

Global rules:

There are no scenario-specific rules.

Rules report file: C:\Program Files\Microsoft SQL Server\120\Setup Bootstrap\Log\20150715_112758\SystemConfigurationCheck_Report.htm

Any ideas what to look at next?

Thx, Mark

Edited by markk2_beyond Thursday, August 20, 2015 5:00 PM

August 20th, 2015 4:34pm

Hi Mark,

Can you check workaround with this connect item. As per Microsoft this seems problem with disk. Can you copy installable to other drive and try installation again

https://connect.microsoft.com/SQLServer/feedback/details/616890/sql-11-installation-fails-on-a-multi-subnet-windows-2008-r2-cluster-using-san-replication

Free Windows Admin Tool Kit Click here and download it now

August 20th, 2015 6:42pm

Hello,

The media should be corrupted. Try to download the media again and try to install once more.

You can use the following utility to compute and verify cryptographic hash values of file.

https://support.microsoft.com/en-us/kb/841290

http://www.microsoft.com/en-us/download/details.aspx?id=11533

Hope this helps.

Regards,

Alberto Morillo
SQLCoffee.com

August 20th, 2015 7:00pm

I tried this before posting as I found that posting on google, and SQL itself won't run on the cluster if I take the shared app drive out of the dependencies on the cluster.

Also, no matter which drive I copy it to, when it is run it runs in a temp on c: and logs to the bootstrap log on c:

Edited by markk2_beyond Thursday, August 20, 2015 8:06 PM

Free Windows Admin Tool Kit Click here and download it now

August 20th, 2015 7:55pm

It is just a downloaded patch. It runs fine on two other clusters?? It is not the .exe itself.

There is not "media" It is not the download. The exact one can open on another machine. SQL does not seem to pickup on the fact that it is in a cluster as per my second summary txt.

August 20th, 2015 7:56pm

Hi Mark,

Could you please copy installable to other drive and then patch SQL Server using command line? For more details about installing updates from the command prompt, please review this article: https://msdn.microsoft.com/en-us/library/dd638066(v=sql.120).aspx .

Thanks,
Lydia Zhang

Free Windows Admin Tool Kit Click here and download it now

August 25th, 2015 3:09am

This topic is archived. No further replies will be accepted.