Debugger not working with SQL Server 2017 and Python

[gbritton1]

Environment data

• VS Code version: 1.21.1
• Extension version (available under the Extensions sidebar): 2018.2.1- OS and version: XXX
• Python version (& distribution if applicable, e.g. Anaconda): XXX
• Type of virtual environment used (N/A | venv | virtualenv | conda | ...): XXX
• Relevant/affected Python packages and their versions: XXX

Actual behavior

1. Debugger does not stop at breakpoints
2. Program crashes in Microsoft code
3. Program runs fine from the CLI

Expected behavior

1. Debugger stops at defined breakpoints
2. Program does not crash

Steps to reproduce:

1. On an machine with SQL Server 2017 and Microsoft Machine learning with Python installed, run the attached program

Logs

Output for Python in the Output panel (View→Output, change the drop-down the upper-right of the Output panel to Python)

There is no output panel called Python

Output from Console under the Developer Tools panel (toggle Developer Tools on under Help)

console.ts:136 [Extension Host] (node:5764) DeprecationWarning: os.tmpDir() is deprecated. Use os.tmpdir() instead.
t.log @ console.ts:136

traceback

Express Edition will continue to be enforced.
Elapsed time: 00:00:01.6467579
Error: *** Exception: 'resourcePath'
Error in processing machine learning request.
TlcBridge error: Error: *** Exception: 'resourcePath'
Error in processing machine learning request.TlcBridge function failed. Please see the console output for more information.
Traceback (most recent call last):
File "c:\Users\Jerry\Documents\Pluralsight\Getting Started with Python on SQL Server\05 MicrosoftML\Demo\probably_pizza_featurize.py", line 23, in
get_sentiment(cols=dict(scores="comment"))
File "C:\Program Files\Microsoft SQL Server\MSSQL14.SQL_PYTHON\PYTHON_SERVICES\lib\site-packages\microsoftml\modules\featurize.py", line 209, in rx_featurize
telemetry_info=telemetry_info
File "C:\Program Files\Microsoft SQL Server\MSSQL14.SQL_PYTHON\PYTHON_SERVICES\lib\site-packages\microsoftml\utils\entrypoints.py", line 150, in run
ret = tlc_bridge(maml_code=maml_code, analysis_type="RunGraph", **kargs)
File "C:\Program Files\Microsoft SQL Server\MSSQL14.SQL_PYTHON\PYTHON_SERVICES\lib\site-packages\revoscalepy\utils\RxFunctionUtils.py", line 8, in wrapper
return func(*args,**kwds)
File "C:\Program Files\Microsoft SQL Server\MSSQL14.SQL_PYTHON\PYTHON_SERVICES\lib\site-packages\microsoftml\utils\tlc_bridge.py", line 171, in tlc_bridge
functionname=function_name, params=call_parameters)
File "C:\Program Files\Microsoft SQL Server\MSSQL14.SQL_PYTHON\PYTHON_SERVICES\lib\site-packages\revoscalepy\RxSerializable.py", line 358, in rx_native_call
ret = px_call(functionname, params)
RuntimeError: revoscalepy function failed.

probably_pizza_featurize.zip

[DonJayamanne]

• Please could you try debugging a simple python script such as the following:

print("Hello World")

• When debugging the python program, where does SQL Server 2017 come into the picture? Is this used just to pull information from?
• Please could you upload the contents of your launch.json file

[gbritton1]

When running print("hello world"), SQL Server comes into the picture since it is the version of Python shipping with SQL server that I am running:

PS > & 'C:\Program Files\Microsoft SQL Server\140\PYTHON_SERVER\python.exe'
Python 3.5.2 |Continuum Analytics, Inc.| (default, Jul  5 2016, 11:41:13) [MSC v.1900 64 bit (AMD64)] on win32
Type "help", "copyright", "credits" or "license" for more information.
>>>

In the program that causes the errors, it is using the Microsoft packages revoscalepy and microsoftml. with local data.

Uploaded launch.json

launch.zip

[DonJayamanne]

• Does debugging a simple hello world work? (Do break points work)
• Does running the program using the Run without debugging option work?

[gbritton1]

Running a simple Hello World works fine
Run without debugging fails the same way, for the sample program (though it works fine when run from powershell or cmd.exe)

Additionally, the imports take a long time (20-30 seconds) when run from VS Code, but not from other launchers (e.g. cmd.exe or pycharm)

[brettcannon]

Since none of us have SQL Server installed I have reached out to the SQL Server team to see if they could provide any insight.

[gbritton1]

I should point out that this is, by definition, Windows only, since SQL Server Python support only runs on Windows.

Also, I have talked to the SQL Server team. They basically said, "Not my problem!" Hate to get into finger-pointing here.

[santina]

Hi @gbritton1, could you try using C:\Program Files\Microsoft SQL Server\MSSQL14.SQL_PYTHON\PYTHON_SERVICES\ as your Python path? Thanks! Let us know if that works out.