Streamanalytics 'InputDeserializerError.InvalidData' error

manjith 101 Reputation points
2021-05-21T12:21:12.23+00:00

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 Hub
Azure IoT Hub
An Azure service that enables bidirectional communication between internet of things (IoT) devices and applications.
1,124 questions
Azure Stream Analytics
Azure Stream Analytics
An Azure real-time analytics service designed for mission-critical workloads.
331 questions
0 comments
Accepted answer
  1. manjith 101 Reputation points
    2021-05-21T18:02:33.977+00:00

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

    Corrected string :

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

    Thanks.

    1 person found this answer helpful.

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest