René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"Pytorch is not installable using sqlmlutils","articleBody":"From the PyForMLS subdirectory in a cmd window (Windows 10) I launch python (vs 3.5.2)\r\nThen I run these 3 python statements\r\n\r\n```\r\nimport sqlmlutils\r\nconnection=sqlmlutils.ConnectionInfo(server=\"localhost\",database=\"mydatabase\")\r\nsqlmlutils.SQLPackageManager(connection).install(\"torch\")\r\n```\r\n**The last statement generates this:**\r\n\r\nSTDOUT message(s) from external script:\r\nProcessing c:\\data\\sql\\mssql15.mssqlserver\\mssql\\externallibraries\\5\\2\\1\\_\\pyyamltmp\\pyyaml-5.3.1-cp37-cp37m-win_amd64.whl\r\nInstalling collected packages: PyYAML\r\nSuccessfully installed PyYAML-5.3.1\r\nInstalled package. Cleaning up temporary directories.\r\nCleaned up temporary directory.\r\nPackage successfully installed.\r\nSTDERR message(s) from external script:\r\n  Failed building wheel for torch\r\n  Failed cleaning build dir for torch\r\nCommand \"\"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\\\r\nSTDOUT message(s) from external script:\r\nProcessing c:\\data\\sql\\mssql15.mssqlserver\\mssql\\externallibraries\\5\\2\\1\\_\\torchtmp\\torch-0.1.2.post2.tar.gz\r\n\r\nBuilding wheels for collected packages: torch\r\n  Running setup.py bdist_wheel for torch: started\r\n  Running setup.py bdist_wheel for torch: finished with status 'error'\r\n  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:\r\n  running bdist_wheel\r\n  running build\r\n  running build_deps\r\n  Traceback (most recent call last):\r\n    File \"\u003cstring\u003e\", line 1, in \u003cmodule\u003e\r\nSTDOUT message(s) from external script:\r\n    File \"C:\\Data\\SQL\\MSSQL15.MSSQLSERVER\\MSSQL\\ExternalLibraries\\5\\2\\1\\_\\pip-req-build-nfi11418\\setup.py\", line 265, in \u003cmodule\u003e\r\n      description=\"Tensors and Dynamic neural networks in Python with strong GPU acceleration\",\r\n    File \"C:\\Program Files\\Microsoft SQL Server\\MSSQL15.MSSQLSERVER\\PYTHON_SERVICES\\lib\\site-packages\\setuptools\\__init__.py\", line 143, in setup\r\n      return distutils.core.setup(**attrs)\r\n    File \"C:\\Program Files\\Microsoft SQL Server\\MSSQL15.MSSQLSERVER\\PYTHON_SERVICES\\lib\\distutils\\core.py\", line 148, in setup\r\n      dist.run_commands()\r\n    File \"C:\\Program Files\\Microsoft SQL Server\\MSSQL15.MSSQLSERVER\\PYTHON_SERVICES\\lib\\distutils\\dist.py\", line 966, in run_commands\r\n      self.run_command(cmd)\r\n    File \"C:\\Program Files\\Microsoft SQL Server\\MSSQL15.MSSQLSERVER\\PYTHON_SERVICES\\lib\\distutils\\dist.py\", line 985, in run_command\r\n      cmd_obj.run()\r\n\r\nSTDOUT message(s) from external script:\r\n    File \"C:\\Program Files\\Microsoft SQL Server\\MSSQL15.MSSQLSERVER\\PYTHON_SERVICES\\lib\\site-packages\\wheel\\bdist_wheel.py\", line 188, in run\r\n      self.run_command('build')\r\n    File \"C:\\Program Files\\Microsoft SQL Server\\MSSQL15.MSSQLSERVER\\PYTHON_SERVICES\\lib\\distutils\\cmd.py\", line 313, in run_command\r\n      self.distribution.run_command(command)\r\n    File \"C:\\Program Files\\Microsoft SQL Server\\MSSQL15.MSSQLSERVER\\PYTHON_SERVICES\\lib\\distutils\\dist.py\", line 985, in run_command\r\n      cmd_obj.run()\r\n    File \"C:\\Program Files\\Microsoft SQL Server\\MSSQL15.MSSQLSERVER\\PYTHON_SERVICES\\lib\\distutils\\command\\build.py\", line 135, in run\r\n      self.run_command(cmd_name)\r\n    File \"C:\\Program Files\\Microsoft SQL Server\\MSSQL15.MSSQLSERVER\\PYTHON_SERVICES\\lib\\distutils\\cmd.py\", line 313, in run_command\r\n      self.distribution.run_command(command)\r\nUnable to launch runtime for 'Python' script for request id: FF48E36C-0966-405D-8285-F1D50BA09736. Please check the configuration of the 'Python' runtime.\r\nTraceback (most recent call last):\r\n  File \"C:\\Program Files\\Microsoft\\PyForMLS\\lib\\site-packages\\sqlmlutils\\sqlqueryexecutor.py\", line 58, in execute\r\n    self._mssqlconn.execute_non_query(builder.base_script, builder.params)\r\n  File \"src\\_mssql.pyx\", line 1033, in _mssql.MSSQLConnection.execute_non_query\r\n  File \"src\\_mssql.pyx\", line 1061, in _mssql.MSSQLConnection.execute_non_query\r\n  File \"src\\_mssql.pyx\", line 1634, in _mssql.check_and_raise\r\n  File \"src\\_mssql.pyx\", line 1683, in _mssql.maybe_raise_MSSQLDatabaseException\r\n_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\")\r\n\r\nThe above exception was the direct cause of the following exception:\r\n\r\nTraceback (most recent call last):\r\n  File \"C:\\Program Files\\Microsoft\\PyForMLS\\lib\\site-packages\\sqlmlutils\\packagemanagement\\sqlpackagemanager.py\", line 185, in _install_many\r\n    self._install_single(sqlexecutor, target_package_file, scope, True, out_file=out_file)\r\n  File \"C:\\Program Files\\Microsoft\\PyForMLS\\lib\\site-packages\\sqlmlutils\\packagemanagement\\sqlpackagemanager.py\", line 202, in _install_single\r\n    sqlexecutor.execute(builder, out_file=out_file, getResults=False)\r\n  File \"C:\\Program Files\\Microsoft\\PyForMLS\\lib\\site-packages\\sqlmlutils\\sqlqueryexecutor.py\", line 61, in execute\r\n    raise RuntimeError(\"Error in SQL Execution\") from e\r\nRuntimeError: Error in SQL Execution\r\n\r\nThe above exception was the direct cause of the following exception:\r\nTraceback (most recent call last):\r\n  File \"\u003cstdin\u003e\", line 1, in \u003cmodule\u003e\r\n  File \"C:\\Program Files\\Microsoft\\PyForMLS\\lib\\site-packages\\sqlmlutils\\packagemanagement\\sqlpackagemanager.py\", line 74, in install\r\n    self._install_from_pypi(package, upgrade, version, install_dependencies, scope, out_file=out_file)\r\n  File \"C:\\Program Files\\Microsoft\\PyForMLS\\lib\\site-packages\\sqlmlutils\\packagemanagement\\sqlpackagemanager.py\", line 151, in _install_from_pypi\r\n    self._install_from_file(target_package_file, scope, upgrade, out_file=out_file)\r\n  File \"C:\\Program Files\\Microsoft\\PyForMLS\\lib\\site-packages\\sqlmlutils\\packagemanagement\\sqlpackagemanager.py\", line 174, in _install_from_file\r\n    self._install_many(target_package_file, dependencies_to_install, scope, out_file=out_file)\r\n  File \"C:\\Program Files\\Microsoft\\PyForMLS\\lib\\site-packages\\sqlmlutils\\packagemanagement\\sqlpackagemanager.py\", line 189, in _install_many\r\n    raise RuntimeError(\"Package installation failed, installed dependencies were rolled back.\") from e\r\nRuntimeError: Package installation failed, installed dependencies were rolled back.","author":{"url":"https://github.com/Jeff-Winchell","@type":"Person","name":"Jeff-Winchell"},"datePublished":"2020-03-22T00:47:55.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":1},"url":"https://github.com/60/sqlmlutils/issues/60"}