I have a stream analytics job with an MQTT JSON input and a postgreSQL output.
I noticed that if a certain JSON parameter that is part of the message no output rows are generated. I couldn't find any related info in the logs. Restarting the stream analytics job fixes the issue until the next message with this parameter.
The only difference I see between this parameter and the previous ones is that it is an INT while the previous ones are VARCHAR and FLOAT.
This is the JSON (the problematic parameter is "tsen1":
{\"ppb\":117.35,\"pid\":155.40,\"temp\":22.50,\"humid\":29.10,\"pres\":1002.00,\"wspd\":0.00,\"wdir\":359.60,\"sflag\":0,\"tflag\":0,\"pstat\":1,\"estat\":0,\"batt\":13.31,\"chrg\":0.00,\"run\":113.86,\"tsen1\":2440,\"heat1\":15,\"tset1\":2492,\"sd\":1000,\"tcrh\":0,\"r232\":0,\"csq\":-92,\"snr\":5,\"brdv\":5,\"fwv\":594,\"misc\":166,\"cell\":115000,\"samp\":2,\"trig\":10,\"tstatic\":250,\"btime\":30,\"tl1\":250,\"tt1\":45,\"ds1\":0,\"df1\":360,\"ws1\":0,\"ev1\":129,\"ev2\":0,\"ev3\":0,\"ev4\":0}}"
}
}