Node Red Azure Error: No event 'socketConnect' in state 'Final'

General
1

hello I have a problem with the azure sql node (node-red-contrib-azure-sql node) I tried sending data via MQTT mosquitto on Ubuntu, but it has the following error results:

19 Jun 07:35:37 - [info] [Azure SQL:Azure SQL] Trying to insert data into Database
(node:2861) [DEP0064] DeprecationWarning: tls.createSecurePair() is deprecated. Please use tls.Socket instead.
19 Jun 07:35:37 - [info] [Azure SQL:Azure SQL] Connected
19 Jun 07:35:37 - [info] [Azure SQL:Azure SQL] Insert Complete. ID of inserted item is null
Insert complete.
19 Jun 07:35:38 - [info] [Azure SQL:Azure SQL] String
19 Jun 07:35:38 - [info] [Azure SQL:Azure SQL] Trying to insert data into Database
19 Jun 07:35:38 - [info] [Azure SQL:Azure SQL] String
19 Jun 07:35:38 - [info] [Azure SQL:Azure SQL] Trying to insert data into Database
19 Jun 07:35:38 - [red] Uncaught Exception:
19 Jun 07:35:38 - Error: No event 'socketConnect' in state 'Final'
at Connection.dispatchEvent (/root/.node-red/node_modules/tedious/lib/connection.js:674:28)
at Connection.socketConnect (/root/.node-red/node_modules/tedious/lib/connection.js:698:19)
at /root/.node-red/node_modules/tedious/lib/connection.js:591:16
at Socket.onConnect (/root/.node-red/node_modules/tedious/lib/connector.js:176:9)
at emitNone (events.js:106:13)
at Socket.emit (events.js:208:7)
at TCPConnectWrap.afterConnect [as oncomplete] (net.js:1185:10)

Can you help me?

2

This my Flow Azure SQL

3

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