Configuration loss after Knime 4.7.0 to 4.7.1 upgrade problem

Hello @ojmartinez ,

I would suggest to try and solve the problem with the new DB framework instead of using the deprecated one. Can you try and execute the following command

ALTER DATABASE Upgrade JCONNECT ON

as explained here: coldfusion - JZ0SJ: Metadata accessor information was not found on this database - Stack Overflow

Regarding the problem with the deprecated database framework, the driver registration page for the deprecated database framework is no longer visible in the KNIME preferences. The one you are showing is for the new DB framework which is why the driver is not listed in the deprecated connector node anymore. It also seems that you are using a new workspace which is why the existing settings including the driver registration information is no longer available.
To register drivers for the deprecated database framework you need to manually edit the following file by changing the path to the driver you want to use.
preferences_only_driver.txt (203 Bytes)
Once edited you can import the file to the new workspace via File->Import Preferences. Make sure to change the file extension filter from *.epf to *.*
Another alternative is to download and install an older version from here. Then register the driver via the Database (legacy) preference page, export the preferences vie File->Export Preferences and then import it into the new KNIME version via File->Import Preferences.
image

You need to restart KNIME Analytics Platform after importing the preferences in order to have legacy database framework pickup the new driver files.

Bye
Tobias

2 Likes