SQLite Connector, Execute failed: path does not exist

[HURIMOZ]

Hi, Iʻm working on workflow Build Model and Iʻm getting this error in the SQLite Connector node (located in node Measurement Database): ERROR SQLite Connector 4:13:0:7 Execute failed: path to ‘C:\Users\XXXX\knime-workspace\data\data.sqlite’: ‘C:\Users\XXXX\knime-workspace\data’ does not exist.
Can you help me solve this issue please?

[AlexanderFillbrunn]

Hi,
Did you check if the path exists in your file system? SQLite is a file-based database and needs access to a local path. If this does not exist, the database cannot be connected to. To make your workflows easy to move, it might make sense to use a knime:// URL instead of the local path. E.g. knime://knime.workflow/data points to a folder called “data” that sits in the workflow’s directory on your disk. When you move the workflow, it will still point to the correct folder.
Kind regards,
Alexander

[HURIMOZ]

Hi Alexander, thanks for your help. It worked.