# Can't receive error from node Node-red-contrib-mssql-plus

**URL:** <https://discourse.nodered.org/t/cant-receive-error-from-node-node-red-contrib-mssql-plus/26290>\
**Category:** General\
**Created:** [8 May 2020 06:56 UTC](https://discourse.nodered.org/t/cant-receive-error-from-node-node-red-contrib-mssql-plus/26290 "2020-05-08T06:56:27Z")\
**Posts on this page:** 12\
**Page:** 1

<div class="post-metadata">

**Author:** ![R-sa](https://avatars.discourse-cdn.com/v4/letter/r/ce73a5/32.png) [@R-sa](https://discourse.nodered.org/u/R-sa)\
**Post date:** [8 May 2020 06:56 UTC](https://discourse.nodered.org/t/cant-receive-error-from-node-node-red-contrib-mssql-plus/26290/1 "2020-05-08T06:56:27Z")

</div>

In Node-Red V1.0.6 Node.js V12.16.3  
I update Node-red-contrib-mssql to Node-red-contrib-mssql-plus(V 0.4.3) by use nmp uninstall.  
It can connect and receive data from SQL correctly. But when error occur node status stuck at requesting even though console log return error done.

 ![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/3/8/38944044e3c106df6862d6d4f2b363890d93acb5.png)  
 ![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/e/f/ef4b18ad098f72a881d13b2dbb8dc321b6d4a7f8.png)  
How to fix it.

Thank you very much, and sorry for my poor language

---

<div class="post-metadata">

**Author:** ![Trying\_to\_learn](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/trying_to_learn/32/28400_2.png) [@Trying\_to\_learn](https://discourse.nodered.org/u/Trying_to_learn)\
**Post date:** [8 May 2020 07:16 UTC](https://discourse.nodered.org/t/cant-receive-error-from-node-node-red-contrib-mssql-plus/26290/2 "2020-05-08T07:16:43Z")

</div>

I think the problem is you don't have anything connected to the `catch all` node.

Try putting a `debug` node on it and see what happens.

If you see the error in that node (the `debug` node) I hope you can work it out from there.  
Because it is now beyond my level of skills.

---

<div class="post-metadata">

**Author:** ![Steve-Mcl](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/steve-mcl/32/4826_2.png) [@Steve-Mcl](https://discourse.nodered.org/u/Steve-Mcl)\
**Post date:** [8 May 2020 07:45 UTC](https://discourse.nodered.org/t/cant-receive-error-from-node-node-red-contrib-mssql-plus/26290/3 "2020-05-08T07:45:36Z")

</div>

Ignore the status for now (I will fix that), node status only updated when it's executed.

1. Set the MSSQL node to throw errors (option at bottom of its settings)
2. attach a debug node (set to show complete message) to the catch node
3. Put a debug node just before MSSQL, set to show complete message
4. Run the flow & show us the debug output (expand every property please)

---

<div class="post-metadata">

**Author:** ![R-sa](https://avatars.discourse-cdn.com/v4/letter/r/ce73a5/32.png) [@R-sa](https://discourse.nodered.org/u/R-sa)\
**Post date:** [11 May 2020 02:01 UTC](https://discourse.nodered.org/t/cant-receive-error-from-node-node-red-contrib-mssql-plus/26290/4 "2020-05-11T02:01:03Z")

</div>

sorry for my slow respond.  
 ![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/a/5/a529944cf0e084f7c6515561508918fd77cbc560.png)  
It's not send anything too.

---

<div class="post-metadata">

**Author:** ![R-sa](https://avatars.discourse-cdn.com/v4/letter/r/ce73a5/32.png) [@R-sa](https://discourse.nodered.org/u/R-sa)\
**Post date:** [11 May 2020 02:11 UTC](https://discourse.nodered.org/t/cant-receive-error-from-node-node-red-contrib-mssql-plus/26290/5 "2020-05-11T02:11:36Z")

</div>

sorry for my slow respond.

 ![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/8/0/80f31885c4dc188f1add3f5fdf6a44d0f3e5697c.png)  
It's don't send anything when error.

If it's run successes debug show

 ![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/a/7/a70d625dcefd6604c871126d8176e265b37e68d7.png)

---

<div class="post-metadata">

**Author:** ![Steve-Mcl](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/steve-mcl/32/4826_2.png) [@Steve-Mcl](https://discourse.nodered.org/u/Steve-Mcl)\
**Post date:** [11 May 2020 06:23 UTC](https://discourse.nodered.org/t/cant-receive-error-from-node-node-red-contrib-mssql-plus/26290/6 "2020-05-11T06:23:54Z")

</div>

> [@R-sa](#):
>
> It's don't send anything when error

How is the MSSQL triggered - every second? There is a default 15s timeout - does error not occur after 15secs?

Can you share your flow and sample query so I can debug?

---

<div class="post-metadata">

**Author:** ![R-sa](https://avatars.discourse-cdn.com/v4/letter/r/ce73a5/32.png) [@R-sa](https://discourse.nodered.org/u/R-sa)\
**Post date:** [11 May 2020 10:38 UTC](https://discourse.nodered.org/t/cant-receive-error-from-node-node-red-contrib-mssql-plus/26290/7 "2020-05-11T10:38:22Z")

</div>

In old program i test by manual trigger.

This is new flow test program that still got same problem.

```auto
[{"id":"21b89937.b02616","type":"tab","label":"Flow 1","disabled":false,"info":""},{"id":"e0812b3c.3ae198","type":"inject","z":"21b89937.b02616","name":"","topic":"","payload":"","payloadType":"date","repeat":"","crontab":"","once":false,"onceDelay":0.1,"x":300,"y":220,"wires":[["bbefc0de.1e253"]]},{"id":"63fd87f.6c2a878","type":"MSSQL","z":"21b89937.b02616","mssqlCN":"bec4be8.58d5d4","name":"","query":"","outField":"payload","returnType":0,"throwErrors":1,"x":660,"y":220,"wires":[["2e13a543.0b9daa"]]},{"id":"bbefc0de.1e253","type":"function","z":"21b89937.b02616","name":"Right Query","func":"msg.payload = \"select * from Test_Delete_SQL\"\nreturn msg;","outputs":1,"noerr":0,"x":490,"y":220,"wires":[["63fd87f.6c2a878"]]},{"id":"2e13a543.0b9daa","type":"debug","z":"21b89937.b02616","name":"","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"false","x":860,"y":220,"wires":[]},{"id":"6863912f.159f7","type":"function","z":"21b89937.b02616","name":"Error Query","func":"msg.payload = \"select * from Test_Delete_SQLa\"\nreturn msg;","outputs":1,"noerr":0,"x":490,"y":300,"wires":[["6b545c38.b1b7e4"]]},{"id":"6aa4b03f.07efe","type":"inject","z":"21b89937.b02616","name":"","topic":"","payload":"","payloadType":"date","repeat":"","crontab":"","once":false,"onceDelay":0.1,"x":300,"y":300,"wires":[["6863912f.159f7"]]},{"id":"6b545c38.b1b7e4","type":"MSSQL","z":"21b89937.b02616","mssqlCN":"bec4be8.58d5d4","name":"","query":"","outField":"payload","returnType":0,"throwErrors":1,"x":660,"y":300,"wires":[["1d9a1239.b8639e","ec964519.29faa8","7e9addf2.0e84e4"]]},{"id":"1d9a1239.b8639e","type":"debug","z":"21b89937.b02616","name":"","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"false","x":860,"y":300,"wires":[]},{"id":"ec964519.29faa8","type":"debug","z":"21b89937.b02616","name":"","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"error","targetType":"msg","x":860,"y":360,"wires":[]},{"id":"7e9addf2.0e84e4","type":"debug","z":"21b89937.b02616","name":"","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"true","targetType":"full","x":850,"y":420,"wires":[]},{"id":"828ade27.de485","type":"debug","z":"21b89937.b02616","name":"","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"true","targetType":"full","x":850,"y":500,"wires":[]},{"id":"40a3a135.84394","type":"catch","z":"21b89937.b02616","name":"","scope":null,"uncaught":false,"x":680,"y":500,"wires":[["828ade27.de485"]]},{"id":"bec4be8.58d5d4","type":"MSSQL-CN","z":"","tdsVersion":"7_3_B","name":"test","server":"127.0.0.1","port":"1433","encyption":false,"database":"test","useUTC":true,"connectTimeout":"15000","requestTimeout":"15000","cancelTimeout":"5000","pool":"5","parseJSON":false}]

```

 ![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/c/d/cd435d3765dd644fd74320a3bf560ceace6f5aa1.png)  
Node setting

window 10 Pro 64bit Node-Red V1.0.6 Node.js V12.16.3

Thank you very much

---

<div class="post-metadata">

**Author:** ![Steve-Mcl](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/steve-mcl/32/4826_2.png) [@Steve-Mcl](https://discourse.nodered.org/u/Steve-Mcl)\
**Post date:** [11 May 2020 11:19 UTC](https://discourse.nodered.org/t/cant-receive-error-from-node-node-red-contrib-mssql-plus/26290/8 "2020-05-11T11:19:12Z")

</div>

I'll take a look - thanks.

PS, I edited your post to better format the code like this...

`````  
`code here`  
`````

---

<div class="post-metadata">

**Author:** ![Steve-Mcl](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/steve-mcl/32/4826_2.png) [@Steve-Mcl](https://discourse.nodered.org/u/Steve-Mcl)\
**Post date:** [11 May 2020 11:30 UTC](https://discourse.nodered.org/t/cant-receive-error-from-node-node-red-contrib-mssql-plus/26290/9 "2020-05-11T11:30:50Z")

</div>

Hi, you are correct - I have found a bug that crept in 17 days ago.

I have fixed it locally & this is what you should get...

 ![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/2/5/254d10f7ab55d9961d5efaab789da01a1cb0c9d2.png)

I'll update the repo and NPM in a few minutes - then let you know.

---

<div class="post-metadata">

**Author:** ![Steve-Mcl](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/steve-mcl/32/4826_2.png) [@Steve-Mcl](https://discourse.nodered.org/u/Steve-Mcl)\
**Post date:** [11 May 2020 11:42 UTC](https://discourse.nodered.org/t/cant-receive-error-from-node-node-red-contrib-mssql-plus/26290/10 "2020-05-11T11:42:02Z")

</div>

@R-sa - node is now updated to v0.4.4 with fix included

> **[node-red-contrib-mssql-plus](https://flows.nodered.org/node/node-red-contrib-mssql-plus)**
>
> Node for node-red to connect to a Microsoft MS SQL Database

Please test and feedback.

---

<div class="post-metadata">

**Author:** ![R-sa](https://avatars.discourse-cdn.com/v4/letter/r/ce73a5/32.png) [@R-sa](https://discourse.nodered.org/u/R-sa)\
**Post date:** [11 May 2020 17:27 UTC](https://discourse.nodered.org/t/cant-receive-error-from-node-node-red-contrib-mssql-plus/26290/11 "2020-05-11T17:27:03Z")

</div>

When update node to v0.4.4 now error can send through msg.error and throw error option.

 ![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/6/3/630d1abc1abe6287167936255c06e042418be950.png)  
Thank you very much for guide format code and update node.  
It's a very useful node.

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/1X/d073cd938eafa2e558d7c2cd59003b3ef4963033.png) [@system](https://discourse.nodered.org/u/system)\
**Post date:** [25 May 2020 17:27 UTC](https://discourse.nodered.org/t/cant-receive-error-from-node-node-red-contrib-mssql-plus/26290/12 "2020-05-25T17:27:05Z")

</div>

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