Hi @aleksandra_ch ,

Please find the below attached complete output of command databricks labs lakebridge analyze --debug, as requested by you.

Also, the file C:\Users\chandana.r\.databricks\labs\lakebridge\state\venv\lib\site-packages\databricks\labs\bladespector\Analyzer\Windows\analyzer.exe is missing, and I couldn't find it even after re installing lake bridge through databricks cli.

10:58:31    DEBUG [d.l.bladespector.analyzer] Using underlying analyzer: $C:\Users\chandana.r\.databricks\labs\lakebridge\state\venv\lib\site-packages\databricks\labs\bladespector\Analyzer\Windows\analyzer.exe
10:58:31    DEBUG [d.l.bladespector.analyzer] Running command: C:\Users\chandana.r\.databricks\labs\lakebridge\state\venv\lib\site-packages\databricks\labs\bladespector\Analyzer\Windows\analyzer.exe -d C:\Users\chandana.r\OneDrive - Fractal Analytics Limited\Documents\Chandana_docs\Lakebridge_poc\SSMS_SCRIPTS_2 -r C:\Users\chandana.r\AppData\Local\Temp\tmpj1eikafo\lakebridge_analyzer_result2.xlsx -t SQL -v
10:58:31    ERROR [d.l.bladespector.analyzer] Analysis failed
Traceback (most recent call last):
File "C:\Users\chandana.r\.databricks\labs\lakebridge\state\venv\lib\site-packages\databricks\labs\bladespector\analyzer.py", line 87, in _run_binary
   with subprocess.Popen(
File "C:\Users\chandana.r\AppData\Local\Programs\Python\Python310\lib\subprocess.py", line 971, in __init__
   self._execute_child(args, executable, preexec_fn, close_fds,
File "C:\Users\chandana.r\AppData\Local\Programs\Python\Python310\lib\subprocess.py", line 1456, in _execute_child
   hp, ht, pid, tid = _winapi.CreateProcess(executable, args,
FileNotFoundError: [WinError 2] The system cannot find the file specified
10:58:31    DEBUG [d.l.l.contexts.application] Added User-Agent extra analyzer_error=RuntimeError
10:58:31    DEBUG [d.l.l.contexts.application] Added User-Agent extra cmd=analyze
10:58:31    DEBUG [databricks.sdk] GET /api/2.0/preview/scim/v2/Me
< 200 OK
< {
<   "active": true,
<   "displayName": "chandana.r@fractal.ai",
<   "emails": [
<     {
<       "primary": true,
<       "type": "work",
<       "value": "**REDACTED**"
<     }
<   ],
<   "externalId": "306b3347-5968-4277-b8e5-1fe27b037fa8",
<   "groups": [
<     {
<       "$ref": "Groups/153089339549513",
<       "display": "users",
<       "type": "direct",
<       "value": "**REDACTED**"
<     },
<     "... (2 additional elements)"
<   ],
<   "id": "501874446901877",
<   "name": {
<     "givenName": "chandana.r@fractal.ai"
<   },
<   "schemas": [
<     "urn:ietf:params:scim:schemas:core:2.0:User",
<     "... (1 additional elements)"
<   ],
<   "userName": "chandana.r@fractal.ai"
< }
10:58:31    ERROR [src/databricks/labs/lakebridge.analyze] Failed to call analyze
Traceback (most recent call last):
File "C:\Users\chandana.r\.databricks\labs\lakebridge\state\venv\lib\site-packages\databricks\labs\bladespector\analyzer.py", line 87, in _run_binary
   with subprocess.Popen(
File "C:\Users\chandana.r\AppData\Local\Programs\Python\Python310\lib\subprocess.py", line 971, in __init__
   self._execute_child(args, executable, preexec_fn, close_fds,
File "C:\Users\chandana.r\AppData\Local\Programs\Python\Python310\lib\subprocess.py", line 1456, in _execute_child
   hp, ht, pid, tid = _winapi.CreateProcess(executable, args,
FileNotFoundError: [WinError 2] The system cannot find the file specified

 

The above exception was the direct cause of the following exception:

 

Traceback (most recent call last):
File "C:\Users\chandana.r\.databricks\labs\lakebridge\state\venv\lib\site-packages\databricks\labs\blueprint\cli.py", line 118, in _route
   cmd.fn(**kwargs)
File "C:\Users\chandana.r\.databricks\labs\lakebridge\lib\src\databricks\labs\lakebridge\cli.py", line 822, in analyze
   result = ctx.analyzer.run_analyzer(source_directory, report_file, source_tech)
File "C:\Users\chandana.r\.databricks\labs\lakebridge\lib\src\databricks\labs\lakebridge\analyzer\lakebridge_analyzer.py", line 111, in run_analyzer
   return self._runner.run(source_dir, results_dir, platform)
File "C:\Users\chandana.r\.databricks\labs\lakebridge\lib\src\databricks\labs\lakebridge\analyzer\lakebridge_analyzer.py", line 76, in run
   self._runnable(source_dir, tmp_dir, platform, self._is_debug)
File "C:\Users\chandana.r\.databricks\labs\lakebridge\state\venv\lib\site-packages\databricks\labs\bladespector\analyzer.py", line 61, in analyze
   analyzer._run_binary(directory, result, technology, is_debug)
File "C:\Users\chandana.r\.databricks\labs\lakebridge\state\venv\lib\site-packages\databricks\labs\bladespector\analyzer.py", line 104, in _run_binary
   raise RuntimeError("Analysis failed") from e
RuntimeError: Analysis failed
10:58:32 Info: completed execution pid=8484 exit_code=0
10:58:32 Debug: no telemetry logs to upload pid=8484