SQL Server 2019 CU20 Patching Python Machine Learning Runtime Error

Prem Gokull 1 Reputation point
2023-06-07T03:22:41.7433333+00:00

Environmnet: SQL Server 2019 Enterprise No HA [Standalone Instance] on Windows Server 2016 DataCenter

Scenario:Runtime Errors while executing pyton scripts, after SQL Server 2019 CU20 KB5024276 patching & updated pyton ML with files

SPO_4.5.12.479_1033.cab

SPS_9.4.7.2008_1033.cab

SRO_3.5.2.777_1033.cab

SRS_9.4.7.2008_1033.cab

when tried to execute the command in New Query windows on SSMS,

EXEC sp_execute_external_script  @language =N'Python',

@script=N'

OutputDataSet = InputDataSet;

',

@input_data_1 =N'SELECT 1 AS hello'

WITH RESULT SETS (([hello] int not null));

GO

Error Received:

Msg 39012, Level 16, State 14, Line 1

Unable to communicate with the runtime for 'Python' script for request id: 9F67B2FC-F0A3-4F9A-B19E-DD7237F1BF9C. Please check the requirements of 'Python' runtime.

STDERR message(s) from external script: 

Traceback (most recent call last):

  File "<string>", line 1, in <module>

  File "C:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\PYTHON_SERVICES\lib\site-packages\revoscalepy_init_.py", line 121, in <module>

    from .RxSerializable import RxMissingValues

  File "C:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\PYTHON_SERVICES\lib\site-packages\revoscalepy\RxSerializable.py", line 10, in <module>

    from pandas import DataFrame

  File "C:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\PYTHON_SERVICES\lib\site-packages\pandas_init_.py", line 42, in <module>

    from pandas.core.api import *

  File "C:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\PYTHON_SERVICES\lib\site-packages\pandas\core\api.py", line 10, in <module>

    from pandas.core.groupby.groupby import Grouper

STDERR message(s) from external script: 

  File "C:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\PYTHON_SERVICES\lib\site-packages\pandas\core\groupby_init_.py", line 2, in <module>

    from pandas.core.groupby.groupby import (

  File "C:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\PYTHON_SERVICES\lib\site-packages\pandas\core\groupby\groupby.py", line 46, in <module>

    from pandas.core.index import (Index, MultiIndex,

  File "C:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\PYTHON_SERVICES\lib\site-packages\pandas\core\index.py", line 2, in <module>

    from pandas.core.indexes.api import *

  File "C:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\PYTHON_SERVICES\lib\site-packages\pandas\core\indexes\api.py", line 4, in <module>

    from pandas.core.indexes.base import (Index,

  File "C:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\PYTHON_SERVICES\lib\site-packages\pandas\core\indexes\base.py", line 53, in <module>

STDERR message(s) from external script: 

    from pandas.core import ops

  File "C:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\PYTHON_SERVICES\lib\site-packages\pandas\core\ops_init_.py", line 21, in <module>

    from pandas.core.construction import extract_array

  File "C:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\PYTHON_SERVICES\lib\site-packages\pandas\core\construction.py", line 15, in <module>

    from pandas._libs.tslibs import IncompatibleFrequency, OutOfBoundsDatetime

ImportError: cannot import name 'IncompatibleFrequency' from 'pandas.libs.tslibs' (C:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\PYTHON_SERVICES\lib\site-packages\pandas_libs\tslibs_init.py)

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,159 questions
0 comments No comments
{count} votes

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.