Databricks Community

Chandana_Ramesh · Monday

Hi,

I'm getting the below error upon executing databricks labs lakebridge analyze command. All the dependencies have been installed before execution of the command. Can someone please give a solution, or suggest if anything is missing? Below attached is the error.

17:11:56 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
17:11:56 ERROR [src/databricks/labs/lakebridge.analyze] RuntimeError: Analysis failed

aleksandra_ch · yesterday

Hi Chandana_Ramesh,

Please rerun the command with a --debug flag and share the command and the whole output.

From the message that you shared, it looks like the Analyzer.exe binary is not accessible:

Verify the binary exists and is accessible: C:\Users\chandana.r\.databricks\labs\lakebridge\state\venv\lib\site-packages\databricks\labs\bladespector\Analyzer\Windows\analyzer.exe. If it’s missing, reinstall Lakebridge via the Databricks CLI. If it’s present, ensure it’s not quarantined or blocked.
Check Windows Defender quarantine and add an exclusion for the C:\Users\chandana.r\.databricks\labs\lakebridge\state\venv\Lib\site-packages\databricks\labs\bladespector\Analyzer\Windows directory, then restore the analyzer.exe if quarantined.

Hope this helps.

Chandana_Ramesh · yesterday

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