SQL Server 2014 Service Pack 1 Unattended Setup Error - "The specified value 'Upgrade' is invalid"

SQL Server 2014 Service Pack 1 Unattended Setup Error - "The specified value 'Upgrade' is invalid"

 

I was recently sent a question regarding a failed unattended install of SQL Server 2014 Service Pack 1. The customer had spent some time searching online for the error message, but found surprisingly little detailed information for unattended SQL Server patching operations, unlike the other setup operations, which are documented thoroughly here.  

The command line attempting to be executed was:
<sql2014sp1file>.exe /IACCEPTSQLSERVERLICENSETERMS /ACTION=UPGRADE
/INSTANCENAME=MSSQLSERVER /INDICATEPROGRESS /QS

 

The summary.txt file showed the following error message: 

The specified value 'Upgrade' is invalid. To run in unattended mode, you must specify a valid ACTION. The valid values for ACTION are: ' None RemovePatch Uninstall Install Upgrade Patch Repair LandingPage ClusterReport RunRules PrepareFailoverCluster CompleteFailoverCluster InstallFailoverCluster RemoveNode AddNode EditionUpgrade Bootstrap ComponentUpdate Help RebuildDatabase RunDiscovery PrepareImage CompleteImage ConfigureImage'

Interestingly the error message states that 'Upgrade' is invalid, but then lists it as a potential value for the ACTION parameter. The confusion is that it is a valid value in version upgrade scenarios (ex: upgrading from SQL Server 2012 to SQL Server 2014), but not in this service pack patching scenario. Replacing this value with 'Patch' allows the unattended installer to complete and for the service pack to be applied.

<sql2014sp1file>.exe /IACCEPTSQLSERVERLICENSETERMS /ACTION=PATCH
/INSTANCENAME=MSSQLSERVER /INDICATEPROGRESS /QS

Hope it helps,
Sam Lester (MSFT)

Comments

• Anonymous
  June 23, 2015
  Also getting the 'action not valid' message when attempting a patch: D:setup.exe /ConfigurationFile=c:tempSQL2014Unattended_ConfigurationFileUpgrade.ini /ACTION=Patch Then it tells me that Patch is a valid action !

• Anonymous
  June 24, 2015
  Hi Colin, if it is a public facing site, can you send the link where you are getting the installer package along with the specific package name if there are multiple available?  Also, are you supplying a value for the /ACTION parameter inside your .ini file?  In the summary.txt log file, does it show the ACTION parameter is set to PATCH or UPGRADE?

• Anonymous
  August 29, 2015
  The comment has been removed

• Anonymous
  April 06, 2016
  The comment has been removed