Azure Monitor
An Azure service that is used to collect, analyze, and act on telemetry data from Azure and on-premises environments.
3,214 questions
Error when Log Analytics queries Azure Resource Log with join expression
YoungseoLee222
30
Reputation points
Hi. I found this issue while doing Azure Resource Graph query in Log Analytics.
If the join expression is included, the above error message appears, except for that, it works well.
In Resource Graph Explorer, it works fine. What I changed in the Log Analytics query is arg("") before the name of Resource Log table.
If I need to modify a query statement, can you give me an idea on how to modify it?
Or if it's a problem I can't handle, please review the error.
{count} vote
-
![](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(249.60000000000002, 39%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESM%3C/text%3E%3C/svg%3E)
SwathiDhanwada-MSFT 18,756 Reputation points2023-11-14T05:42:16.2066667+00:00 YoungseoLee222 Thank you for your question. I need to check on this with product team. Can you please email (AzCommunity@microsoft.com) with Subject as "Attn:Swathi" with below information ?
- Link of this thread for context
- Subscription id
- Issue start time
- Log analytics resource id
- Capture browser trace while executing the error by following this document.
-
YoungseoLee222 30 Reputation points
2023-11-14T07:36:09.52+00:00 I emailed with the information what you asked.
-
SwathiDhanwada-MSFT 18,756 Reputation points
2023-11-14T07:49:37.29+00:00 YoungseoLee222 Thank you. I will check on it and get back to you.
-
SwathiDhanwada-MSFT 18,756 Reputation points
2023-11-15T11:11:25.24+00:00 YoungseoLee222 I am still working with PG team to find the cause of the issue. I will respond once we have a resolution. Thanks for your patience.
-
Clive Watson 6,351 Reputation points MVP2023-11-15T19:11:43.3866667+00:00 -
YoungseoLee222 30 Reputation points
2023-11-16T00:25:08.4866667+00:00 When I put hint.remote=local in line 3, the result does not match the Resource Graph Explorer result.
Query results come out if the strategy is local, otherwise the same error message is displayed..
-
SwathiDhanwada-MSFT 18,756 Reputation points
2023-11-16T05:20:50.4266667+00:00 YoungseoLee222 Thanks for reporting this. It looks like this request is going through the Adx Streaming flow for ARG. During that process, even though you are not using hint.remote in your query but because this is the Adx flow, the query you sent is transformed by another Kusto cluster before it is sent to ARG. This Kusto cluster is the one that has added the hint.remote for your query which is causing the error.
Product team is working on fixing this issue. As of now, we don't have ETA for the same.
We apologize for the inconvenience caused.
-
SwathiDhanwada-MSFT 18,756 Reputation points
2023-11-20T08:07:16.5066667+00:00 YoungseoLee222 Hope you had chance to look into my previous comment ? Let me know if you have further questions.
-
YoungseoLee222 30 Reputation points
2023-11-21T00:13:18.0766667+00:00 I guess there is nothing I can hadle this problem.. Do I wait until fixing the issue?
-
YoungseoLee222 30 Reputation points
2023-11-21T00:14:21.39+00:00 I guess there is nothing I can hadle this problem. Do I wait until fixing the issue?
-
SwathiDhanwada-MSFT 18,756 Reputation points
2023-11-21T03:49:42.5733333+00:00 YoungseoLee222 Apologies for the inconvenience caused. Product team is working on it. I will share an update once I have some information about the ETA or the workaround for it.
Sign in to comment
Sign in to answer