sqlmlutils
sqlmlutils copied to clipboard
Pytorch is not installable using sqlmlutils
From the PyForMLS subdirectory in a cmd window (Windows 10) I launch python (vs 3.5.2) Then I run these 3 python statements
import sqlmlutils
connection=sqlmlutils.ConnectionInfo(server="localhost",database="mydatabase")
sqlmlutils.SQLPackageManager(connection).install("torch")
The last statement generates this:
STDOUT message(s) from external script:
Processing c:\data\sql\mssql15.mssqlserver\mssql\externallibraries\5\2\1_\pyyamltmp\pyyaml-5.3.1-cp37-cp37m-win_amd64.whl
Installing collected packages: PyYAML
Successfully installed PyYAML-5.3.1
Installed package. Cleaning up temporary directories.
Cleaned up temporary directory.
Package successfully installed.
STDERR message(s) from external script:
Failed building wheel for torch
Failed cleaning build dir for torch
Command ""C:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\PYTHON_SERVICES\python.exe" -u -c "import setuptools, tokenize;file='C:\Data\SQL\MSSQL15.MSSQLSERVER\MSSQL\ExternalLibraries\5\2\1\_\pip-req-build-nfi11418\setup.py';f=getattr(tokenize, 'open', open)(file);code=f.read().replace('\r\n', '\n');f.close();exec(compile(code, file, 'exec'))" install --record C:\Data\SQL\MSSQL15.MSSQLSERVER\MSSQL\ExternalLibraries\5\2\1_\pip-record-qwk33zxf\install-record.txt --single-version-externally-managed --compile --home=C:\Data\SQL\MSSQL15.MSSQLSERVER\MSSQL\ExternalLibraries\5\2\1_\pip-target-qh7puf9o" failed with error code 1 in C:\Data\SQL\MSSQL15.MSSQLSERVER\MSSQL\ExternalLibraries\5\2\1_\pip-req-build-nfi11418
STDOUT message(s) from external script:
Processing c:\data\sql\mssql15.mssqlserver\mssql\externallibraries\5\2\1_\torchtmp\torch-0.1.2.post2.tar.gz
Building wheels for collected packages: torch
Running setup.py bdist_wheel for torch: started
Running setup.py bdist_wheel for torch: finished with status 'error'
Complete output from command "C:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\PYTHON_SERVICES\python.exe" -u -c "import setuptools, tokenize;file='C:\Data\SQL\MSSQL15.MSSQLSERVER\MSSQL\ExternalLibraries\5\2\1\_\pip-req-build-nfi11418\setup.py';f=getattr(tokenize, 'open', open)(file);code=f.read().replace('\r\n', '\n');f.close();exec(compile(code, file, 'exec'))" bdist_wheel -d C:\Data\SQL\MSSQL15.MSSQLSERVER\MSSQL\ExternalLibraries\5\2\1_\pip-wheel-dvpxe0od --python-tag cp37:
running bdist_wheel
running build
running build_deps
Traceback (most recent call last):
File "
STDOUT message(s) from external script: File "C:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\PYTHON_SERVICES\lib\site-packages\wheel\bdist_wheel.py", line 188, in run self.run_command('build') File "C:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\PYTHON_SERVICES\lib\distutils\cmd.py", line 313, in run_command self.distribution.run_command(command) File "C:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\PYTHON_SERVICES\lib\distutils\dist.py", line 985, in run_command cmd_obj.run() File "C:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\PYTHON_SERVICES\lib\distutils\command\build.py", line 135, in run self.run_command(cmd_name) File "C:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\PYTHON_SERVICES\lib\distutils\cmd.py", line 313, in run_command self.distribution.run_command(command) Unable to launch runtime for 'Python' script for request id: FF48E36C-0966-405D-8285-F1D50BA09736. Please check the configuration of the 'Python' runtime. Traceback (most recent call last): File "C:\Program Files\Microsoft\PyForMLS\lib\site-packages\sqlmlutils\sqlqueryexecutor.py", line 58, in execute self._mssqlconn.execute_non_query(builder.base_script, builder.params) File "src_mssql.pyx", line 1033, in _mssql.MSSQLConnection.execute_non_query File "src_mssql.pyx", line 1061, in _mssql.MSSQLConnection.execute_non_query File "src_mssql.pyx", line 1634, in _mssql.check_and_raise File "src_mssql.pyx", line 1683, in _mssql.maybe_raise_MSSQLDatabaseException _mssql.MSSQLDatabaseException: (39021, b"Unable to launch runtime for 'Python' script for request id: FF48E36C-0966-405D-8285-F1D50BA09736. Please check the configuration of the 'Python' runtime.DB-Lib error message 20018, severity 16:\nGeneral SQL Server error: Check messages from the SQL Server\n")
The above exception was the direct cause of the following exception:
Traceback (most recent call last): File "C:\Program Files\Microsoft\PyForMLS\lib\site-packages\sqlmlutils\packagemanagement\sqlpackagemanager.py", line 185, in _install_many self._install_single(sqlexecutor, target_package_file, scope, True, out_file=out_file) File "C:\Program Files\Microsoft\PyForMLS\lib\site-packages\sqlmlutils\packagemanagement\sqlpackagemanager.py", line 202, in _install_single sqlexecutor.execute(builder, out_file=out_file, getResults=False) File "C:\Program Files\Microsoft\PyForMLS\lib\site-packages\sqlmlutils\sqlqueryexecutor.py", line 61, in execute raise RuntimeError("Error in SQL Execution") from e RuntimeError: Error in SQL Execution
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "