How to check all failed message data in Stream Analytics log monitoring? Currently I can see only 5 example events in logs but I want to see all.

Kumar, Parvendra 21 Reputation points
2021-09-01T10:10:33.043+00:00

I am using a Stream analytics job to receive message from event hub, parse it and then insert it to Synapse table. Sometimes, there is some data conversion issue due to incorrect input data. I want to log all these input message which have some data conversion issue. I configured log analytics workspace to achieve this. But it is only showing the max 5 example events for failure messages. How I can see the rest of input data having errors?

Azure Monitor
Azure Monitor
An Azure service that is used to collect, analyze, and act on telemetry data from Azure and on-premises environments.
2,925 questions
Azure Stream Analytics
Azure Stream Analytics
An Azure real-time analytics service designed for mission-critical workloads.
339 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. PRADEEPCHEEKATLA-MSFT 82,356 Reputation points Microsoft Employee
    2021-09-03T07:13:51.753+00:00

    Hello @Kumar, Parvendra ,

    Thanks for the question and using MS Q&A platform.

    Stream Analytics provides pre-defined queries that allows you to easily search for the logs that you are interested in. You can select any pre-defined queries on the left pane and then select Run. You will see the results of the query in the bottom pane.

    129031-image.png

    For more details, refer to Send diagnostics to Azure Monitor logs.

    Hope this helps. Do let us know if you any further queries.

    ---------------------------------------------------------------------------

    Please "Accept the answer" if the information helped you. This will help us and others in the community as well.