# MSSQL Node Transfer Failure

**URL:** <https://discourse.nodered.org/t/mssql-node-transfer-failure/42713>\
**Category:** General\
**Created:** [16 March 2021 12:56 UTC](https://discourse.nodered.org/t/mssql-node-transfer-failure/42713 "2021-03-16T12:56:43Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Eintracht00](https://avatars.discourse-cdn.com/v4/letter/e/3d9bf3/32.png) [@Eintracht00](https://discourse.nodered.org/u/Eintracht00)\
**Post date:** [16 March 2021 12:56 UTC](https://discourse.nodered.org/t/mssql-node-transfer-failure/42713/1 "2021-03-16T12:56:43Z")

</div>

Hello i have a big problem.  
I receive data from a MQTT Broker via HTTP - Request, that works.  
I split the Data into Key:Value, that works too.  
now i want to become some Data to my MSSQL Server with the node MSSQL PLUS.  
I get the Data into my MSSQL Server in the right Table, but it send some entries very often and thats not what it should do. Anyway i get some Failure **Validation failed for parameter 'deltaV'. Invalid number** for example or **Unable to evaluate value for parameter at index [6] named 'deltaV'**.  
i get around 200 objects from MQTT Broker and want to get the Data in splitted into my columbs, but finally i get like 15.000 entries in my Server instead of 200.

 ![grafik](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/7/f/7f5975da0372c239101402793f729fcf8d9320ce.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:** [16 March 2021 13:29 UTC](https://discourse.nodered.org/t/mssql-node-transfer-failure/42713/2 "2021-03-16T13:29:23Z")

</div>

> [@Eintracht00](#):
>
> Anyway i get some Failure **Validation failed for parameter 'deltaV'. Invalid number** for example or **Unable to evaluate value for parameter at index [6] named 'deltaV'**.

Put a debug node before the MSSQL node - what is inside `msg.payload.js.state.deltaV`?

> [@Eintracht00](#):
>
> i get around 200 objects from MQTT Broker and want to get the Data in splitted into my columbs, but finally i get like 15.000 entries in my Server instead of 200.

Cant answer that if you dont share your flow. However, I can pretty much gurantee, if you have 15000 entries, it is because MSSQL node was called 15000 times (i.e. you have a fault with your flow.)

To prove this, attach a counter before the MSSQL node.  
 ![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/7/d/7d41cd8134a2f4c1a2a85aab34375e5a48f5e58f.png)

counter flow...

```auto
[{"id":"911d54b2.3cccc8","type":"inject","z":"5ddceec1.ee69f","name":"test","props":[{"p":"payload"},{"p":"topic","vt":"str"}],"repeat":"","crontab":"","once":false,"onceDelay":0.1,"topic":"","payload":"","payloadType":"date","x":750,"y":2180,"wires":[["506151a8.023a8"]]},{"id":"e99a9577.3717c8","type":"inject","z":"5ddceec1.ee69f","name":"reset","props":[{"p":"reset","v":"","vt":"date"},{"p":"topic","vt":"str"}],"repeat":"","crontab":"","once":false,"onceDelay":0.1,"topic":"reset","x":750,"y":2260,"wires":[["506151a8.023a8"]]},{"id":"506151a8.023a8","type":"function","z":"5ddceec1.ee69f","name":"counter","func":"var c = (context.get(\"count\") || 0) + 1;\n\nif(msg.topic == \"reset\" || msg.reset)\n c = 0;\n \ncontext.set(\"count\", c) \nnode.status({text: c});\n\nreturn msg;","outputs":1,"noerr":0,"initialize":"","finalize":"","x":895,"y":2220,"wires":[[]],"icon":"node-red-dashboard/ui_numeric.png","l":false}]

```