René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"sqlmlutils fail to install packages on SQL Server 2022","articleBody":"Got python to work, but installing packages throws this error. \r\n\r\nAs a FYI - I could not get sqlmlutils  to work on 2019. It would look like it install, but the python package would fail to load properly. Pip Install worked on 2019. \r\n\r\nGiven the location of Python is different on 2022 to 2019, is it possible to use Pip Install on 2022??\r\n\r\n\r\nsqlmlutils  CALL\r\n----------------\r\nimport sqlmlutils\r\nconnection = sqlmlutils.ConnectionInfo(server=\"xx\\xx\", uid=\"sa\", pwd=\"xxx\")\r\nsqlmlutils.SQLPackageManager(connection).install(\"QuantLib\")\r\n\r\nFULL ERROR\r\n\r\n---------------------------------------------------------------------------\r\nProgrammingError                          Traceback (most recent call last)\r\nFile ~\\azuredatastudio-python\\lib\\site-packages\\sqlmlutils\\sqlqueryexecutor.py:67, in SQLQueryExecutor.execute_query(self, query, params, out_file)\r\n     66 if params is not None:\r\n---\u003e 67     self._cursor.execute(query, params)\r\n     68 else:\r\n\r\nProgrammingError: ('42000', \"[42000] [Microsoft][ODBC SQL Server Driver][SQL Server]A 'Python' script error occurred during execution of 'sp_execute_external_script' with HRESULT 0x80004004. External script request id is CD35FDA4-7E2E-425F-B013-8BD4D069AC74. (39004) (SQLExecDirectW); [42000] [Microsoft][ODBC SQL Server Driver][SQL Server]An external script error occurred: \\n\\r\\nError in execution.  Check the output for more information.\\r (39019)\")\r\n\r\nDuring handling of the above exception, another exception occurred:\r\n\r\nRuntimeError                              Traceback (most recent call last)\r\nCell In [1], line 3\r\n      1 import sqlmlutils\r\n      2 connection = sqlmlutils.ConnectionInfo(server=\"xx\\xx\", uid=\"sa\", pwd=\"xxx\")\r\n----\u003e 3 sqlmlutils.SQLPackageManager(connection).install(\"QuantLib\")\r\n\r\nFile ~\\azuredatastudio-python\\lib\\site-packages\\sqlmlutils\\packagemanagement\\sqlpackagemanager.py:78, in SQLPackageManager.install(self, package, upgrade, version, install_dependencies, scope, out_file)\r\n     76     self._install_from_file(package, scope, upgrade, out_file=out_file)\r\n     77 else:\r\n---\u003e 78     self._install_from_pypi(package, upgrade, version, install_dependencies, scope, out_file=out_file)\r\n\r\nFile ~\\azuredatastudio-python\\lib\\site-packages\\sqlmlutils\\packagemanagement\\sqlpackagemanager.py:158, in SQLPackageManager._install_from_pypi(self, target_package, upgrade, version, install_dependencies, scope, out_file)\r\n    155     target_package = target_package + \"==\" + version\r\n    157 with tempfile.TemporaryDirectory() as temporary_directory:\r\n--\u003e 158     pipdownloader = PipDownloader(self._connection_info, temporary_directory, target_package, language_name = self._language_name)\r\n    159     target_package_file = pipdownloader.download_single()\r\n    160     self._install_from_file(target_package_file, scope, upgrade, out_file=out_file)\r\n\r\nFile ~\\azuredatastudio-python\\lib\\site-packages\\sqlmlutils\\packagemanagement\\pipdownloader.py:20, in PipDownloader.__init__(self, connection, downloaddir, targetpackage, language_name)\r\n     18 self._targetpackage = targetpackage\r\n     19 self._language_name = language_name\r\n---\u003e 20 server_info = SQLPythonExecutor(connection, self._language_name).execute_function_in_sql(servermethods.get_server_info)\r\n     21 globals().update(server_info)\r\n\r\nFile ~\\azuredatastudio-python\\lib\\site-packages\\sqlmlutils\\sqlpythonexecutor.py:56, in SQLPythonExecutor.execute_function_in_sql(self, func, input_data_query, *args, **kwargs)\r\n     29 def execute_function_in_sql(self,\r\n     30                             func: Callable, *args,\r\n     31                             input_data_query: str = \"\",\r\n     32                             **kwargs):\r\n     33     \"\"\"Execute a function in SQL Server.\r\n     34 \r\n     35     :param func: function to execute_function_in_sql. NOTE: This function is shipped to SQL as text.\r\n   (...)\r\n     54     [0.28366218546322625, 0.28366218546322625]\r\n     55     \"\"\"\r\n---\u003e 56     df, _ = execute_query(SpeesBuilderFromFunction(func, \r\n     57                                                 self._language_name, \r\n     58                                                 input_data_query, \r\n     59                                                 *args, \r\n     60                                                 **kwargs), \r\n     61                         self._connection_info)\r\n     63     results, output, error = self._get_results(df)\r\n     65     if output is not None: \r\n\r\nFile ~\\azuredatastudio-python\\lib\\site-packages\\sqlmlutils\\sqlqueryexecutor.py:24, in execute_query(builder, connection, out_file)\r\n     22 def execute_query(builder, connection: ConnectionInfo, out_file:str=None):\r\n     23     with SQLQueryExecutor(connection=connection) as executor:\r\n---\u003e 24         return executor.execute(builder, out_file=out_file)\r\n\r\nFile ~\\azuredatastudio-python\\lib\\site-packages\\sqlmlutils\\sqlqueryexecutor.py:41, in SQLQueryExecutor.execute(self, builder, out_file)\r\n     40 def execute(self, builder: SQLBuilder, out_file=None):\r\n---\u003e 41     return self.execute_query(builder.base_script, builder.params, out_file=out_file)\r\n\r\nFile ~\\azuredatastudio-python\\lib\\site-packages\\sqlmlutils\\sqlqueryexecutor.py:96, in SQLQueryExecutor.execute_query(self, query, params, out_file)\r\n     93                 continue\r\n     95 except Exception as e:\r\n---\u003e 96     raise RuntimeError(\"Error in SQL Execution: \" + str(e))\r\n     98 return df, output_params\r\n\r\nRuntimeError: Error in SQL Execution: ('42000', \"[42000] [Microsoft][ODBC SQL Server Driver][SQL Server]A 'Python' script error occurred during execution of 'sp_execute_external_script' with HRESULT 0x80004004. External script request id is CD35FDA4-7E2E-425F-B013-8BD4D069AC74. (39004) (SQLExecDirectW); [42000] [Microsoft][ODBC SQL Server Driver][SQL Server]An external script error occurred: \\n\\r\\nError in execution.  Check the output for more information.\\r (39019)\")","author":{"url":"https://github.com/BGW1001","@type":"Person","name":"BGW1001"},"datePublished":"2023-02-08T10:54:16.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":6},"url":"https://github.com/108/sqlmlutils/issues/108"}