I upgraded my Node-red today from v3.1.0 to 3.1.3 (running on Windows), and my Oracle DB node (node-red-contrib-oracledb-mod, version 0.6.3) stopped working.
The underlying configuration node (connection profile) is always flagged as having an error (red triangle) even when configured correctly, and the interaction with the DB fails. Everything was working well on NR 3.1.0.
I'm running Node JS 20.10.0 (LTS) and tested this with other Node JS versions, but problem persists.
Did anyone else encounter this or has an idea how to solve?
I think that the node validation checking became more robust in 3.1.3, so check that you have valid entries for all fields in the node. If it has a config node for the database node check that too. Even if you can't see any problem, make a minor tweak in each one if you can (a name change for example) and click Done for the nodes. See if that helps.
Otherwise select the node and export it and paste it here.
I see from the node's github page that there are a number of unaddressed issues with the node, it appears to have been abandoned, so if you have ongoing problems with it you may have to look for an alternative solution.
In theory, the stricter checking came from explicit changes we made to individual nodes to do that checking - rather than something that would apply more generally to all nodes.
@omrid can you export an example of the node with an error and share it here? Just make sure you replace any sensitive information in the export such as urls/usernames etc.
As far as I know this is the only reported problem with 3.1.3
You can either run the install script from the docs, which will upgrade it, or you can run sudo npm install -g --unsafe-perm node-red@latest
Then restart node red.
Thanks @knolleary. Does the above mean that a future Node-red fix will know how to handle the existing Oracle config node, or that this node will need to be updated to return a Boolean result?
It requires the node to be updated, but I see (looking at the pull request link posted by Nick) that the author has already merged it into the code, which means you don't need to wait for him/her to release it, you can install direct from github by going into your .node-red folder and running npm install vtulluru/node-red-contrib-oracledb-mod
Then restarting node-red.