ERROR: Failed to execute command on XX.XX.XXX.XX return code 1

9.109.123.91 ---- End output of .\setup.exe /CONFIGURATIONFILE=c:\chef_download/ConfigurationFile.ini ----
9.109.123.91 Ran .\setup.exe /CONFIGURATIONFILE=c:\chef_download/ConfigurationFile.ini returned -2022834173
9.109.123.91
9.109.123.91 Resource Declaration:
9.109.123.91 ---------------------
9.109.123.91 # In c:/chef/cache/cookbooks/sqlserverinstall/recipes/default.rb
9.109.123.91
9.109.123.91 26: execute “starting SQL Server #{node[:sql][:version]} installation on windows” do
9.109.123.91 27: cwd node[:product][:location]
9.109.123.91 28: command ".\setup.exe /CONFIGURATIONFILE=#{responsefile}"
9.109.123.91 29: end
9.109.123.91 30: else
9.109.123.91
9.109.123.91 Compiled Resource:
9.109.123.91 ------------------
9.109.123.91 # Declared in c:/chef/cache/cookbooks/sqlserverinstall/recipes/default.rb:26:in `from_file’
9.109.123.91
9.109.123.91 execute(“starting SQL Server 2012 installation on windows”) do
9.109.123.91 action [:run]
9.109.123.91 retries 0
9.109.123.91 retry_delay 2
9.109.123.91 default_guard_interpreter :execute
9.109.123.91 command ".\setup.exe /CONFIGURATIONFILE=c:\chef_download/ConfigurationFile.ini"
9.109.123.91 backup 5
9.109.123.91 cwd "c:\chef_download"
9.109.123.91 returns 0
9.109.123.91 declared_type :execute
9.109.123.91 cookbook_name "sqlserverinstall"
9.109.123.91 recipe_name "default"
9.109.123.91 end
9.109.123.91
9.109.123.91 Platform:
9.109.123.91 ---------
9.109.123.91 x64-mingw32
9.109.123.91
9.109.123.91
9.109.123.91 [2016-11-15T12:10:45+05:30] INFO: Running queued delayed notifications before re-raising exception
9.109.123.91 [2016-11-15T12:10:45+05:30] ERROR: Running exception handlers
9.109.123.91 [2016-11-15T12:10:45+05:30] ERROR: Exception handlers complete
9.109.123.91 [2016-11-15T12:10:45+05:30] FATAL: SystemCallError: The parameter is incorrect. - ReportEvent
ERROR: Failed to execute command on 9.109.123.91 return code 1

Chef code :

execute “starting SQL Server #{node[:sql][:version]} installation on windows” do
cwd node[:product][:location]
command ".\setup.exe /CONFIGURATIONFILE=#{responsefile}"
end

But when ran on server directly it works, anyone please help me to find the error

According to the log:

SystemCallError: The parameter is incorrect.

Try running with -l debug but I suspect the setup program doesn’t like the mixed path scheme:

command ".\setup.exe /CONFIGURATIONFILE=c:\chef_download/ConfigurationFile.ini"

I can’t swear, but I think the \ could be the problem here. I would get rid of the first .\ and use escaped backslashes \\ in the responsefile to have a single backslash on the executed command.