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.
Put a debug node before the MSSQL node - what is inside msg.payload.js.state.deltaV?
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.
counter flow...
[{"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}]
