Hi,
I am new to node-red. I am also a non programmer.
However I am trying to write some tags read from a node (rockwell PLC) into a database (SQLSERVER).
Every minute (set in the PLC node) all configured tags are inserted into the database, but I get a connection failure with the database for each configured tag, but at the end all tags are written to the database and sometimes it writes 2 or 3 times the same row in the database.
I need help fixing these errors please.
What node is the MSSQL - node-red-contrib-????????
Add a debug node to output of CLX - are you 100% certain there is only 1 msg per minute?
Set debug 6 to output "complete message" - show us what you get.
Add a catch node & connect it to a debug node (set the debug to show complete message)
Hi Steve_Mcl
node-red-contrib-mssql-plus : MSSQL
Inside the CLX node I configured 100 tags, as shown below.
For ¨"debug 6" "complete message"
02/01/2023 17:02:32node: SQL_DnAmsg : error
"ConnectionError: Connection is closed."
02/01/2023 17:02:32node: SQL_DnAmsg : error
"ConnectionError: Connection is closed."
02/01/2023 17:02:32node: SQL_DnAmsg : error
"ConnectionError: Connection is closed."
02/01/2023 17:02:33node: SQL_DnAmsg : error
"ConnectionError: Connection is closed."
02/01/2023 17:02:33node: SQL_DnAmsg : error
"ConnectionError: Connection is closed."
02/01/2023 17:02:33node: SQL_DnAmsg : error
"ConnectionError: Connection is closed."
02/01/2023 17:02:33node: SQL_DnAmsg : error
"ConnectionError: Connection is closed."
02/01/2023 17:02:33node: SQL_DnAmsg : error
"ConnectionError: Connection is closed."
02/01/2023 17:02:33node: SQL_DnAmsg : error
"ConnectionError: Connection is closed."
02/01/2023 17:02:33node: SQL_DnAmsg : error
"ConnectionError: Connection is closed."
02/01/2023 17:02:33node: SQL_DnAmsg : error
"ConnectionError: Connection is closed."
02/01/2023 17:02:33node: SQL_DnAmsg : error
"ConnectionError: Connection is closed."
02/01/2023 17:02:33node: SQL_DnAmsg : error
"ConnectionError: Connection is closed."
02/01/2023 17:02:33node: SQL_DnAmsg : error
"ConnectionError: Connection is closed."
02/01/2023 17:02:33node: SQL_DnAmsg : error
"ConnectionError: Connection is closed."
02/01/2023 17:02:33node: SQL_DnAmsg : error
"ConnectionError: Connection is closed."
02/01/2023 17:02:33node: SQL_DnAmsg : error
"ConnectionError: Connection is closed."
02/01/2023 17:02:33node: SQL_DnAmsg : error
"ConnectionError: Connection is closed."
02/01/2023 17:02:33node: SQL_DnAmsg : error
"ConnectionError: Connection is closed."
02/01/2023 17:02:33node: SQL_DnAmsg : error
"ConnectionError: Connection is closed."
02/01/2023 17:02:33node: SQL_DnAmsg : error
"ConnectionError: Connection is closed."
02/01/2023 17:02:33node: SQL_DnAmsg : error
"ConnectionError: Connection is closed."
02/01/2023 17:02:33node: SQL_DnAmsg : error
"ConnectionError: Connection is closed."
02/01/2023 17:02:33node: SQL_DnAmsg : error
"ConnectionError: Connection is closed."
02/01/2023 17:02:33node: SQL_DnAmsg : error
"ConnectionError: Connection is closed."
02/01/2023 17:02:33node: SQL_DnAmsg : error
"ConnectionError: Connection is closed."
02/01/2023 17:02:33node: SQL_DnAmsg : error
"ConnectionError: Connection is closed."
02/01/2023 17:02:33node: SQL_DnAmsg : error
"ConnectionError: Connection is closed."
02/01/2023 17:02:33node: SQL_DnAmsg : error
"ConnectionError: Connection is closed."
02/01/2023 17:02:33node: SQL_DnAmsg : error
"ConnectionError: Connection is closed."
02/01/2023 17:02:33node: SQL_DnAmsg : error
"ConnectionError: Connection is closed."
02/01/2023 17:02:33node: SQL_DnAmsg : error
"ConnectionError: Connection is closed."
02/01/2023 17:02:33node: SQL_DnAmsg : error
"ConnectionError: Connection is closed."
02/01/2023 17:02:33node: SQL_DnAmsg : error
"ConnectionError: Connection is closed."
02/01/2023 17:02:33node: SQL_DnAmsg : error
"ConnectionError: Connection is closed."
02/01/2023 17:02:33node: SQL_DnAmsg : error
"ConnectionError: Connection is closed."
02/01/2023 17:02:33node: SQL_DnAmsg : error
"ConnectionError: Connection is closed."
02/01/2023 17:02:33node: SQL_DnAmsg : error
"ConnectionError: Connection is closed."
02/01/2023 17:02:33node: SQL_DnAmsg : error
"ConnectionError: Connection is closed."
02/01/2023 17:02:33node: SQL_DnAmsg : error
"ConnectionError: Connection is closed."
02/01/2023 17:02:33node: SQL_DnAmsg : error
"ConnectionError: Connection is closed."
02/01/2023 17:02:33node: SQL_DnAmsg : error
"ConnectionError: Connection is closed."
02/01/2023 17:02:33node: SQL_DnAmsg : error
"ConnectionError: Connection is closed."
02/01/2023 17:02:33node: SQL_DnAmsg : error
"ConnectionError: Connection is closed."
02/01/2023 17:02:34node: SQL_DnAmsg : error
"ConnectionError: Connection is closed."
02/01/2023 17:02:34node: SQL_DnAmsg : error
"ConnectionError: Connection is closed."
02/01/2023 17:02:34node: SQL_DnAmsg : error
"ConnectionError: Connection is closed."
02/01/2023 17:02:34node: SQL_DnAmsg : error
"ConnectionError: Connection is closed."
02/01/2023 17:02:34node: SQL_DnAmsg : error
"ConnectionError: Connection is closed."
02/01/2023 17:02:34node: SQL_DnAmsg : error
"ConnectionError: Connection is closed."
02/01/2023 17:02:34node: SQL_DnAmsg : error
"ConnectionError: Connection is closed."
02/01/2023 17:02:34node: SQL_DnAmsg : error
"ConnectionError: Connection is closed."
02/01/2023 17:02:34node: SQL_DnAmsg : error
"ConnectionError: Connection is closed."
02/01/2023 17:02:34node: SQL_DnAmsg : error
"ConnectionError: Connection is closed."
02/01/2023 17:02:34node: SQL_DnAmsg : error
"ConnectionError: Connection is closed."
02/01/2023 17:02:34node: SQL_DnAmsg : error
"ConnectionError: Connection is closed."
02/01/2023 17:02:34node: SQL_DnAmsg : error
"ConnectionError: Connection is closed."
02/01/2023 17:02:34node: SQL_DnAmsg : error
"ConnectionError: Connection is closed."
02/01/2023 17:02:34node: SQL_DnAmsg : error
"ConnectionError: Connection is closed."
02/01/2023 17:02:34node: SQL_DnAmsg : error
"ConnectionError: Connection is closed."
02/01/2023 17:02:34node: SQL_DnAmsg : error
"ConnectionError: Connection is closed."
02/01/2023 17:02:34node: SQL_DnAmsg : error
"ConnectionError: Connection is closed."
02/01/2023 17:02:34node: SQL_DnAmsg : error
"ConnectionError: Connection is closed."
02/01/2023 17:02:34node: SQL_DnAmsg : error
"ConnectionError: Connection is closed."
02/01/2023 17:02:34node: SQL_DnAmsg : error
"ConnectionError: Connection is closed."
02/01/2023 17:02:34node: SQL_DnAmsg : error
"ConnectionError: Connection is closed."
02/01/2023 17:02:34node: SQL_DnAmsg : error
"ConnectionError: Connection is closed."
02/01/2023 17:02:34node: SQL_DnAmsg : error
"ConnectionError: Connection is closed."
02/01/2023 17:02:34node: SQL_DnAmsg : error
"ConnectionError: Connection is closed."
02/01/2023 17:02:34node: SQL_DnAmsg : error
"ConnectionError: Connection is closed."
02/01/2023 17:02:34node: SQL_DnAmsg : error
"ConnectionError: Connection is closed."
02/01/2023 17:02:34node: SQL_DnAmsg : error
"ConnectionError: Connection is closed."
02/01/2023 17:02:34node: SQL_DnAmsg : error
"ConnectionError: Connection is closed."
02/01/2023 17:02:34node: SQL_DnAmsg : error
"ConnectionError: Connection is closed."
02/01/2023 17:02:34node: SQL_DnAmsg : error
"ConnectionError: Connection is closed."
02/01/2023 17:02:34node: SQL_DnAmsg : error
"ConnectionError: Connection is closed."
02/01/2023 17:02:34node: SQL_DnAmsg : error
"ConnectionError: Connection is closed."
02/01/2023 17:02:34node: SQL_DnAmsg : error
"ConnectionError: Connection is closed."
02/01/2023 17:02:34node: SQL_DnAmsg : error
"ConnectionError: Connection is closed."
02/01/2023 17:02:34node: SQL_DnAmsg : error
"ConnectionError: Connection is closed."
02/01/2023 17:02:34node: SQL_DnAmsg : error
"ConnectionError: Connection is closed."
02/01/2023 17:02:34node: SQL_DnAmsg : error
"ConnectionError: Connection is closed."
02/01/2023 17:02:34node: SQL_DnAmsg : error
"ConnectionError: Connection is closed."
02/01/2023 17:02:34node: SQL_DnAmsg : error
"ConnectionError: Connection is closed."
02/01/2023 17:02:34node: SQL_DnAmsg : error
"ConnectionError: Connection is closed."
02/01/2023 17:02:34node: SQL_DnAmsg : error
"ConnectionError: Connection is closed."
02/01/2023 17:02:35node: SQL_DnAmsg : error
"ConnectionError: Connection is closed."
02/01/2023 17:02:35node: SQL_DnAmsg : error
"ConnectionError: Connection is closed."
02/01/2023 17:02:35node: SQL_DnAmsg : error
"ConnectionError: Connection is closed."
02/01/2023 17:02:35node: SQL_DnAmsg : error
"ConnectionError: Connection is closed."
02/01/2023 17:02:35node: SQL_DnAmsg : error
"ConnectionError: Connection is closed."
02/01/2023 17:02:35node: SQL_DnAmsg : error
"ConnectionError: Connection is closed."
02/01/2023 17:02:35node: SQL_DnAmsg : error
"ConnectionError: Connection is closed."
02/01/2023 17:02:35node: SQL_DnAmsg : error
"ConnectionError: Connection is closed."
02/01/2023 17:02:35node: SQL_DnAmsg : error
"ConnectionError: Connection is closed."
02/01/2023 17:16:45node: debug 6msg : Object
object
payload: object
WetEvaporatedWater: 480
NewDryerInletPressure: -0.03750001639127731
OldDryerInletPressure: -0.11101727187633514
ExhaustAirFan: 88.16242218017578
AirHumiditySensor401: 390.1678771972656
.
.
.
.
Until the end of the tags configured into CLX node,
It looks like every tag is an individual message. You can see from the screenshot you posted there are many more than 1 per minute.
Also, as you have not expanded any of the payload objects I cannot see what is inside of them.
My guess is you are swamping the connection and cause it to close.
Sorrry,
I think you're right about the messages, but I still haven't found a way to select and insert these tags into the database.
At the end of mesage (on project) there is 1 msg payload expanded below.
03/01/2023 09:08:23node: debug 6msg : Object
object
payload: object
ProcessWaterFlow: 210.46693420410156
WetEvaporatedWater: 4.320000171661377
NewDryerInletPressure: -0.03831064701080322
OldDryerInletPressure: -0.11971460282802582
ExhaustAirFan: 86.49052429199219
AirHumiditySensor401: 358.81597900390625
WetTempSensorExhaustFan: 0.10964225232601166
FreshAirFanSpeed: 56.308921813964844
FreshAirPressure: 1.4811935424804688
CombustionAirFanSpeedNB: 99.9959487915039
ExhastAirFanNewDryer: 84.91012573242188
AirHumiditySensor801: 434.29962158203125
InletTemperatureZ8A: 230.79766845703125
OutletTemperatureZ8A: 173.19065856933594
InletTemperatureZ9A: 237.59727478027344
OutletTemperatureZ9A: 174.3968963623047
InletTemperatureZ10A: 232.29571533203125
OutletTemperatureZ10A: 171.59532165527344
InletTemperatureZ11A: 225
OutletTemperatureZ11A: 172.59727478027344
InletTemperatureZ12A: 217.89883422851562
OutletTemperatureZ12A: 32.09143829345703
PosServoBurner4: 0
InletTemperatureZ13A: 211.5953369140625
OutletTemperatureZ13A: 170.19454956054688
InletTemperatureZ14A: 208.29766845703125
OutletTemperatureZ14A: 156.49806213378906
InletTemperatureZ15A: 203.19065856933594
OutletTemperatureZ15A: 156.5953369140625
InletFreshAirTempExch: 24.494163513183594
OutletFreshAirTempExch: 109.4941635131836
InletAirTempExhaustExch: 132.29571533203125
NewDryerExhaustAirTemp: 171.2937774658203
GasValvePosBurnerZ3: 150.27236938476562
GasValvePosBurnerZ4: 0
GasValvePosBurnerZ5: 0
GasValvePosBurnerZ6: 0
GasValvePosBurnerZ7: 0
GasValvePosBurnerZ8: 0
GasValvePosBurnerZ9: 0
PosServoBurner5: 0
GasValvePosBurnerZ10: 0
GasValvePosBurnerZ11: 0
GasValvePosBurnerZ12: 0
GasValvePosBurnerZ13: 0
GasValvePosBurnerZ14: 0
GasValvePosBurnerZ15: 0
WetTempExhaustFanNewDryer: 114.67899322509766
WetTempExhaustFanCompleteDryer: 114.67899322509766
PosServoBurner6: 0
PosServoBurner1: 0
PosServoBurner7: 0
PosServoBurner8: 0
PosServoBurner9: 0
PosServoBurner10: 0
PosServoBurner11: 0
PosServoBurner12: 0
PosServoBurner2: 0
InputTemperatureBurner1: 198.69650268554688
OutputTemperatureBurner1: 153.80349731445312
InputTemperatureBurner2: 193.8910369873047
OutputTemperatureBurner2: 151.30349731445312
InputTemperatureBurner3: 187.8307342529297
OutputTemperatureBurner3: 145.9241180419922
InputTemperatureBurner4: 178.59921264648438
OutputTemperatureBurner4: 146.98443603515625
InputTemperatureBurner5: 180.9143829345703
OutputTemperatureBurner5: 135.4474639892578
InputTemperatureBurner6: 166.0116729736328
OutputTemperatureBurner6: 144.6692657470703
InputTemperatureBurner7: 164.2801513671875
OutputTemperatureBurner7: 142.0817108154297
InputTemperatureBurner8: 155.05836486816406
OutputTemperatureBurner8: 147.55836486816406
PosServoBurner3: 0
InputTemperatureBurner9: 154.37744140625
OutputTemperatureBurner9: 138.71595764160156
InputTemperatureBurner10: 142.9474639892578
OutputTemperatureBurner10: 129.67898559570312
InputTemperatureBurner11: 133.71595764160156
OutputTemperatureBurner11: 122.66536712646484
InputTemperatureBurner12: 119.97081756591797
OutputTemperatureBurner12: 111.89688873291016
InputTemperatureBurnerZ3A: 169.72763061523438
OutputTemperatureBurnerZ3A: 122.69454956054688
InputTemperatureBurnerZ4A: 187.5
OutputTemperatureBurnerZ4A: 145.49610900878906
InputTemperatureBurnerZ5A: 199.39688110351562
OutputTemperatureBurnerZ5A: 156.49806213378906
InputTemperatureBurnerZ6A: 217.0914306640625
OutputTemperatureBurnerZ6A: 167.89883422851562
InputTemperatureBurnerZ7A: 221.69259643554688
OutputTemperatureBurnerZ7A: 171.69261169433594
NewDryerGasFlowDnA: 628
OldDryerGasFlowDnA: 259
OperatorAdjustment: 2
Realevaporatedwater: 630.0724487304688
LiquidSum: 259.79571533203125
FabricationCode: 1
StuccoFlow: 360.560302734375
_msgid: "9bc30578a1e39283"
Editor: undefined
You need to single out that message. Something about it will be different to all the others. Use a switch node (or function node) to ensure it is the message of interest.
IMPORTANT:
In order for us forum users to help you, when you copy a message from node-red please do 2 things.
copy value button in the debug panel
</> first (or surround the pasted data with three backticks above and belowexample - your copied data should look like this...
{
"payload": {
"ProcessWaterFlow": 210.46693420410156,
"WetEvaporatedWater": 4.320000171661377,
"etc-etc-etc": 0
}
Sorry.
Now the right way.
{"payload":{"ProcessWaterFlow":210.0097198486328,"WetEvaporatedWater":4.309999942779541,"RealSpeedFormingBelt1":46,"ActEvaporation":11923,"NewDryerInletPressure":-0.04207416623830795,"OldDryerInletPressure":-0.12360572814941406,"ExhaustAirFan":86.11698150634766,"AirHumiditySensor401":318.9714050292969,"WetTempSensorExhaustFan":0.11608301103115082,"FreshAirFanSpeed":56.49250411987305,"FreshAirPressure":1.4732896089553833,"CombustionAirFanSpeedNB":99.99678039550781,"ExhastAirFanNewDryer":83.87821197509766,"AirHumiditySensor801":433.7141418457031,"InletTemperatureZ8A":230.29183959960938,"OutletTemperatureZ8A":173.79376220703125,"InletTemperatureZ9A":235.69065856933594,"OutletTemperatureZ9A":174.8929901123047,"InletTemperatureZ10A":232.59727478027344,"OutletTemperatureZ10A":172.7918243408203,"InletTemperatureZ11A":226.59532165527344,"OutletTemperatureZ11A":174.0953369140625,"InletTemperatureZ12A":217.89883422851562,"OutletTemperatureZ12A":32.09143829345703,"PosServoBurner4":0,"InletTemperatureZ13A":210.8949432373047,"OutletTemperatureZ13A":170.09727478027344,"InletTemperatureZ14A":209.09532165527344,"OutletTemperatureZ14A":156.29376220703125,"InletTemperatureZ15A":203.2976531982422,"OutletTemperatureZ15A":156.79962158203125,"InletFreshAirTempExch":25.69066047668457,"OutletFreshAirTempExch":109.89299774169922,"InletAirTempExhaustExch":133.19065856933594,"NewDryerExhaustAirTemp":171.19650268554688,"GasValvePosBurnerZ3":117.27626037597656,"GasValvePosBurnerZ4":0,"GasValvePosBurnerZ5":0,"GasValvePosBurnerZ6":0,"GasValvePosBurnerZ7":0,"GasValvePosBurnerZ8":0,"GasValvePosBurnerZ9":0,"PosServoBurner5":0,"GasValvePosBurnerZ10":0,"GasValvePosBurnerZ11":0,"GasValvePosBurnerZ12":0,"GasValvePosBurnerZ13":0,"GasValvePosBurnerZ14":0,"GasValvePosBurnerZ15":0,"WetTempExhaustFanNewDryer":114.59144592285156,"WetTempExhaustFanCompleteDryer":114.59144592285156,"PosServoBurner6":0,"PosServoBurner1":0,"PosServoBurner7":0,"PosServoBurner8":0,"PosServoBurner9":0,"PosServoBurner10":0,"PosServoBurner11":0,"PosServoBurner12":0,"PosServoBurner2":0,"InputTemperatureBurner1":198.69650268554688,"OutputTemperatureBurner1":153.7062225341797,"InputTemperatureBurner2":194.36770629882812,"OutputTemperatureBurner2":151.59532165527344,"InputTemperatureBurner3":187.25680541992188,"OutputTemperatureBurner3":147.1692657470703,"InputTemperatureBurner4":177.25680541992188,"OutputTemperatureBurner4":146.98443603515625,"InputTemperatureBurner5":181.39105224609375,"OutputTemperatureBurner5":135.4474639892578,"InputTemperatureBurner6":165.91439819335938,"OutputTemperatureBurner6":144.6692657470703,"InputTemperatureBurner7":163.70623779296875,"OutputTemperatureBurner7":142.0817108154297,"InputTemperatureBurner8":152.74317932128906,"OutputTemperatureBurner8":146.69259643554688,"PosServoBurner3":0,"InputTemperatureBurner9":153.998046875,"OutputTemperatureBurner9":138.0447540283203,"InputTemperatureBurner10":142.3638153076172,"OutputTemperatureBurner10":129.19259643554688,"InputTemperatureBurner11":133.3268585205078,"OutputTemperatureBurner11":122.08171081542969,"InputTemperatureBurner12":120.26264190673828,"OutputTemperatureBurner12":112.17898559570312,"InputTemperatureBurnerZ3A":170.65176391601562,"OutputTemperatureBurnerZ3A":124.09532928466797,"InputTemperatureBurnerZ4A":188.3949432373047,"OutputTemperatureBurnerZ4A":145.69065856933594,"InputTemperatureBurnerZ5A":199.39688110351562,"OutputTemperatureBurnerZ5A":156.3910369873047,"InputTemperatureBurnerZ6A":217.59727478027344,"OutputTemperatureBurnerZ6A":167.89883422851562,"InputTemperatureBurnerZ7A":221.19650268554688,"OutputTemperatureBurnerZ7A":171.39105224609375,"NewDryerGasFlowDnA":629,"OldDryerGasFlowDnA":257,"OperatorAdjustment":2,"RealEvaporatedWater":625.815185546875,"LiquidSum":259.2120666503906,"FabricationCode":1,"StuccoFlow":360.6951904296875},"_msgid":"8fde218af044e7aa"}
Have you figured out how to separate this message from the rest?
Also, show me how you have configured the SQL node
I still haven't figured out how to separate the messages.
INSERT INTO
[dbo].[banco_secador]
(
ADDACT_EVA,
ADDACT_LIQ,
ADDRCB_TYP,
ADD_N31_1,
ADD_N31_13,
ADD_N31_37,
ADD_N33_133,
AK00_101INS_PT2_Sts_PV_Metric,
AK00_301INS_PT2_Sts_PV_Metric,
AK00_401FAN_M01_Sts_Speed,
AK00_401INS_HT1_Sts_PV_Metric,
AK00_401INS_PT1_Sts_PV_Metric,
AK00_501FAN_M01_Sts_Speed,
AK00_501INS_PT1_Sts_PV_Metric,
AK00_601FAN_M01_Sts_Speed,
AK00_801FAN_M01_Sts_Speed,
AK00_801INS_HT1_Sts_PV_Metric,
CLXDRY_N31_100,
CLXDRY_N31_101,
CLXDRY_N31_102,
CLXDRY_N31_103,
CLXDRY_N31_104,
CLXDRY_N31_105,
CLXDRY_N31_106,
CLXDRY_N31_107,
CLXDRY_N31_108,
CLXDRY_N31_109,
CLXDRY_N31_11,
CLXDRY_N31_110,
CLXDRY_N31_111,
CLXDRY_N31_112,
CLXDRY_N31_113,
CLXDRY_N31_114,
CLXDRY_N31_115,
CLXDRY_N31_116,
CLXDRY_N31_117,
CLXDRY_N31_118,
CLXDRY_N31_119,
CLXDRY_N31_121,
CLXDRY_N31_124,
CLXDRY_N31_127,
CLXDRY_N31_130,
CLXDRY_N31_133,
CLXDRY_N31_136,
CLXDRY_N31_139,
CLXDRY_N31_14,
CLXDRY_N31_142,
CLXDRY_N31_145,
CLXDRY_N31_148,
CLXDRY_N31_151,
CLXDRY_N31_154,
CLXDRY_N31_157,
CLXDRY_N31_165,
CLXDRY_N31_167,
CLXDRY_N31_17,
CLXDRY_N31_2,
CLXDRY_N31_20,
CLXDRY_N31_23,
CLXDRY_N31_26,
CLXDRY_N31_29,
CLXDRY_N31_32,
CLXDRY_N31_35,
CLXDRY_N31_5,
CLXDRY_N31_64,
CLXDRY_N31_65,
CLXDRY_N31_66,
CLXDRY_N31_67,
CLXDRY_N31_68,
CLXDRY_N31_69,
CLXDRY_N31_70,
CLXDRY_N31_71,
CLXDRY_N31_72,
CLXDRY_N31_73,
CLXDRY_N31_74,
CLXDRY_N31_75,
CLXDRY_N31_76,
CLXDRY_N31_77,
CLXDRY_N31_78,
CLXDRY_N31_79,
CLXDRY_N31_8,
CLXDRY_N31_80,
CLXDRY_N31_81,
CLXDRY_N31_82,
CLXDRY_N31_83,
CLXDRY_N31_84,
CLXDRY_N31_85,
CLXDRY_N31_86,
CLXDRY_N31_87,
CLXDRY_N31_90,
CLXDRY_N31_91,
CLXDRY_N31_92,
CLXDRY_N31_93,
CLXDRY_N31_94,
CLXDRY_N31_95,
CLXDRY_N31_96,
CLXDRY_N31_97,
CLXDRY_N31_98,
CLXDRY_N31_99,
CLXDRY_N33_39,
CLXDRY_N33_41,
CLXDRY_N33_64_VAL,
CUTACT_LG1,
CUTACT_THK,
CUTACT_WID,
RealEvaporatedWater,
LastDeckNum,
Deck0AverageMoisture
)
VALUES
(
{{{payload.WetEvaporatedWater}}},--EVA
{{{payload.LiquidSum}}},--CHECAR-LIQ
{{{payload.FabricationCode}}},--ADDRCB_TYP,
{{{payload.ProcessWaterFlow}}},--CHECAR-N31_1
{{{payload.StuccoFlow}}},--CHECAR-N31_13
{{{payload.RealSpeedFormingBelt1}}},--CHECAR-N31_37
{{{payload.ActEvaporation}}},--CHECAR-N33_133
{{{payload.NewDryerInletPressure}}},--AK00_101INS_PT2
{{{payload.OldDryerInletPressure}}},--AK00_301INS_PT2
{{{payload.ExhaustAirFan}}},--AK00_401FAN_M01
{{{payload.AirHumiditySensor401}}},--AK00_401INS_HT1
{{{payload.WetTempSensorExhaustFan}}},--AK00_401INS_PT1
{{{payload.FreshAirFanSpeed}}},--AK00_501FAN_M01#Sts_Speed
{{{payload.FreshAirPressure}}},--AK00_501INS_PT1#Sts_PV_Metric
{{{payload.CombustionAirFanSpeedNB}}},--AK00_601FAN_M01#Sts_Speed
{{{payload.ExhastAirFanNewDryer}}},--AK00_801FAN_M01#Sts_Speed
{{{payload.AirHumiditySensor801}}},--AK00_801INS_HT1#Sts_PV_Metric
{{{payload.InletTemperatureZ8A}}},--CLXDRY_N31_100
{{{payload.OutletTemperatureZ8A}}},--CLXDRY_N31_101
{{{payload.InletTemperatureZ9A}}},--CLXDRY_N31_102
{{{payload.OutletTemperatureZ9A}}},--CLXDRY_N31_103
{{{payload.InletTemperatureZ10A}}},--CLXDRY_N31_104
{{{payload.OutletTemperatureZ10A}}},--CLXDRY_N31_105
{{{payload.InletTemperatureZ11A}}},--CLXDRY_N31_106,
{{{payload.OutletTemperatureZ11A}}},--CLXDRY_N31_107
{{{payload.InletTemperatureZ12A}}},--CLXDRY_N31_108
{{{payload.OutletTemperatureZ12A}}},--CLXDRY_N31_109
{{{payload.PosServoBurner4}}},--CLXDRY_N31_11
{{{payload.InletTemperatureZ13A}}},--CLXDRY_N31_110
{{{payload.OutletTemperatureZ13A}}},--CLXDRY_N31_111
{{{payload.InletTemperatureZ14A}}},--CLXDRY_N31_112
{{{payload.OutletTemperatureZ14A}}},--CLXDRY_N31_113
{{{payload.InletTemperatureZ15A}}},--CLXDRY_N31_114
{{{payload.OutletTemperatureZ15A}}},--CLXDRY_N31_115
{{{payload.InletFreshAirTempExch}}},--CLXDRY_N31_116
{{{payload.OutletFreshAirTempExch}}},--CLXDRY_N31_117
{{{payload.OutletFreshAirTempExch}}},--CLXDRY_N31_118
{{{payload.InletAirTempExhaustExch}}},--CLXDRY_N31_119
{{{payload.GasValvePosBurnerZ3}}},--CLXDRY_N31_121
{{{payload.GasValvePosBurnerZ4}}},--CLXDRY_N31_124
{{{payload.GasValvePosBurnerZ5}}},--CLXDRY_N31_127
{{{payload.GasValvePosBurnerZ6}}},--CLXDRY_N31_130
{{{payload.GasValvePosBurnerZ7}}},--CLXDRY_N31_133
{{{payload.GasValvePosBurnerZ8}}},--CLXDRY_N31_136
{{{payload.GasValvePosBurnerZ9}}},--CLXDRY_N31_139
{{{payload.PosServoBurner5}}},--CLXDRY_N31_14
{{{payload.GasValvePosBurnerZ10}}},--CLXDRY_N31_142
{{{payload.GasValvePosBurnerZ11}}},--CLXDRY_N31_145
{{{payload.GasValvePosBurnerZ12}}},--CLXDRY_N31_148
{{{payload.GasValvePosBurnerZ13}}},--CLXDRY_N31_151
{{{payload.GasValvePosBurnerZ14}}},--CLXDRY_N31_154
{{{payload.GasValvePosBurnerZ15}}},--CLXDRY_N31_157
{{{payload.WetTempExhaustFanNewDryer}}},--CLXDRY_N31_165
{{{payload.WetTempExhaustFanCompleteDryer}}},--CLXDRY_N31_167
{{{payload.PosServoBurner6}}},--CLXDRY_N31_17
{{{payload.PosServoBurner1}}},--CLXDRY_N31_2
{{{payload.PosServoBurner7}}},--CLXDRY_N31_20
{{{payload.PosServoBurner8}}},--CLXDRY_N31_23
{{{payload.PosServoBurner9}}},--CLXDRY_N31_26
{{{payload.PosServoBurner10}}}, --CLXDRY_N31_29
{{{payload.PosServoBurner11}}}, --CLXDRY_N31_32
{{{payload.PosServoBurner12}}}, --CLXDRY_N31_35
{{{payload.PosServoBurner2}}},--CLXDRY_N31_5
{{{payload.InputTemperatureBurner1}}},--CLXDRY_N31_64
{{{payload.OutputTemperatureBurner1}}},--CLXDRY_N31_65
{{{payload.InputTemperatureBurner2}}},--CLXDRY_N31_66
{{{payload.OutputTemperatureBurner2}}},--CLXDRY_N31_67
{{{payload.InputTemperatureBurner3}}},--CLXDRY_N31_68
{{{payload.OutputTemperatureBurner3}}},--CLXDRY_N31_69
{{{payload.InputTemperatureBurner4}}},--CLXDRY_N31_70
{{{payload.OutputTemperatureBurner4}}},--CLXDRY_N31_71
{{{payload.InputTemperatureBurner5}}},--CLXDRY_N31_72,
{{{payload.OutputTemperatureBurner5}}},--CLXDRY_N31_73,
{{{payload.InputTemperatureBurner6}}},--CLXDRY_N31_74,
{{{payload.OutputTemperatureBurner6}}},--CLXDRY_N31_75,
{{{payload.InputTemperatureBurner7}}},--CLXDRY_N31_76
{{{payload.OutputTemperatureBurner7}}},--CLXDRY_N31_77
{{{payload.InputTemperatureBurner8}}},--CLXDRY_N31_78
{{{payload.OutputTemperatureBurner8}}},--CLXDRY_N31_79
{{{payload.PosServoBurner3}}},--CLXDRY_N31_8
{{{payload.InputTemperatureBurner9}}},--CLXDRY_N31_80
{{{payload.OutputTemperatureBurner9}}}, --CLXDRY_N31_81
{{{payload.InputTemperatureBurner10}}},--CLXDRY_N31_82
{{{payload.OutputTemperatureBurner10}}},--CLXDRY_N31_83
{{{payload.InputTemperatureBurner11}}},--CLXDRY_N31_84
{{{payload.OutputTemperatureBurner11}}},--CLXDRY_N31_85
{{{payload.InputTemperatureBurner12}}},--CLXDRY_N31_86
{{{payload.OutputTemperatureBurner12}}},--CLXDRY_N31_87
{{{payload.InputTemperatureBurnerZ3A}}},--CLXDRY_N31_90,
{{{payload.OutputTemperatureBurnerZ3A}}},--CLXDRY_N31_91,
{{{payload.InputTemperatureBurnerZ4A}}},--CLXDRY_N31_92,
{{{payload.OutputTemperatureBurnerZ4A}}},--CLXDRY_N31_93,
{{{payload.InputTemperatureBurnerZ5A}}},--CLXDRY_N31_94,
{{{payload.OutputTemperatureBurnerZ5A}}},--CLXDRY_N31_95,
{{{payload.InputTemperatureBurnerZ6A}}},--CLXDRY_N31_96,
{{{payload.OutputTemperatureBurnerZ6A}}},--CLXDRY_N31_97,
{{{payload.InputTemperatureBurnerZ7A}}},--CLXDRY_N31_98,
{{{payload.OutputTemperatureBurnerZ7A}}},--CLXDRY_N31_99,
{{{payload.NewDryerGasFlowDnA}}},--CLXDRY_N33_39,
{{{payload.OldDryerGasFlowDnA}}},--CLXDRY_N33_41,
{{{payload.OperatorAdjustment}}},--CLXDRY_N33_64 VAL,
8,--CHECK-CUTACT_LG1,
8,--CHECK-CUTACT_THK,
8,--CHECK-CUTACT_WID,
{{{payload.RealEvaporatedWater}}},--REALEVAPORATEDWATER,
8,--CHECK-LastDeckNum,
8--CHECK-Deck0AverageMoisture
)
My flow.
[{"id":"3ce7b2dfd0389010","type":"tab","label":"DnA","disabled":false,"info":"","env":[]},{"id":"aa7323c9152682dd","type":"eth-ip in","z":"3ce7b2dfd0389010","endpoint":"2a374948a57d5337","mode":"all","variable":"","program":"","name":"CLX_DRYER","x":190,"y":280,"wires":[["2265c6046e8c43c9"]]},{"id":"2265c6046e8c43c9","type":"MSSQL","z":"3ce7b2dfd0389010","mssqlCN":"a51e405c.10f64","name":"SQL_DnA","query":"\nINSERT INTO \n\n [dbo].[banco_secador] \n\n ( \n ADDACT_EVA,\n ADDACT_LIQ,\n ADDRCB_TYP,\n ADD_N31_1,\n ADD_N31_13,\n ADD_N31_37,\n ADD_N33_133,\n AK00_101INS_PT2_Sts_PV_Metric,\n AK00_301INS_PT2_Sts_PV_Metric,\n AK00_401FAN_M01_Sts_Speed,\n AK00_401INS_HT1_Sts_PV_Metric,\n AK00_401INS_PT1_Sts_PV_Metric,\n AK00_501FAN_M01_Sts_Speed,\n AK00_501INS_PT1_Sts_PV_Metric,\n AK00_601FAN_M01_Sts_Speed,\n AK00_801FAN_M01_Sts_Speed,\n AK00_801INS_HT1_Sts_PV_Metric,\n CLXDRY_N31_100,\n CLXDRY_N31_101,\n CLXDRY_N31_102,\n CLXDRY_N31_103,\n CLXDRY_N31_104,\n CLXDRY_N31_105,\n CLXDRY_N31_106,\n CLXDRY_N31_107,\n CLXDRY_N31_108,\n CLXDRY_N31_109,\n CLXDRY_N31_11,\n CLXDRY_N31_110,\n CLXDRY_N31_111,\n CLXDRY_N31_112,\n CLXDRY_N31_113,\n CLXDRY_N31_114,\n CLXDRY_N31_115,\n CLXDRY_N31_116,\n CLXDRY_N31_117,\n CLXDRY_N31_118,\n CLXDRY_N31_119,\n CLXDRY_N31_121,\n CLXDRY_N31_124,\n CLXDRY_N31_127,\n CLXDRY_N31_130,\n CLXDRY_N31_133,\n CLXDRY_N31_136,\n CLXDRY_N31_139,\n CLXDRY_N31_14,\n CLXDRY_N31_142,\n CLXDRY_N31_145,\n CLXDRY_N31_148,\n CLXDRY_N31_151,\n CLXDRY_N31_154,\n CLXDRY_N31_157,\n CLXDRY_N31_165,\n CLXDRY_N31_167,\n CLXDRY_N31_17,\n CLXDRY_N31_2,\n CLXDRY_N31_20,\n CLXDRY_N31_23,\n CLXDRY_N31_26,\n CLXDRY_N31_29,\n CLXDRY_N31_32,\n CLXDRY_N31_35,\n CLXDRY_N31_5,\n CLXDRY_N31_64,\n CLXDRY_N31_65,\n CLXDRY_N31_66,\n CLXDRY_N31_67,\n CLXDRY_N31_68,\n CLXDRY_N31_69,\n CLXDRY_N31_70,\n CLXDRY_N31_71,\n CLXDRY_N31_72,\n CLXDRY_N31_73,\n CLXDRY_N31_74,\n CLXDRY_N31_75,\n CLXDRY_N31_76,\n CLXDRY_N31_77,\n CLXDRY_N31_78,\n CLXDRY_N31_79,\n CLXDRY_N31_8,\n CLXDRY_N31_80,\n CLXDRY_N31_81,\n CLXDRY_N31_82,\n CLXDRY_N31_83,\n CLXDRY_N31_84,\n CLXDRY_N31_85,\n CLXDRY_N31_86,\n CLXDRY_N31_87,\n CLXDRY_N31_90,\n CLXDRY_N31_91,\n CLXDRY_N31_92,\n CLXDRY_N31_93,\n CLXDRY_N31_94,\n CLXDRY_N31_95,\n CLXDRY_N31_96,\n CLXDRY_N31_97,\n CLXDRY_N31_98,\n CLXDRY_N31_99,\n CLXDRY_N33_39,\n CLXDRY_N33_41,\n CLXDRY_N33_64_VAL,\n CUTACT_LG1,\n CUTACT_THK,\n CUTACT_WID,\n RealEvaporatedWater,\n LastDeckNum,\n Deck0AverageMoisture\n )\n\n\n\n \nVALUES\n \n (\n\n {{{payload.WetEvaporatedWater}}},--EVA\n {{{payload.LiquidSum}}},--CHECAR-LIQ\n {{{payload.FabricationCode}}},--ADDRCB_TYP,\n {{{payload.ProcessWaterFlow}}},--CHECAR-N31_1\n {{{payload.StuccoFlow}}},--CHECAR-N31_13\n {{{payload.RealSpeedFormingBelt1}}},--CHECAR-N31_37\n {{{payload.ActEvaporation}}},--CHECAR-N33_133\n {{{payload.NewDryerInletPressure}}},--AK00_101INS_PT2\n {{{payload.OldDryerInletPressure}}},--AK00_301INS_PT2\n {{{payload.ExhaustAirFan}}},--AK00_401FAN_M01\n {{{payload.AirHumiditySensor401}}},--AK00_401INS_HT1\n {{{payload.WetTempSensorExhaustFan}}},--AK00_401INS_PT1\n {{{payload.FreshAirFanSpeed}}},--AK00_501FAN_M01#Sts_Speed\n {{{payload.FreshAirPressure}}},--AK00_501INS_PT1#Sts_PV_Metric\n {{{payload.CombustionAirFanSpeedNB}}},--AK00_601FAN_M01#Sts_Speed\n {{{payload.ExhastAirFanNewDryer}}},--AK00_801FAN_M01#Sts_Speed\n {{{payload.AirHumiditySensor801}}},--AK00_801INS_HT1#Sts_PV_Metric\n {{{payload.InletTemperatureZ8A}}},--CLXDRY_N31_100\n {{{payload.OutletTemperatureZ8A}}},--CLXDRY_N31_101\n {{{payload.InletTemperatureZ9A}}},--CLXDRY_N31_102\n {{{payload.OutletTemperatureZ9A}}},--CLXDRY_N31_103\n {{{payload.InletTemperatureZ10A}}},--CLXDRY_N31_104\n {{{payload.OutletTemperatureZ10A}}},--CLXDRY_N31_105\n {{{payload.InletTemperatureZ11A}}},--CLXDRY_N31_106,\n {{{payload.OutletTemperatureZ11A}}},--CLXDRY_N31_107\n {{{payload.InletTemperatureZ12A}}},--CLXDRY_N31_108\n {{{payload.OutletTemperatureZ12A}}},--CLXDRY_N31_109\n {{{payload.PosServoBurner4}}},--CLXDRY_N31_11\n {{{payload.InletTemperatureZ13A}}},--CLXDRY_N31_110\n {{{payload.OutletTemperatureZ13A}}},--CLXDRY_N31_111\n {{{payload.InletTemperatureZ14A}}},--CLXDRY_N31_112\n {{{payload.OutletTemperatureZ14A}}},--CLXDRY_N31_113\n {{{payload.InletTemperatureZ15A}}},--CLXDRY_N31_114\n {{{payload.OutletTemperatureZ15A}}},--CLXDRY_N31_115\n {{{payload.InletFreshAirTempExch}}},--CLXDRY_N31_116\n {{{payload.OutletFreshAirTempExch}}},--CLXDRY_N31_117\n {{{payload.OutletFreshAirTempExch}}},--CLXDRY_N31_118\n {{{payload.InletAirTempExhaustExch}}},--CLXDRY_N31_119\n {{{payload.GasValvePosBurnerZ3}}},--CLXDRY_N31_121\n {{{payload.GasValvePosBurnerZ4}}},--CLXDRY_N31_124\n {{{payload.GasValvePosBurnerZ5}}},--CLXDRY_N31_127\n {{{payload.GasValvePosBurnerZ6}}},--CLXDRY_N31_130\n {{{payload.GasValvePosBurnerZ7}}},--CLXDRY_N31_133\n {{{payload.GasValvePosBurnerZ8}}},--CLXDRY_N31_136\n {{{payload.GasValvePosBurnerZ9}}},--CLXDRY_N31_139\n {{{payload.PosServoBurner5}}},--CLXDRY_N31_14\n {{{payload.GasValvePosBurnerZ10}}},--CLXDRY_N31_142\n {{{payload.GasValvePosBurnerZ11}}},--CLXDRY_N31_145\n {{{payload.GasValvePosBurnerZ12}}},--CLXDRY_N31_148\n {{{payload.GasValvePosBurnerZ13}}},--CLXDRY_N31_151\n {{{payload.GasValvePosBurnerZ14}}},--CLXDRY_N31_154\n {{{payload.GasValvePosBurnerZ15}}},--CLXDRY_N31_157\n {{{payload.WetTempExhaustFanNewDryer}}},--CLXDRY_N31_165\n {{{payload.WetTempExhaustFanCompleteDryer}}},--CLXDRY_N31_167\n {{{payload.PosServoBurner6}}},--CLXDRY_N31_17\n {{{payload.PosServoBurner1}}},--CLXDRY_N31_2\n {{{payload.PosServoBurner7}}},--CLXDRY_N31_20\n {{{payload.PosServoBurner8}}},--CLXDRY_N31_23\n {{{payload.PosServoBurner9}}},--CLXDRY_N31_26\n {{{payload.PosServoBurner10}}}, --CLXDRY_N31_29\n {{{payload.PosServoBurner11}}}, --CLXDRY_N31_32\n {{{payload.PosServoBurner12}}}, --CLXDRY_N31_35\n {{{payload.PosServoBurner2}}},--CLXDRY_N31_5\n {{{payload.InputTemperatureBurner1}}},--CLXDRY_N31_64\n {{{payload.OutputTemperatureBurner1}}},--CLXDRY_N31_65\n {{{payload.InputTemperatureBurner2}}},--CLXDRY_N31_66\n {{{payload.OutputTemperatureBurner2}}},--CLXDRY_N31_67\n {{{payload.InputTemperatureBurner3}}},--CLXDRY_N31_68\n {{{payload.OutputTemperatureBurner3}}},--CLXDRY_N31_69\n {{{payload.InputTemperatureBurner4}}},--CLXDRY_N31_70\n {{{payload.OutputTemperatureBurner4}}},--CLXDRY_N31_71\n {{{payload.InputTemperatureBurner5}}},--CLXDRY_N31_72,\n {{{payload.OutputTemperatureBurner5}}},--CLXDRY_N31_73,\n {{{payload.InputTemperatureBurner6}}},--CLXDRY_N31_74,\n {{{payload.OutputTemperatureBurner6}}},--CLXDRY_N31_75,\n {{{payload.InputTemperatureBurner7}}},--CLXDRY_N31_76\n {{{payload.OutputTemperatureBurner7}}},--CLXDRY_N31_77\n {{{payload.InputTemperatureBurner8}}},--CLXDRY_N31_78\n {{{payload.OutputTemperatureBurner8}}},--CLXDRY_N31_79\n {{{payload.PosServoBurner3}}},--CLXDRY_N31_8\n {{{payload.InputTemperatureBurner9}}},--CLXDRY_N31_80\n {{{payload.OutputTemperatureBurner9}}}, --CLXDRY_N31_81\n {{{payload.InputTemperatureBurner10}}},--CLXDRY_N31_82\n {{{payload.OutputTemperatureBurner10}}},--CLXDRY_N31_83\n {{{payload.InputTemperatureBurner11}}},--CLXDRY_N31_84\n {{{payload.OutputTemperatureBurner11}}},--CLXDRY_N31_85\n {{{payload.InputTemperatureBurner12}}},--CLXDRY_N31_86\n {{{payload.OutputTemperatureBurner12}}},--CLXDRY_N31_87\n {{{payload.InputTemperatureBurnerZ3A}}},--CLXDRY_N31_90,\n {{{payload.OutputTemperatureBurnerZ3A}}},--CLXDRY_N31_91,\n {{{payload.InputTemperatureBurnerZ4A}}},--CLXDRY_N31_92,\n {{{payload.OutputTemperatureBurnerZ4A}}},--CLXDRY_N31_93,\n {{{payload.InputTemperatureBurnerZ5A}}},--CLXDRY_N31_94,\n {{{payload.OutputTemperatureBurnerZ5A}}},--CLXDRY_N31_95,\n {{{payload.InputTemperatureBurnerZ6A}}},--CLXDRY_N31_96,\n {{{payload.OutputTemperatureBurnerZ6A}}},--CLXDRY_N31_97,\n {{{payload.InputTemperatureBurnerZ7A}}},--CLXDRY_N31_98,\n {{{payload.OutputTemperatureBurnerZ7A}}},--CLXDRY_N31_99,\n {{{payload.NewDryerGasFlowDnA}}},--CLXDRY_N33_39,\n {{{payload.OldDryerGasFlowDnA}}},--CLXDRY_N33_41,\n {{{payload.OperatorAdjustment}}},--CLXDRY_N33_64 VAL,\n 8,--CHECAR-CUTACT_LG1,\n 8,--CHECAR-CUTACT_THK,\n 8,--CHECAR-CUTACT_WID,\n {{{payload.RealEvaporatedWater}}},--REALEVAPORATEDWATER,\n 8,--CHECAR-LastDeckNum,\n 8--CHECAR-Deck0AverageMoisture\n\n )\n\n ","outField":"Editor","x":560,"y":280,"wires":[["9edb1d7ae6f58877"]]},{"id":"9edb1d7ae6f58877","type":"debug","z":"3ce7b2dfd0389010","name":"debug 6","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"true","targetType":"full","statusVal":"","statusType":"auto","x":880,"y":280,"wires":[]},{"id":"7997d50fe8fb5f14","type":"debug","z":"3ce7b2dfd0389010","name":"debug 7","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"true","targetType":"full","statusVal":"","statusType":"auto","x":880,"y":180,"wires":[]},{"id":"7b24064fc3a30ddd","type":"catch","z":"3ce7b2dfd0389010","name":"","scope":null,"uncaught":false,"x":560,"y":180,"wires":[["9edb1d7ae6f58877"]]},{"id":"2a374948a57d5337","type":"eth-ip endpoint","z":"3ce7b2dfd0389010","address":"192.168.155.24","slot":"0","cycletime":"60000","name":"CLX_DRYER","vartable":{"":{"ProcessWaterFlow":{"type":"REAL"},"WetEvaporatedWater":{"type":"REAL"},"RealSpeedFormingBelt1":{"type":"REAL"},"ActEvaporation":{"type":"DINT"},"NewDryerInletPressure":{"type":"REAL"},"OldDryerInletPressure":{"type":"REAL"},"ExhaustAirFan":{"type":"REAL"},"AirHumiditySensor401":{"type":"REAL"},"WetTempSensorExhaustFan":{"type":"REAL"},"FreshAirFanSpeed":{"type":"REAL"},"FreshAirPressure":{"type":"REAL"},"CombustionAirFanSpeedNB":{"type":"REAL"},"ExhastAirFanNewDryer":{"type":"REAL"},"AirHumiditySensor801":{"type":"REAL"},"InletTemperatureZ8A":{"type":"REAL"},"OutletTemperatureZ8A":{"type":"REAL"},"InletTemperatureZ9A":{"type":"REAL"},"OutletTemperatureZ9A":{"type":"REAL"},"InletTemperatureZ10A":{"type":"REAL"},"OutletTemperatureZ10A":{"type":"REAL"},"InletTemperatureZ11A":{"type":"REAL"},"OutletTemperatureZ11A":{"type":"REAL"},"InletTemperatureZ12A":{"type":"REAL"},"OutletTemperatureZ12A":{"type":"REAL"},"PosServoBurner4":{"type":"DINT"},"InletTemperatureZ13A":{"type":"REAL"},"OutletTemperatureZ13A":{"type":"REAL"},"InletTemperatureZ14A":{"type":"REAL"},"OutletTemperatureZ14A":{"type":"REAL"},"InletTemperatureZ15A":{"type":"REAL"},"OutletTemperatureZ15A":{"type":"REAL"},"InletFreshAirTempExch":{"type":"REAL"},"OutletFreshAirTempExch":{"type":"REAL"},"InletAirTempExhaustExch":{"type":"REAL"},"NewDryerExhaustAirTemp":{"type":"REAL"},"GasValvePosBurnerZ3":{"type":"REAL"},"GasValvePosBurnerZ4":{"type":"DINT"},"GasValvePosBurnerZ5":{"type":"DINT"},"GasValvePosBurnerZ6":{"type":"DINT"},"GasValvePosBurnerZ7":{"type":"DINT"},"GasValvePosBurnerZ8":{"type":"DINT"},"GasValvePosBurnerZ9":{"type":"DINT"},"PosServoBurner5":{"type":"DINT"},"GasValvePosBurnerZ10":{"type":"DINT"},"GasValvePosBurnerZ11":{"type":"DINT"},"GasValvePosBurnerZ12":{"type":"DINT"},"GasValvePosBurnerZ13":{"type":"DINT"},"GasValvePosBurnerZ14":{"type":"DINT"},"GasValvePosBurnerZ15":{"type":"DINT"},"WetTempExhaustFanNewDryer":{"type":"REAL"},"WetTempExhaustFanCompleteDryer":{"type":"REAL"},"PosServoBurner6":{"type":"DINT"},"PosServoBurner1":{"type":"DINT"},"PosServoBurner7":{"type":"DINT"},"PosServoBurner8":{"type":"DINT"},"PosServoBurner9":{"type":"DINT"},"PosServoBurner10":{"type":"DINT"},"PosServoBurner11":{"type":"DINT"},"PosServoBurner12":{"type":"DINT"},"PosServoBurner2":{"type":"DINT"},"InputTemperatureBurner1":{"type":"REAL"},"OutputTemperatureBurner1":{"type":"REAL"},"InputTemperatureBurner2":{"type":"REAL"},"OutputTemperatureBurner2":{"type":"REAL"},"InputTemperatureBurner3":{"type":"REAL"},"OutputTemperatureBurner3":{"type":"REAL"},"InputTemperatureBurner4":{"type":"REAL"},"OutputTemperatureBurner4":{"type":"REAL"},"InputTemperatureBurner5":{"type":"REAL"},"OutputTemperatureBurner5":{"type":"REAL"},"InputTemperatureBurner6":{"type":"REAL"},"OutputTemperatureBurner6":{"type":"REAL"},"InputTemperatureBurner7":{"type":"REAL"},"OutputTemperatureBurner7":{"type":"REAL"},"InputTemperatureBurner8":{"type":"REAL"},"OutputTemperatureBurner8":{"type":"REAL"},"PosServoBurner3":{"type":"DINT"},"InputTemperatureBurner9":{"type":"REAL"},"OutputTemperatureBurner9":{"type":"REAL"},"InputTemperatureBurner10":{"type":"REAL"},"OutputTemperatureBurner10":{"type":"REAL"},"InputTemperatureBurner11":{"type":"REAL"},"OutputTemperatureBurner11":{"type":"REAL"},"InputTemperatureBurner12":{"type":"REAL"},"OutputTemperatureBurner12":{"type":"REAL"},"InputTemperatureBurnerZ3A":{"type":"REAL"},"OutputTemperatureBurnerZ3A":{"type":"REAL"},"InputTemperatureBurnerZ4A":{"type":"REAL"},"OutputTemperatureBurnerZ4A":{"type":"REAL"},"InputTemperatureBurnerZ5A":{"type":"REAL"},"OutputTemperatureBurnerZ5A":{"type":"REAL"},"InputTemperatureBurnerZ6A":{"type":"REAL"},"OutputTemperatureBurnerZ6A":{"type":"REAL"},"InputTemperatureBurnerZ7A":{"type":"REAL"},"OutputTemperatureBurnerZ7A":{"type":"REAL"},"NewDryerGasFlowDnA":{"type":"REAL"},"OldDryerGasFlowDnA":{"type":"REAL"},"OperatorAdjustment":{"type":"REAL"},"RealEvaporatedWater":{"type":"REAL"},"LiquidSum":{"type":"REAL"},"FabricationCode":{"type":"DINT"},"StuccoFlow":{"type":"REAL"}}}},{"id":"a51e405c.10f64","type":"MSSQL-CN","z":"3ce7b2dfd0389010","name":"Dryer_DnA","server":"KPISERVER\\SSA","encyption":false,"database":"DnA","credentials":{}}]
Hi,
Does anyone have an idea of how to create a flow and insert the values of the configured tags in the CLX_DRYER node inside a database without generating connection failures?
As I said before...
example...
or a function node that checks the variables are present in the payload e.g.:
Function code (untested - since I dont have access to your device or Database)
const expectedProps = [
"WetEvaporatedWater",
"LiquidSum",
"FabricationCode",
"ProcessWaterFlow",
"StuccoFlow",
"RealSpeedFormingBelt1",
"ActEvaporation",
"NewDryerInletPressure",
"OldDryerInletPressure",
"ExhaustAirFan",
"AirHumiditySensor401",
"WetTempSensorExhaustFan",
"FreshAirFanSpeed",
"FreshAirPressure",
"CombustionAirFanSpeedNB",
"ExhastAirFanNewDryer",
"AirHumiditySensor801",
"InletTemperatureZ8A",
"OutletTemperatureZ8A",
"InletTemperatureZ9A",
"OutletTemperatureZ9A",
"InletTemperatureZ10A",
"OutletTemperatureZ10A",
"InletTemperatureZ11A",
"OutletTemperatureZ11A",
"InletTemperatureZ12A",
"OutletTemperatureZ12A",
"PosServoBurner4",
"InletTemperatureZ13A",
"OutletTemperatureZ13A",
"InletTemperatureZ14A",
"OutletTemperatureZ14A",
"InletTemperatureZ15A",
"OutletTemperatureZ15A",
"InletFreshAirTempExch",
"OutletFreshAirTempExch",
"OutletFreshAirTempExch",
"InletAirTempExhaustExch",
"GasValvePosBurnerZ3",
"GasValvePosBurnerZ4",
"GasValvePosBurnerZ5",
"GasValvePosBurnerZ6",
"GasValvePosBurnerZ7",
"GasValvePosBurnerZ8",
"GasValvePosBurnerZ9",
"PosServoBurner5",
"GasValvePosBurnerZ10",
"GasValvePosBurnerZ11",
"GasValvePosBurnerZ12",
"GasValvePosBurnerZ13",
"GasValvePosBurnerZ14",
"GasValvePosBurnerZ15",
"WetTempExhaustFanNewDryer",
"WetTempExhaustFanCompleteDryer",
"PosServoBurner6",
"PosServoBurner1",
"PosServoBurner7",
"PosServoBurner8",
"PosServoBurner9",
"PosServoBurner10",
"PosServoBurner11",
"PosServoBurner12",
"PosServoBurner2",
"InputTemperatureBurner1",
"OutputTemperatureBurner1",
"InputTemperatureBurner2",
"OutputTemperatureBurner2",
"InputTemperatureBurner3",
"OutputTemperatureBurner3",
"InputTemperatureBurner4",
"OutputTemperatureBurner4",
"InputTemperatureBurner5",
"OutputTemperatureBurner5",
"InputTemperatureBurner6",
"OutputTemperatureBurner6",
"InputTemperatureBurner7",
"OutputTemperatureBurner7",
"InputTemperatureBurner8",
"OutputTemperatureBurner8",
"PosServoBurner3",
"InputTemperatureBurner9",
"OutputTemperatureBurner9",
"InputTemperatureBurner10",
"OutputTemperatureBurner10",
"InputTemperatureBurner11",
"OutputTemperatureBurner11",
"InputTemperatureBurner12",
"OutputTemperatureBurner12",
"InputTemperatureBurnerZ3A",
"OutputTemperatureBurnerZ3A",
"InputTemperatureBurnerZ4A",
"OutputTemperatureBurnerZ4A",
"InputTemperatureBurnerZ5A",
"OutputTemperatureBurnerZ5A",
"InputTemperatureBurnerZ6A",
"OutputTemperatureBurnerZ6A",
"InputTemperatureBurnerZ7A",
"OutputTemperatureBurnerZ7A",
"NewDryerGasFlowDnA",
"OldDryerGasFlowDnA",
"OperatorAdjustment",
"RealEvaporatedWater",
]
for (let index = 0; index < expectedProps.length; index++) {
const element = expectedProps[index];
if (msg.payload[element] === undefined) {
return null;
}
}
return msg;
you are swamping the MSSQL connection with tonnes of bad queries in quick sucession. Once you filter out all the unwanted messages and only permit messages with the correct properties, this will be fixed!
This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.
Copyright OpenJS Foundation and Node-RED contributors. All rights reserved. The OpenJS Foundation has registered trademarks and uses trademarks. For a list of trademarks of the OpenJS Foundation, please see our Trademark Policy and Trademark List. Trademarks and logos not indicated on the list of OpenJS Foundation trademarks are trademarks™ or registered® trademarks of their respective holders. Use of them does not imply any affiliation with or endorsement by them.
The OpenJS Foundation | Terms of Use | Privacy Policy | OpenJS Foundation Bylaws | Trademark Policy | Trademark List | Cookie Policy