locked
Getting error: "Stream Analytics job status changed for last user action [Start job 'job name']." RRS feed

  • Question

  • questions from @RandyGeorge17 via Twitter:

    Having problem starting an Azure Stream Analytics. The Fail message simply indicates "Stream Analytics job status changed for last user action [Start job 'job name']." so I'm having trouble determining the problem.

    Please assist.

    Thanks,

    @AzureSupport

    Monday, April 4, 2016 10:03 PM

Answers

  • I found how to get more information. The old portal https://manage.windowsazure.com indicates that there was a problem in the Output. There was a typo in the Query Columns that did not match the Azure SQL table columns of the Output. This was immediately clear with the message in the old portal.

    The old portal seems to have better test and error messages for Stream Analytics jobs.

    Tuesday, April 5, 2016 8:12 PM

All replies

  • More details on the GPSLoad Stream Analytics Job to connect the IoT Hub data messages to an Azure SQL Server sink.

    The Query is

    SELECT
        deviceId,windSpeed,latitude,longitude
    INTO
        OutputGps
    FROM
        InputGPS

    Here is the error detail:

    Thanks

    Monday, April 4, 2016 10:29 PM
  • Does the Azure SQL DB need to be located in the same region as the IoT Hub?

    Monday, April 4, 2016 10:41 PM
  • I found how to get more information. The old portal https://manage.windowsazure.com indicates that there was a problem in the Output. There was a typo in the Query Columns that did not match the Azure SQL table columns of the Output. This was immediately clear with the message in the old portal.

    The old portal seems to have better test and error messages for Stream Analytics jobs.

    Tuesday, April 5, 2016 8:12 PM