Hi, I’m building a workflow which would take a query as input from the user and execute it against a database. In the background I have a database.db file which contains the tables and necessary data. The user’s query would be executed against database.db file. I’m using “SQLite Connector” node to make the connection to the .db file and “DB Query Reader” node to execute the query. The workflow works in the Analytics Platform but fails with an error “No such table found” as it’s not able to make connection to the .db file I presume. I can’t enter a relative path “knime://knime.workflow/…/data/database.db” in the SQLite Connector node and the local path won’t allow it to access the .db file. Can you please how to operate with the SQLite Connector node, when using it via Web Portal and giving it a relative path to .db file Thank you. Regards, Vipul Phulphagar

Hi @lisovyi , Thank you. I guess I should better off move to 3.7 to avoid such issues. Although, I’m still facing the same issue with the workflow that you’ve shared. My sample workflow: https://hub.knime.com/vipul/space/11962_rel372-1 I presume it’s again because of the incompatibility? Regards, Vipul Phulphagar

KNIME SQLite Connector - Web Portal

KNIME Server

vipul August 14, 2019, 12:52pm 6

Hi @thor,
Interesting point. Thank you.

Also @lisovyi, the “URI to File Path” node doesn’t seem to work on the server.
I found this:

1 Like