error for properties_s when using iot hub logs

Anonymous

I am having trouble with my IoT hub and I am trying to use the logs to see if the problem is on the Azure side. I have looked at Logs under monitoring and then I run the auto-generated script for looking at throttling errors which has an error in it, (it don't recognize the variable properties_s), the script is seen on the attached picture.

Why doesn't the auto generated code working, is the variable supposed to be exchanged with something else?

Kind regards

Henrik

enter image description here

User's image

Sander van de Velde | MVP 32,726 Reputation points MVP

2023-11-14T08:36:22.7066667+00:00

Hello Henrik,

welcome to this moderated Azure community forum.

Better questions with more information lead to better answers from our community members.

Please provide information about the steps you have taken, the guide you follow, and the errors you receive.
Anonymous

2023-11-14T08:46:04.56+00:00

Thank you for the comment, I have tried to clarify what the problem is. The error should be seen in the attached picture.
Sander van de Velde | MVP 32,726 Reputation points MVP

2023-11-14T09:35:00.39+00:00

Hello Henrik,

yes, that is the error of your KQL query.

I try to relate this to the problem you have with the IoT Hub. What behavior or errors are seen there?

How do you navigate to this KQL query?

For experts, it's important to learn about the context. This gives a direction to answers.
Anonymous

2023-11-14T09:41:57.8333333+00:00

Right now I am manly interested in knowing what the properties_s variable is used for or should be substituted with. The main issue is that devices sporadically loses connection to the IoT Hub but it is a bit suspicious that none of the queries I have tried give any result at all. For example this query that is generated by clicking here (see picture 1) can't run because properties_s is not defined. And it really should give some kind of answer.
Sander van de Velde | MVP 32,726 Reputation points MVP

2023-11-15T08:33:29.6266667+00:00

Hello @Anonymous ,

can you share the URL or a guide how to navigate to this page so we can try it for ourselves?
Anonymous

2023-11-15T08:37:44.0366667+00:00

Sure, just follow the instructions in the link under the header analyzing logs.

https://learn.microsoft.com/en-us/azure/iot-hub/monitor-iot-hub

Accepted answer

Sander van de Velde | MVP 32,726 Reputation points MVP

2023-11-15T19:47:09.64+00:00

Hello @Henrik Paldan,

welcome to this moderated Azure community forum.

I get the same error:

I do not see how I can query that table itself to figure out the actual name of the column having a sdkVersion, deviceID, etc.

I recommend submitting a support ticket. As an alternative you could give some comments on the documentation page so the author will check it out.

If the response helped, do "Accept Answer". If it doesn't work, please let us know the progress. All community members with similar issues will benefit by doing so. Your contribution is highly appreciated.
Please sign in to rate this answer.
Anonymous

2023-11-16T07:44:05.49+00:00

Thanks, this is the community support right? So the only other option is to get paid support from Azure?

Sander van de Velde | MVP 32,726 Reputation points MVP

2023-11-16T10:17:49.5533333+00:00

This forum offers community support. Community members answer questions here to there best knowledge. Both people from Microsoft and community moderators keep an eye on the content. The technical support I sent is related to your Azure Subscription.

Giving feedback in the documentation is not charged too.

Anonymous

2023-11-16T10:21:14.31+00:00

All right, great to know. Thanks!

LeelaRajeshSayana-MSFT 15,396 Reputation points Microsoft Employee

2023-11-16T20:00:42.0466667+00:00

Thank you @Sander van de Velde | MVP for validating this and adding your inputs on this.

@Anonymous If you do not have access to a support plan, could you please send an email to azcommunity@microsoft.com with the below details, so that we can work closely on this matter.

Thread URL: Link to this thread.

Azure Subscription ID:

Email Subject : Attn Leela

Anonymous

2023-11-17T11:40:48.52+00:00

Thank you for your concern but I currently don't have the time to continue with this issue. I hope that it gets solved in the near future!

Sander van de Velde | MVP 32,726 Reputation points MVP

2023-11-27T16:39:40.36+00:00

Hello @Henrik Paldan,

Today I put some time into figuring out why we get this message again.

This time, I checked the Diagnostics settings too:

This makes the table accessible:

Although that column properties_s name gives some warning, I got an (empty) result:

Please check again the Diagnostics settings.

Anonymous

2023-11-28T07:25:50.5033333+00:00

I will do that, thank you for the help!
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

error for properties_s when using iot hub logs

0 additional answers

Your answer