Error in request

by Sebastian   Last Updated May 22, 2018 13:06 PM

I have the following error in mssql 2017 when I make a request

EXEC sp_execute_external_script 
@language = N'Python', 
@script = N'
from suds.client import Client

url="http://www.google.com"

client = Client(url)
print(client)
'

output

Msg 39004, Level 16, State 20, Line 0 Error de script 'Python' durante la ejecuciĆ³n de 'sp_execute_external_script' con HRESULT 0x80004004. Msg 39019, Level 16, State 2, Line 0 Error en el script externo:

Error in execution. Check the output for more information. Traceback (most recent call last): File "", line 5, in File "E:\MSSQL\MSSQL13.MSSQLSERVER\MSSQL\ExtensibilityData\MSSQLSERVER01\0474DAB2-30DC-4156-ABCD-F506B5E0220B\sqlindb.py", line 29, in transform from suds.client import Client File "E:\MSSQL\MSSQL14.MSSQLSERVER\PYTHON_SERVICES\lib\site-packages\suds\client.py", line 242 except Exception, e: ^ SyntaxError: invalid syntax

SqlSatelliteCall error: Error in execution. Check the output for more information. Mensaje(s) STDOUT del script externo: SqlSatelliteCall function failed. Please see the console output for more information. Traceback (most recent call last): File "E:\MSSQL\MSSQL14.MSSQLSERVER\PYTHON_SERVICES\lib\site-packages\revoscalepy\computecontext\RxInSqlServer.py", line 406, in rx_sql_satellite_call rx_native_call("SqlSatelliteCall", params) File "E:\MSSQL\MSSQL14.MSSQLSERVER\PYTHON_SERVICES\lib\site-packages\revoscalepy\RxSerializable.py", line 291, in rx_native_call ret = px_call(functionname, params) RuntimeError: revoscalepy function failed.



Related Questions


SQL Server 2017 & External Python Modules

Updated October 20, 2017 08:06 AM

Problems with Python in SQL Server 2017

Updated March 26, 2018 20:06 PM


Removing sp_execute_external_script Start-Up Lag

Updated October 23, 2017 19:06 PM