SQL SERVER – Installation Error: The Specified Value ‘Install’ for ACTION is Invalid

I was helping a client to install SQL Server using script/automation (without using UI). They wanted to do command-line install rather than hitting next, next, fill values in the UI as they have to deploy more than 100 servers with SQL installed on it. In this blog we would learn about how to fix SQL Setup installation error – “The specified value ‘Install’ for ACTION is invalid.”

When my client first contacted me, they just told the error and as always, I asked for the setup log file. I had no idea how they were installing it. When I investigated the setup bootstrap log file, here is what I saw:

Overall summary:
Final result: Failed: see details below
Exit code (Decimal): -2057043952
Exit facility code: 1380
Exit error code: 16
Exit message: The specified value ‘Install’ for ACTION 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
Start time: 2018-07-12 17:05:33
End time: 2018-07-12 17:05:35
Requested action: None

When I looked further in the log, I could see below:

User Input Settings:
ACTION: None
CONFIGURATIONFILE:
ENU: false
HELP: false
IACCEPTPYTHONLICENSETERMS: false
IACCEPTROPENLICENSETERMS: false
INDICATEPROGRESS: false
MRCACHEDIRECTORY:
QUIET: false
QUIETSIMPLE: false
SUPPRESSPRIVACYSTATEMENTNOTICE: false
UIMODE: Normal
X86: false

After few lines, I found this.

WatsonData = Microsoft.SqlServer.Chainer.Infrastructure.InvalidWorkflowException@16
DisableWatson = true
Stack:
at Microsoft.SqlServer.Chainer.Infrastructure.InputSettingService.SaveInputSettingValueToObjectEnum(
at Microsoft.SqlServer.Chainer.Infrastructure.InputSettingService.SaveParsedArgumentsIntoSettings(
at Microsoft.SqlServer.Configuration.BootstrapExtension.ProcessChainerCommandLineArgumentsAction.ExecuteAction(
at Microsoft.SqlServer.Chainer.Infrastructure.Action.Execute(
at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionInvocation.<>c__DisplayClasse.b__b(
at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionInvocation.ExecuteActionHelper(
Inner exception type: System.ArgumentException
Message:
Requested value ”Install” was not found.
HResult : 0x80070057
Stack:
at System.Enum.EnumResult.SetFailure(
at System.Enum.TryParseEnum(
at System.Enum.Parse(

This was strange because not many parameters are visible in the first section and then I see (notice two single quotes)

Requested value ”Install” was not found.

I asked them a screenshot of the error and they share below with me:

WORKAROUND/SOLUTION

After this, I realize that due to single quotes around Install action, setup is parsing it incorrectly and thinking ‘install’ as an action. I checked the documentation and indeed single quotes for a parameter value is not valid.

Once we replace the single quote with a double quote on the command prompt, setup moved forward but there was a new error, which I would blog later.

Have you faced similar issue earlier?

Reference: Pinal Dave (http://blog.SQLAuthority.com)

Menu
Exit mobile version