Hello,
I've been using the node-red-contrib-azure-sql to send data from my node-red flow to my Azure SQL database, for a while now without any problem.
But this morning, POUFF ! Every flow that uses this node stopped working. I've tried to reinstall everything, I tried to use different computers... nothing works. But I'm able to send data to my database using SMSS software on the same computer. Weird is'n it.
Here is the error I got... Any Idea... Thanks
28 Oct 14:11:48 - [red] Uncaught Exception:
28 Oct 14:11:48 - Error: No event 'socketConnect' in state 'Final'
at Connection.dispatchEvent (C:\Mypath\node-red\user\node_modules\tedious\lib\connection.js:674:28)
at Connection.socketConnect (C:\Mypath\node-red\user\node_modules\tedious\lib\connection.js:698:19)
at C:\Mypath\node-red\user\node_modules\tedious\lib\connection.js:591:16
at Socket.onConnect (C:\Mypath\node-red\user\node_modules\tedious\lib\connector.js:176:9)
at Socket.emit (events.js:198:13)
at TCPConnectWrap.afterConnect [as oncomplete] (net.js:1092:10)
npm ERR! code ELIFECYCLE
npm ERR! errno 1
npm ERR! my_server_name@2.0.3 start: node ./node_modules/node-red/red.js --settings ./settings --userDir ./node-red/user
npm ERR! Exit status 1
npm ERR!
npm ERR! Failed at the ay_server_name@2.0.3 start script.
npm ERR! This is probably not a problem with npm. There is likely additional logging output above.
npm ERR! A complete log of this run can be found in:
npm ERR! C:\my_server_name\AppData\Roaming\npm-cache_logs\2019-10-28T18_11_49_218Z-debug.log
So what did you change, update or install?
When you say you reinstalled everything what do you mean?
Is the database onteh same machine?
Did some security/networking item change?
I find if I provide some basic information, I get faster responses to my queries. When I start a thread, I provide:
hardware being used,
OS and version being used,
node-red version,
node.js version
dashboard version (if using it)
name of any contrib nodes (node-red-contrib-cron-plus for example) that I'm using
Here are more details about the problem
When I say that I have reinstalled everything, I mean reinstalling the node-red-contrib-azure-sql module and the tedious module. The Azure node is dependent on Tedious
The database I use is Azure SQL, on the cloud of course. Although I am able to send data using SSMS on my computer, with Node-Red it is impossible. Even if you use the same credentials.
No security settings have been changed, nor have network settings been changed
Details
Windows 10 computer with 4GB RAM and 64GB SSD
Node.js V4.2.3
Nodes: node-red-contrib-azure-sql and tedious
Node-Red V0.16.2
the problem occurs when I try to insert a new line in the online database
The trace of the problem:
28 Oct 14:11:48 - [red] Uncaught Exception:
28 Oct 14:11:48 - Error: No event 'socketConnect' in state 'Final'
at Connection.dispatchEvent (C:\Mypath\node-red\user\node_modules\tedious\lib\connection.js:674:28)
at Connection.socketConnect (C:\Mypath\node-red\user\node_modules\tedious\lib\connection.js:698:19)
at C:\Mypath\node-red\user\node_modules\tedious\lib\connection.js:591:16
at Socket.onConnect (C:\Mypath\node-red\user\node_modules\tedious\lib\connector.js:176:9)
at Socket.emit (events.js:198:13)
at TCPConnectWrap.afterConnect [as oncomplete] (net.js:1092:10)
npm ERR! code ELIFECYCLE
npm ERR! errno 1
npm ERR! my_server_name@2.0.3 start: node ./node_modules/node-red/red.js --settings ./settings --userDir ./node-red/user
npm ERR! Exit status 1
npm ERR!
npm ERR! Failed at the ay_server_name@2.0.3 start script.
npm ERR! This is probably not a problem with npm. There is likely additional logging output above.
npm ERR! A complete log of this run can be found in:
npm ERR! C:\my_server_name\AppData\Roaming\npm-cache_logs\2019-10-28T18_11_49_218Z-debug.log
Well your node.js version and Node-RED are very old. There could be a conflict between them and the latest version of node-red-contrib-azure-sql or with tedious.