sous-chefs / sous-chefs/sql_server
Error when installing client on a machine already running SQL server 2012
Nobody has claimed this yet.
- Dominant language
- Ruby
- Stars
- 64
- Forks
- 117
- Avg merge
- 5h 30m
- Merged PRs (30d)
- 1
Description
When running on a machine with a preexisting SQL Server 2012 installed, I am getting the error below:
# Declared in c:/chef/cache/cookbooks/sql_server/recipes/client.rb:26:inblock in from_file'
windows_cookbook_package("Microsoft SQL Server 2008 R2 Management Objects (x64)") do
provider Chef::Provider::WindowsCookbookPackage
action [:install]
retries 0
retry_delay 2
guard_interpreter :default
cookbook_name "sql_server"
recipe_name "client"
source "http://download.microsoft.com/download/F/E/D/FEDB200F-DE2A-46D8-B661-D019DFE9D470/ENU/x64/SharedManagementObjects.msi"
checksum "ed753d85b51e7eae381085cad3dcc0f29c0b72f014f8f8fba1ad4e0fe387ce0a"
installer_type :msi
options "IACCEPTSQLNCLILICENSETERMS=YES"
success_codes [0, 42, 127]
package_name "Microsoft SQL Server 2008 R2 Management Objects (x64)"
timeout 600
end`
Error
'#<Mixlib::ShellOut::ShellCommandFailed: windows_package[Microsoft SQL Server 2008 R2 Management Objects (x64)] (sql_server::client line 26) had an error: Mixlib::ShellOut::ShellCommandFailed: Expected process to exit with [0, 42, 127], but received '1641' ---- Begin output of msiexec /qn /i "c:\chef\cache\SharedManagementObjects.msi" IACCEPTSQLNCLILICENSETERMS=YES ---- STDOUT: STDERR: ---- End output of msiexec /qn /i "c:\chef\cache\SharedManagementObjects.msi" IACCEPTSQLNCLILICENSETERMS=YES ---- Ran msiexec /qn /i "c:\chef\cache\SharedManagementObjects.msi" IACCEPTSQLNCLILICENSETERMS=YES returned 1641> had an error:
windows_package[Microsoft SQL Server 2008 R2 Management Objects (x64)](sql_server::client line 26) had an error: Mixlib::ShellOut::ShellCommandFailed: Expected process to exit with [0, 42, 127], but received '1641' ---- Begin output of msiexec /qn /i "c:\chef\cache\SharedManagementObjects.msi" IACCEPTSQLNCLILICENSETERMS=YES ---- STDOUT: STDERR: ---- End output of msiexec /qn /i "c:\chef\cache\SharedManagementObjects.msi" IACCEPTSQLNCLILICENSETERMS=YES ---- Ran msiexec /qn /i "c:\chef\cache\SharedManagementObjects.msi" IACCEPTSQLNCLILICENSETERMS=YES returned 1641
'
Contributor guide
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Research direction
The failing entry point is recipes/client.rb line 26, which invokes the SQL Server Management Objects MSI with msiexec. Reproduce the installation on a machine with SQL Server 2012, inspect how exit code 1641 is handled, and verify that the client recipe completes successfully.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- ruby, sql
- Domain
- databases, devops
- Issue type
- Bug
- Difficulty
- 3/5
- Estimated time
- 1-2 days
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 35/100