locked
Stream Analytics not starting RRS feed

  • Question

  • Here is the sample data set that i downloaded and i was able to test the query. 

    When i test the query without using "Test button" it's returning the expected output in two columns. But when i start the streaming analytics job with the input and output i get 

    Stream Analytics job has validation errors: Query compilation error: Syntax errors: Incorrect syntax near syslog. Location: line '1', column '55'..

    Query 

    SELECT properties.hostname, properties.EventTime FROM syslog INTO output

    Query is successful in Job topoloy qury> test.

    Sample data that was collected during input from event hub

    {"time":"2019-07-09T17:57:20.0000000Z", "resourceId":"/subscriptions/<hidden?/resourceGroups/<hidden>/providers/Microsoft.Compute/virtualMachines/syslog-host", "properties":{ "ident":"2019-07-09", "Ignore":"syslog", "Facility":"local2", "Severity":"info", "EventTime":"2019-07-09T17:57:20.0000000", "SendingHost":"localhost", "Msg":"Test Message", "hostname":"test-host01", "FluentdIngestTimestamp":"2019-07-09T17:57:20.0000000Z"}, "category":"local2", "level":"info", "operationName":"LinuxSyslogEvent", "EventProcessedUtcTime":"2019-07-09T20:34:25.7595376Z", "PartitionId":3, "EventEnqueuedUtcTime":"2019-07-09T20:34:18.5790000Z" },


    Wednesday, July 10, 2019 3:52 PM

All replies

  • Hi R2Raj,

    I would suggest you to check the validation error “Stream Analytics job has validation errors: Query compilation error: Syntax errors: Incorrect syntax near syslog. Location: line '1', column '55'”.

    OR

    You can debug using activity logs: Activity logs are on by default and give high-level insights into operations performed by your Stream Analytics job. Information present in activity logs may help find the root cause of the issues impacting your job.

    OR

    If the error message in the Activity logs isn’t helpful in identifying root cause, enable diagnostic logs and use Azure Monitor logs.

    For more details, refer “Troubleshooting Azure Stream Analytics by using diagnostics logs”.

    Hope this helps.

    Thursday, July 11, 2019 5:34 AM