Very well done. Good pace, well spoken, extra detail in the right places. I did quite a bit of looking before finding this. Nothing else was even close. Huge thanks!!
@The Soluton Architect can you please let me know what kind of visual studio are you using ? And please help me on how to send data to azure iot using c# code and how to also pull data back using Unity C# Thank you so much
Hi, Thanks for a great video. I have duplicated it step by step and I'm having a problem with the implementation though. Basically in the outputstream process, I'm getting the following error. "Message": "Cannot convert from property 'EventProcessedUtcTime' of type 'System.Double' to column 'EventProcessedUtcTime' of type 'System.DateTime'. Why is Azure seeing the field as a "Double"? Thanks, Neil.
Neil Wrightson Hi, The datetime stamp in the class / model, needs to march what you store on Azure. I am on the road, so difficult today to go check the error. Check all your date fields and it is also important to put the columns in the same order that I have in my demo. Let me know if you still stuck.
@@TheSolutionArchitect Thanks for getting back to me so quickly. Does the field order coming in need to be the same as the field order in the table? The data coming from the device is not always coming in in the same order.
@@neilwrightson5660 Below is a condensed snapshot of the data. Some messages have temperature, others have humidity, others have temperature and humidity and some have nothing?? In your above reply, you refer to checking the ordering of the fields. As you can see below, the ordering changes because some fields just don't come through from the MXCHIP. P.S. I just purchased the MXCHIP and did the automatic firmware update to the latest online revision. In the Analytics job, If I put an "*" in the select statement as per your video, the job fails on the error in my original comment. No data is received into the table. If I put the below into the job select statement, I at least get the temperature and humidity fields updated. cast(temperature AS FLOAT) as temperature, cast(humidity as FLOAT) as Humidity Thanks for any help, Neil. {"messageId":500,"humidity":49.599998474121094,"EventProcessedUtcTime":"2020-01-13T01:42:26.9899019Z" {"messageId":501,"humidity":49.5,"EventProcessedUtcTime":"2020-01-13T01:42:26.9899019Z" {"messageId":502,"temperature":27.200000762939453,"EventProcessedUtcTime":"2020-01-13T01:42:26.9899019Z" {"messageId":503,"temperature":27.100000381469727,"EventProcessedUtcTime":"2020-01-13T01:42:26.9899019Z" {"messageId":504,"temperature":27.200000762939453,"EventProcessedUtcTime":"2020-01-13T01:42:26.9899019Z" {"messageId":505,"temperature":27.100000381469727,"humidity":49.400001525878906,"EventProcessedUtcTime" {"messageId":506,"humidity":49.5,"EventProcessedUtcTime":"2020-01-13T01:42:26.9899019Z","PartitionId" {"messageId":507,"EventProcessedUtcTime":"2020-01-13T01:42:26.9899019Z","PartitionId":0,"EventEnqueuedUtcTime" {"messageId":508,"temperature":27.200000762939453,"humidity":49.599998474121094,"EventProcessedUtcTime":"2020-01-13T01:42:26.9899019Z" {"messageId":509,"EventProcessedUtcTime":"2020-01-13T01:42:26.9899019Z" {"messageId":510,"temperature":27.299999237060547,"EventProcessedUtcTime":"2020-01-13T01:42:26.9899019Z" {"messageId":511,"temperature":27.200000762939453,"EventProcessedUtcTime":"2020-01-13T01:42:26.9899019Z"
I am getting this error. ource 'inputtodatabase' had 1 occurrences of kind 'InputDeserializerError.InvalidData' between processing times '2021-01-05T04:14:20.0579848Z' and '2021-01-05T04:14:20.0736154Z'. Json input stream should either be an array of objects or line separated objects. Found token type: String Not sure what is wrong with the python json dump. Could you share your phyton code?
Hey I have a Problem with generating the output to sql database, the input events is coming in, but no outputs are generated (no data in database) anyone ideas? --> For anyone that has the same Probleme, check in your Firewall Settings of the SQL-Server for "Allow Azure services and resources to access this server" switch it to ON/YES this fixed my problem.
Very well done.
Good pace, well spoken, extra detail in the right places. I did quite a bit of looking before finding this. Nothing else was even close.
Huge thanks!!
Anytime!
Great job! This tutorial is easy comprehensible even for an complete novice.
Hope you can share more videos and solutions :)
@The Soluton Architect can you please let me know what kind of visual studio are you using ?
And please help me on how to send data to azure iot using c# code and how to also pull data back using Unity C# Thank you so much
Great video thanks! I am stuck creating the output for the stream analytics job. Did you post the SQL query somewhere?
BR Sune
ooops - sorry - just found it, expanding your text. Sorry to bother....
Only saw your message now. Glad you found it.
Hi,
Thanks for a great video.
I have duplicated it step by step and I'm having a problem with the implementation though.
Basically in the outputstream process, I'm getting the following error.
"Message": "Cannot convert from property 'EventProcessedUtcTime' of type 'System.Double' to column 'EventProcessedUtcTime' of type 'System.DateTime'.
Why is Azure seeing the field as a "Double"?
Thanks,
Neil.
Neil Wrightson Hi, The datetime stamp in the class / model, needs to march what you store on Azure. I am on the road, so difficult today to go check the error. Check all your date fields and it is also important to put the columns in the same order that I have in my demo. Let me know if you still stuck.
@@TheSolutionArchitect
Thanks for getting back to me so quickly.
Does the field order coming in need to be the same as the field order in the table?
The data coming from the device is not always coming in in the same order.
@@neilwrightson5660
Below is a condensed snapshot of the data. Some messages have temperature, others have humidity, others have temperature and humidity and some have nothing??
In your above reply, you refer to checking the ordering of the fields. As you can see below, the ordering changes because some fields just don't come through from the MXCHIP.
P.S. I just purchased the MXCHIP and did the automatic firmware update to the latest online revision.
In the Analytics job, If I put an "*" in the select statement as per your video, the job fails on the error in my original comment. No data is received into the table.
If I put the below into the job select statement, I at least get the temperature and humidity fields updated.
cast(temperature AS FLOAT) as temperature,
cast(humidity as FLOAT) as Humidity
Thanks for any help,
Neil.
{"messageId":500,"humidity":49.599998474121094,"EventProcessedUtcTime":"2020-01-13T01:42:26.9899019Z"
{"messageId":501,"humidity":49.5,"EventProcessedUtcTime":"2020-01-13T01:42:26.9899019Z"
{"messageId":502,"temperature":27.200000762939453,"EventProcessedUtcTime":"2020-01-13T01:42:26.9899019Z"
{"messageId":503,"temperature":27.100000381469727,"EventProcessedUtcTime":"2020-01-13T01:42:26.9899019Z"
{"messageId":504,"temperature":27.200000762939453,"EventProcessedUtcTime":"2020-01-13T01:42:26.9899019Z"
{"messageId":505,"temperature":27.100000381469727,"humidity":49.400001525878906,"EventProcessedUtcTime"
{"messageId":506,"humidity":49.5,"EventProcessedUtcTime":"2020-01-13T01:42:26.9899019Z","PartitionId"
{"messageId":507,"EventProcessedUtcTime":"2020-01-13T01:42:26.9899019Z","PartitionId":0,"EventEnqueuedUtcTime"
{"messageId":508,"temperature":27.200000762939453,"humidity":49.599998474121094,"EventProcessedUtcTime":"2020-01-13T01:42:26.9899019Z"
{"messageId":509,"EventProcessedUtcTime":"2020-01-13T01:42:26.9899019Z"
{"messageId":510,"temperature":27.299999237060547,"EventProcessedUtcTime":"2020-01-13T01:42:26.9899019Z"
{"messageId":511,"temperature":27.200000762939453,"EventProcessedUtcTime":"2020-01-13T01:42:26.9899019Z"
I am getting this error. ource 'inputtodatabase' had 1 occurrences of kind 'InputDeserializerError.InvalidData' between processing times '2021-01-05T04:14:20.0579848Z' and '2021-01-05T04:14:20.0736154Z'. Json input stream should either be an array of objects or line separated objects. Found token type: String
Not sure what is wrong with the python json dump. Could you share your phyton code?
Is there an alternative to STSW-LINK009 for MacOS?
Is it worth learning azure iot yet is it to soon for iot
Hey I have a Problem with generating the output to sql database, the input events is coming in, but no outputs are generated (no data in database) anyone ideas?
--> For anyone that has the same Probleme, check in your Firewall Settings of the SQL-Server for "Allow Azure services and resources to access this server" switch it to ON/YES this fixed my problem.