WARN: DB Connection no longer available. Go to advanced settings to enable connection restoration

KNIME Analytics Platform
1

If you are using the new DB Connection (in Knime 4.x) for multiple DB Queries, you will need to check the Restore Database Connection setting the Advanced options for the DB Connection Node:

31
31662×639 33.7 KB

If you don’t have that checked, you will run into the following errors:
DB Connection no longer available. Go to advanced settings to enable connection restoration

2

Hi @saqib,

Could you please elaborate how you use the DB Connector node as I can’t reproduce your issue? Which type of database are you using? How many queries are connected to the connector node?

Thanks in advance,
Best,

Michael

3

Hello @MichaelRespondek,

I am using the DB Connector against an MySQL 8 Server. And each DB Connector is connected to 4-5 DB Query nodes.

Let me know if you need the logs from the flow.

Saqib

4

Hello @saqib,

Please send me the workflow logs, I will have a look at it, as I can’t reproduce the connection interrupts on my test system.

Best,
Michael

5

This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.