Hi All, I am attaching the flow below ,where here using 2 moment nodes(node-red-contrib-moment) in the same flow, and I am facing the issue second moment node and insert function is printing twice in the debug console , so because of this, same two records are inserting into the database. can you…

I would add a debug node to each output of the “Deciding insert or update” to see what is showing up. You might want to add a debug node to the output of the first database node to see what you are retrieving.

[{"id":"6e9e4a88.0261c4","type":"tab","label":"Order Sync to ERP","disabled":false,"info":""},{"id":"78904ae2.44df94","type":"function","z":"6e9e4a88.0261c4","name":"Payload is not empty","func":" var SCBASICSYNC = global.get('appconfig').oracledbschema + `.` + global.get('appconfig').tableSCBASICSY…

Did you follow @zenofmud 's advise? Assuming that you have then you have not told us what the results were.

yep I tried that, but no use, for first db node,I am getting the response only once, but debug nodes are printing twice from second moment node on wards , I have attached the flow in the above comment, please have a look into it

So if I understand correctly you are getting one message out of the first moment node but that leads to two messages out of the second. If that is correct then have homed in on the problem. Show us the debug for those three messages.

[image] In this image , first message for first moment node, second and third message for 2nd moment node From first moment i am getting only one message, but from second moment, same message getting twice

Can you expand the payload in each case please. Also stop node red then start it in a terminal and post the log that you get there please. It should contain the Welcome to node red message.

Also please name all your debug nodes. that will make it easier to see which debug output in the log goes with which debug node in the flow.

Same record is inserting twice

General

ukmoose 11 October 2019 08:28 2

Unfortunately your flow isn't currently importable.Please read the following post How to share code or flow json and then edit the above message.

Topic		Replies	Views
Http Response node error and same record is inserting and updating twice General	4	750	1 November 2019
SOLVED ... Sqlite insert 2 readings on the same row? General	19	1429	2 November 2018
Need Help to Insert, Update and Delete Data from Node-RED Dashboard Inputs to the Database Dashboard	34	19101	3 May 2019
Maximum Insert Speed for mySQL through network? General	33	2013	4 September 2019
How to make 2 msgs go to a single database row ... I get 2 separate rows? General	9	183	10 August 2024

Same record is inserting twice

Related topics