[{"id":"af47db90.c714c8","type":"tab","label":"Flow 2","disabled":false,"info":""},{"id":"252febcc.2b8d54","type":"mqtt in","z":"af47db90.c714c8","name":"","topic":"VEHICLE/LINE3/STN_DATA","qos":"2","datatype":"json","broker":"9bd25e5c.ec8f5","nl":false,"rap":true,"rh":0,"x":120,"y":160,"wires":[["adfde7e4.eb8648"]]},{"id":"adfde7e4.eb8648","type":"function","z":"af47db90.c714c8","name":"","func":"var a=msg.payload;\n//var plcread = a;\n//var t = msg.topic;\n//var topic = t.split(\",\");\nvar b = a[0].Station_No;\nvar c = a[1].Conveyor_Name;\nvar d = a[2].Andon_PC;\nvar e = a[3].Start_Time;\nvar f = a[4].Stop_Time;\nvar g = a[5].Duration;\nvar h = a[6].Area_Name;\n//var h = selobj.Date_Time;\n\n//var dt = new Date(h);\n//var dts = dt.getFullYear().toString()+\"-\"+(dt.getMonth()+1).toString() + \"-\" + dt.getDate().toString() +\" \" + dt.getHours().toString()+\":\"+ dt.getMinutes().toString()+\":\"+ dt.getSeconds().toString()+\".\"+ dt.getMilliseconds().toString();\n\n//var P0 = dts;\n\n//msg.payload =\"'\"+b+\"'\"+','+\"'\"c+\"'\"+','+d+','+e+','+f+','+\"'\"+g+\"'\";\nmsg.payload =\"'\"+b+\"'\"+','+ \"'\"+c+\"'\"+','+d+','+e+','+f+','+g+','+\"'\"+h+\"'\";\nreturn msg;","outputs":1,"noerr":0,"initialize":"","finalize":"","libs":[],"x":340,"y":160,"wires":[["ca96ed2b.fdc13"]]},{"id":"57a5e27a.f34b5c","type":"mqtt in","z":"af47db90.c714c8","name":"","topic":"VEHICLE/LINE1/STN_DATA","qos":"2","datatype":"json","broker":"9bd25e5c.ec8f5","nl":false,"rap":true,"rh":0,"x":120,"y":220,"wires":[["522ffe3.f9aa1"]]},{"id":"ca96ed2b.fdc13","type":"debug","z":"af47db90.c714c8","name":"","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"false","statusVal":"","statusType":"auto","x":710,"y":120,"wires":[]},{"id":"522ffe3.f9aa1","type":"function","z":"af47db90.c714c8","name":"","func":"var a=msg.payload;\n//var plcread = a;\n//var t = msg.topic;\n//var topic = t.split(\",\");\nvar d = msg.myrawdate;\nvar dt = new Date(d);\nvar dts = dt.getFullYear().toString()+\"-\"+(dt.getMonth()+1).toString() + \"-\" + dt.getDate().toString() +\" \" + dt.getHours().toString()+\":\"+ dt.getMinutes().toString()+\":\"+ dt.getSeconds().toString()+\".\"+ dt.getMilliseconds().toString();\n\n\nvar Z = dts;\nvar b = a[0].Station_No;\nvar c = a[1].Conveyor_Name;\nvar e = a[2].Andon_PC;\nvar f = a[3].Start_Time;\nvar g = a[4].Stop_Time;\nvar h = a[5].Duration;\nvar i = a[6].Area_Name;\n\n//msg.payload =\"'\"+b+\"'\"+','+\"'\"c+\"'\"+','+d+','+e+','+f+','+\"'\"+g+\"'\";\nmsg.payload =\"'\"+b+\"'\"+','+ \"'\"+c+\"'\"+','+e+','+f+','+g+','+h+','+\"'\"+i+\"'\";\nreturn msg;","outputs":1,"noerr":0,"initialize":"","finalize":"","libs":[],"x":340,"y":220,"wires":[["c833c214.b3e7b"]]},{"id":"2d05fa48.d062f6","type":"debug","z":"af47db90.c714c8","name":"","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"payload","targetType":"msg","statusVal":"","statusType":"auto","x":730,"y":220,"wires":[]},{"id":"c833c214.b3e7b","type":"MSSQL","z":"af47db90.c714c8","mssqlCN":"3ffb8ccd.92c0d4","name":"Vehicle Andon","outField":"payload","returnType":0,"throwErrors":"0","query":"DECLARE @Station varchar(50)\nDECLARE @Conveyor varchar(30)\nDECLARE @Pc varchar(10)\nDECLARE @Start datetime\nDECLARE @Stop datetime\nDECLARE @Duration float\nDECLARE @Line varchar(50)\n\nSET @Station = '{{{payload.0}}}';\nSET @Conveyor = '{{{payload.1}}}';\nSET @Pc = '{{{payload.2}}}';\nSET @Start = '{{{payload.3}}}';\nSET @Stop = '{{{payload.4}}}';\nSET @Duration = '{{{payload.5}}}';\nSET @Line = '{{{payload.6}}}';\nINSERT INTO dbo.Vehicle_Andon\n (Station, Conveyor, Andon_PC, Start_Time, Close_Time, Duration, LINE_NAME )\nVALUES ( @Station,\n @Conveyor,\n @Pc,\n @Start,\n @Stop,\n @Duration,\n @Line \n )","modeOpt":"","modeOptType":"query","queryOpt":"","queryOptType":"editor","paramsOpt":"","paramsOptType":"none","rows":"rows","rowsType":"msg","params":[],"x":520,"y":220,"wires":[["2d05fa48.d062f6"]]},{"id":"9bd25e5c.ec8f5","type":"mqtt-broker","name":"HiveMQ","broker":"172.27.138.122","port":"1883","clientid":"","usetls":false,"protocolVersion":"4","keepalive":"60","cleansession":true,"birthTopic":"","birthQos":"0","birthPayload":"","birthMsg":{},"closeTopic":"","closeQos":"0","closePayload":"","closeMsg":{},"willTopic":"","willQos":"0","willPayload":"","willMsg":{},"sessionExpiry":""},{"id":"3ffb8ccd.92c0d4","type":"MSSQL-CN","tdsVersion":"7_4","name":"Andon_data_central_server","server":"172.27.142.80","port":"1433","encyption":true,"trustServerCertificate":true,"database":"Vehicle_Factory_Andon","useUTC":true,"connectTimeout":"15000","requestTimeout":"15000","cancelTimeout":"5000","pool":"5","parseJSON":false,"enableArithAbort":true}]
To insert data to MSSQL i am using this flow. Where startime and stoptime is have datetime type data in SQL server. An error is throwing by sql which i have attached.
