Azure Stream Analytics
An Azure real-time analytics service designed for mission-critical workloads.
334 questions
ASA degraded flag and no output when using JSON_VALUE in query
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(176, 11%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EN%3C/text%3E%3C/svg%3E)
NB
1
Reputation point
I get a degraded flag as soon as I use a JSON_VALUE command in my ASA query. The query works fine when I test it and there are no other errors reported when I run the job. Just no output and degraded message.
{count} votes
-
PRADEEPCHEEKATLA-MSFT 79,536 Reputation points Microsoft Employee2020-12-23T11:58:44.107+00:00 Hello @NB ,
Welcome to the Microsoft Q&A platform.
In order to repro this issue, could you please provide the exact steps which you are trying, along with the screenshot of the error message?
-
PRADEEPCHEEKATLA-MSFT 79,536 Reputation points Microsoft Employee
2020-12-24T04:48:54.643+00:00 Hello @NB ,
Could you review the activity log or diagnostic logs to find the reason for the above message?
-
PRADEEPCHEEKATLA-MSFT 79,536 Reputation points Microsoft Employee
2020-12-28T06:19:35.11+00:00 Hello @NB ,
Just checking in if you have had a chance to see the previous response. We need the following information to understand/investigate this issue further.
Sign in to comment