[BUG]: File not a part of licensed checksum

[dataops-noob]

Is there an existing issue for this?

• I have searched the existing issues

Category of Bug / Issue

Application crashed

Current Behavior

ERROR:databricks.labs.bladebridge.transpiler:DATABRICKSSQLConv [431]: 2025-07-08 16:31:45 File not a part of licensed checksum: xxxxx.sql, checksum value: D4DBD7B1D3161F38E9E849B8E4263146. Skipping!

Expected Behavior

No response

Steps To Reproduce

No response

Relevant log output or Exception details

Sample Query

Operating System

macOS

Version

latest via Databricks CLI

[sundarshankar89]

Can you provide additional logs for us to debug?

1. Console log by running cli with additional --debug flag
2. LSP logs in $HOME/.databricks/labs/remorph-transpilers/bladebridge/lib/lsp-server.log

[dataops-noob]

Hi Sundar
do transpile need bladebridge convertor license to convert files ?
I'm trying to convert bunch of MSSQL files

here is lsp-server.log

INFO:pygls.feature_manager:Registered builtin feature exit
INFO:pygls.feature_manager:Registered builtin feature initialize
INFO:pygls.feature_manager:Registered builtin feature initialized
INFO:pygls.feature_manager:Registered builtin feature notebookDocument/didChange
INFO:pygls.feature_manager:Registered builtin feature notebookDocument/didClose
INFO:pygls.feature_manager:Registered builtin feature notebookDocument/didOpen
INFO:pygls.feature_manager:Registered builtin feature $/setTrace
INFO:pygls.feature_manager:Registered builtin feature shutdown
INFO:pygls.feature_manager:Registered builtin feature textDocument/didChange
INFO:pygls.feature_manager:Registered builtin feature textDocument/didClose
INFO:pygls.feature_manager:Registered builtin feature textDocument/didOpen
INFO:pygls.feature_manager:Registered builtin feature window/workDoneProgress/cancel
INFO:pygls.feature_manager:Registered builtin feature workspace/didChangeWorkspaceFolders
INFO:pygls.feature_manager:Registered builtin feature workspace/executeCommand
INFO:pygls.feature_manager:Registered "initialize" with options "None"
INFO:pygls.feature_manager:Registered "textDocument/didOpen" with options "None"
INFO:pygls.feature_manager:Registered "textDocument/didClose" with options "None"
INFO:pygls.feature_manager:Registered "document/transpileToDatabricks" with options "None"
INFO:pygls.server:Starting async IO server
DEBUG:asyncio:Using proactor: IocpProactor
DEBUG:pygls.server:Content length: 492
DEBUG:pygls.protocol.json_rpc:Request 'initialize' received
INFO:pygls.protocol.language_server:Language server initialized InitializeParams(capabilities=ClientCapabilities(workspace=None, text_document=None, notebook_document=None, window=None, general=None, experimental=None), process_id=34164, client_info=ClientInfo(name='lakebridge', version='0.10.4'), locale=None, root_path=None, root_uri='file:///C:/xxxx/input', initialization_options={'remorph': {'source-dialect': 'mssql'}, 'options': {'overrides-file': None}, 'custom': {}}, trace=None, work_done_token=None, workspace_folders=None)
INFO:databricks.labs.bladebridge.transpiler:Using config file 'C:C:\xxx.databricks\labs\remorph-transpilers\bladebridge\lib.venv\lib\site-packages\databricks\labs\bladebridge\Converter\Configs\MSSQL\base_sqlserver2databricks_sql.json'
DEBUG:pygls.protocol.json_rpc:Sending request with id "97e4885a-5638-4d86-8015-5d115a184389": client/registerCapability RegistrationParams(registrations=[Registration(id='1142e7ce-67b5-4cda-bb4b-6e4297125664', method='document/transpileToDatabricks', register_options=None)])
INFO:pygls.protocol.json_rpc:Sending data: {"id": "97e4885a-5638-4d86-8015-5d115a184389", "params": {"registrations": [{"id": "1142e7ce-67b5-4cda-bb4b-6e4297125664", "method": "document/transpileToDatabricks"}]}, "method": "client/registerCapability", "jsonrpc": "2.0"}
DEBUG:pygls.server:Content length: 80
DEBUG:pygls.protocol.json_rpc:Response message received.
DEBUG:pygls.protocol.json_rpc:Received result for message "97e4885a-5638-4d86-8015-5d115a184389": None
DEBUG:pygls.protocol.language_server:Server capabilities: {"positionEncoding": "utf-16", "textDocumentSync": {"openClose": true, "change": 2, "save": false}, "executeCommandProvider": {"commands": []}, "workspace": {"workspaceFolders": {"supported": true, "changeNotifications": true}, "fileOperations": {}}}
INFO:pygls.protocol.json_rpc:Sending data: {"id": "c6ca6eed-60b5-4a21-8ec4-e73705d2b57c", "jsonrpc": "2.0", "result": {"capabilities": {"positionEncoding": "utf-16", "textDocumentSync": {"openClose": true, "change": 2, "save": false}, "executeCommandProvider": {"commands": []}, "workspace": {"workspaceFolders": {"supported": true, "changeNotifications": true}, "fileOperations": {}}}, "serverInfo": {"name": "bladebridge-transpiler", "version": "0.1.9"}}}
DEBUG:pygls.server:Content length: 7450
DEBUG:pygls.protocol.json_rpc:Notification 'textDocument/didOpen' received
DEBUG:main:open-document-uri=file:///C:/xxxx/input/dbo.xxxx.sql
DEBUG:pygls.server:Content length: 321
DEBUG:pygls.protocol.json_rpc:Request 'document/transpileToDatabricks' received
INFO:databricks.labs.bladebridge.transpiler:
INFO:databricks.labs.bladebridge.transpiler:Databricks
INFO:databricks.labs.bladebridge.transpiler:
INFO:databricks.labs.bladebridge.transpiler:************ dbxconv ************
INFO:databricks.labs.bladebridge.transpiler:VERSION 1.0.19 Build 20250623
INFO:databricks.labs.bladebridge.transpiler:***********************************
INFO:databricks.labs.bladebridge.transpiler:
INFO:databricks.labs.bladebridge.transpiler:Loading dependencies...
INFO:databricks.labs.bladebridge.transpiler:
INFO:databricks.labs.bladebridge.transpiler:Databricks
INFO:databricks.labs.bladebridge.transpiler:
INFO:databricks.labs.bladebridge.transpiler:************ sqlconv ************
INFO:databricks.labs.bladebridge.transpiler:VERSION 2.12.7 Build 20250606
INFO:databricks.labs.bladebridge.transpiler:***********************************
INFO:databricks.labs.bladebridge.transpiler:
INFO:databricks.labs.bladebridge.transpiler:Validation::Validator [109]: 2025-07-08 16:31:30 trusted transpiler handshake length check: 4c9c8ba35d934b98f9e2fd72770bc784686d8e24
INFO:databricks.labs.bladebridge.transpiler:Validation::Validator [115]: 2025-07-08 16:31:30 trusted transpiler handshake timestamp check: 1752010277 source timestamp: 1752010276
INFO:databricks.labs.bladebridge.transpiler:Validation::Validator [130]: 2025-07-08 16:31:37 trusted transpiler handshake value check: 36076 C:\Program Files\Python310\python.exe" -m databricks.labs.bladebridge.server --log_level=WARNING C:C:\xxx.databricks\labs\remorph-transpilers\bladebridge\lib.venv\lib\site-packages\databricks\labs\bladebridge\Converter\bin\Windows\dbxconv.exe SQL -u base_sqlserver2databricks_sql.json -n transpiled -i originals\dbo.xxxx.sql
INFO:databricks.labs.bladebridge.transpiler:Validation::Validator [131]: 2025-07-08 16:31:37 trusted transpiler handshake value check source hash: 4c9c8ba35d934b98f9e2fd72770bc784 calculated hash: 3989b0cd8166199a51a2534289a198b9
INFO:databricks.labs.bladebridge.transpiler:DATABRICKSSQLConv [297]: 2025-07-08 16:31:37 TRUSTED MODE: ;
INFO:databricks.labs.bladebridge.transpiler:DATABRICKSSQLConv [4080]: 2025-07-08 16:31:44 Loading files: $VAR1 = [
INFO:databricks.labs.bladebridge.transpiler: 'final_master_dbx_sql_scripting'
INFO:databricks.labs.bladebridge.transpiler:];
INFO:databricks.labs.bladebridge.transpiler:
INFO:databricks.labs.bladebridge.transpiler:DATABRICKSSQLConv [4121]: 2025-07-08 16:31:44 Found custom module file: C:/Users/xxxx/.databricks/labs/remorph-transpilers/bladebridge/lib/.venv/lib/site-packages/databricks/labs/bladebridge/Converter/Configs/GeneralSQL/final_master_dbx_sql_scripting.pl
INFO:databricks.labs.bladebridge.transpiler:DBCatalog::SQLParser [588]: 2025-07-08 16:31:44 ********** PARSER VERBOSE FLAG: **********
INFO:databricks.labs.bladebridge.transpiler:FILES TO PROCESS (1):
INFO:databricks.labs.bladebridge.transpiler:C:/Users/xxxx/AppData/Local/Temp/bladerunner_xckzvczi/originals/dbo.xxxx.sql
INFO:databricks.labs.bladebridge.transpiler:DBCatalog::SQLParser [588]: 2025-07-08 16:31:44 ********** PARSER VERBOSE FLAG: **********
INFO:databricks.labs.bladebridge.transpiler:DBCatalog::SQLParser [1242]: 2025-07-08 16:31:44 analyze_file: Analyzing file C:/Users/xxxx/AppData/Local/Temp/bladerunner_xckzvczi/originals/dbo.xxxx.sql
INFO:databricks.labs.bladebridge.transpiler:DATABRICKSSQLConv [395]: 2025-07-08 16:31:45 File parts (File 1 of 1): dbo.xxxx.sql, C:/Users/xxxx/AppData/Local/Temp/bladerunner_xckzvczi/originals/,
INFO:databricks.labs.bladebridge.transpiler:DATABRICKSSQLConv [398]: 2025-07-08 16:31:45 Full source path:
INFO:databricks.labs.bladebridge.transpiler:main [428]: 2025-07-08 16:31:45 File: dbo.xxxx.sql; Checksum value: D4DBD7B1D3161F38E9E849B8E4263146
INFO:databricks.labs.bladebridge.transpiler:
INFO:databricks.labs.bladebridge.transpiler:DATABRICKSSQLConv [431]: 2025-07-08 16:31:45 File not a part of licensed checksum: dbo.xxxx.sql, checksum value: D4DBD7B1D3161F38E9E849B8E4263146. Skipping!
INFO:databricks.labs.bladebridge.transpiler:DBXCONV [370]: 2025-07-08 16:31:45 dbxconv finished execution successfully
INFO:databricks.labs.bladebridge.transpiler:
ERROR:databricks.labs.bladebridge.transpiler:DATABRICKSSQLConv [431]: 2025-07-08 16:31:45 File not a part of licensed checksum: dbo.xxxx.sql, checksum value: D4DBD7B1D3161F38E9E849B8E4263146. Skipping!
ERROR:databricks.labs.bladebridge.transpiler:
ERROR:databricks.labs.bladebridge.transpiler:Error transpiling file: dbo.xxxx.sql:

[sundarshankar89]

Thank you for sharing additional logs, this help narrow down the issue, will update once the fix is released.

[dataops-noob]

@sundarshankar89 do we need bladebridge license to transpile the code ?

[eri-adepoju]

Customer with Informatica PC is also facing this issue. Logs