MSSQL Node - Causes NR to keep crashing

General
1

Hi ,

On MSSQL Node - i see below errors in my console log.

Per past discussion for keeping MSSQL credentials across envs - we stored {MY_USER} and {MY_PASS} in cred file and have moved it other env. Problem is NR doesnt even come up.
On startup - we see below MSSQL node errors by the process :-

14 Jun 05:44:38 - [info] [MSSQL-CN:APPNAME] Error connecting to server : xxxx-appname-sqlsvr.database.windows.net, database : APPNAME_DB, port : 1433, user :
ConnectionError: Connection is closed.
at Request._query (/usr/src/node-red/node_modules/mssql/lib/base/request.js:497:37)
at Request._query (/usr/src/node-red/node_modules/mssql/lib/tedious/request.js:367:11)
at /usr/src/node-red/node_modules/mssql/lib/base/request.js:461:12
at new Promise ()
at Request.query (/usr/src/node-red/node_modules/mssql/lib/base/request.js:460:12)
at dynatraceRegularInvoke (/opt/dynatrace/oneagent/agent/bin/1.239.226.20220509-150249/any/nodejs/nodejsagent.js:2918:20)
at Object.b.safeInvoke (/opt/dynatrace/oneagent/agent/bin/1.239.226.20220509-150249/any/nodejs/nodejsagent.js:2990:41)
at Request.query (/opt/dynatrace/oneagent/agent/bin/1.239.226.20220509-150249/any/nodejs/nodejsagent.js:12178:15)
at connection.node.execSql (/usr/src/node-red/node_modules/node-red-contrib-mssql-plus/src/mssql.js:423:40)
at doSQL (/usr/src/node-red/node_modules/node-red-contrib-mssql-plus/src/mssql.js:779:25) {
code: 'ECONNCLOSED'

As i last checked env has the credentials as env variables.
Assuming they are not enabled, will this result in NR crashing ?

2

Looks like you are not picking up the user name

Q: are you 100% certain this is crashing node-red?
Q: When does this occur - after flows are started? (you didnt include full logs)

PS: PLEASE wrap code & logs etc in a code block (press the </> code button on forum toolbar THEN paste logs)

3

Yes. Its in docker and pod keeps going down.

Will come back.

My bad. Will take care.

4

Rechecked this. Hold the thought. May not something with SQLS. We will still investigating . Will keep you psted.

5

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