question

manjith-3389 avatar image
0 Votes"
manjith-3389 asked HimanshuSinha-MSFT commented

Streamanalytics 'InputDeserializerError.InvalidData' error

Hello,

I am trying to store my telemetry data to SQL database through stream analytics, I am getting a below mentioned error while trying to run a streaming job.
"Source 'edgeinputstream' had 1 occurrences of kind 'InputDeserializerError.InvalidData' between processing times '2021-05-21T12:08:04.7795574Z' and '2021-05-21T12:08:04.7795574Z'. Could not deserialize the input event(s) from resource 'Partition: [0], Offset: [17181485296], SequenceNumber: [3925], DeviceId: [firstedge]' as Json. Some possible reasons: 1) Malformed events 2) Input source configured with incorrect serialization format."


I have attached the screenshot of the code and message received at the IoT Hub 98656-code.png98635-azurecli.png




azure-iot-hubazure-stream-analytics
code.png (103.4 KiB)
azurecli.png (43.7 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

manjith-3389 avatar image
1 Vote"
manjith-3389 answered HimanshuSinha-MSFT commented

Rectified the error.
Mistake was in the defined JSON String.

Corrected string :

MSG_TXT = '{ {"temperature": "{temperature}","time": "{time}","date":"{date}"}}'

Thanks.

· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hello @manjith-3389 ,
It was great to know that you were able to get to a resolution . We expect you to keep using this forum and also motivate others to do that same . You can always help other community members by answering to their queries .
Thanks
Himanshu

0 Votes 0 ·