locked
troubleshooting a SA job RRS feed

  • Question

  • I have a Raspberry Pi with Sensehat hooked up to an Iot Hub, the SA service and output to a Azure db.

    Initially I was sending a limited set of Sensehat outputs, and they were making it into the db.

    Then I added all the remaining outputs from the senshat and in order to capture this I created a new table in the same db, and I modified the output stream to show a new table name.

    With Device Explorer I can see the json serialized data stream and it appears correct:

    9/6/2017 3:05:21 PM> Device: [rpi2], Data:[{"TimeStamp":"2017-09-06T19:05:22.3985083Z","Humidity":52.200490762124716,"Pressure":996.50927734375,"Temperature":33.159090909090907,"Location":"Athens","Gyro":"x: 0.0101, y: -0.0069, z: 0.0002","Accel":"x: 0.0229, y: 0.0407, z: 0.9770","Magnetic":"x: 8.8566, y: 53.2383, z: 26.7632","Pose":"x: -2.7330, y: 0.1600, z: -2.3697"}]

    My query is quite simple:

    SELECT
        TimeStamp, Temperature, Humidity, Pressure, Location, Accel, Gyro, Magnetic, Pose
    INTO
        [waveout]
    FROM
        [wavein]

    Yet nothing gets written to the table.

    How can I troubleshoot this further?

    Wednesday, September 6, 2017 8:51 PM

Answers

  • Device Explorer shows data pre Iot Hub!

    As I had mentioned I had a working solution before I decided to add extra data points to the data flow ending up in the database. To make this work I had edited the output side of the Stream Analytics job.

    I had looked at input but did not make any changes.  Here comes the the strange behavior that tripped me up.....

    To get it to work I changed the Import option to Use IoT hub from current subscription from Provide IoT hub settings manually, that was all that it took, but here is where it gets crazy..... next time you look it will have reverted to the manual setting.


    • Marked as answer by wavemaster00 Thursday, September 7, 2017 6:39 PM
    Thursday, September 7, 2017 6:39 PM

All replies

  • Some ideas you can try:

    1) Enable diagnostics log and check if there is any error returned from SQL DB

    2) Try output to blob storage, see if you get output and check the output schema.


    This posting is provided "AS IS" with no warranties, and confers no rights.

    Thursday, September 7, 2017 12:10 AM
  • What does data in Device Explorer mean?

    Is that into SA or exit IoT Hub?

     
    • Marked as answer by wavemaster00 Thursday, September 7, 2017 6:39 PM
    • Unmarked as answer by wavemaster00 Thursday, September 7, 2017 6:39 PM
    Thursday, September 7, 2017 2:20 AM
  • Device Explorer connect to IoT Hub endpoint and read messages sent by devices like a Stream Analytics job. The data in your example is the message payload, I assume the same data is ready by your Stream Analytics job. 


    This posting is provided "AS IS" with no warranties, and confers no rights.

    Thursday, September 7, 2017 6:20 PM
  • Device Explorer shows data pre Iot Hub!

    As I had mentioned I had a working solution before I decided to add extra data points to the data flow ending up in the database. To make this work I had edited the output side of the Stream Analytics job.

    I had looked at input but did not make any changes.  Here comes the the strange behavior that tripped me up.....

    To get it to work I changed the Import option to Use IoT hub from current subscription from Provide IoT hub settings manually, that was all that it took, but here is where it gets crazy..... next time you look it will have reverted to the manual setting.


    • Marked as answer by wavemaster00 Thursday, September 7, 2017 6:39 PM
    Thursday, September 7, 2017 6:39 PM