SQL Server 2019 CU20 Patching Python Machine Learning Runtime Error
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)