Azure / Azure/azure-quickstart-templates

LeaseState_s column is absent in an oms-azure-storage-analytics-solution query

Open
#4,695 0 comments 0 reactions 0 assignees View on GitHub
Dominant language
Bicep
Stars
14.9k
Forks
16.2k
Avg merge
6d 21h
Merged PRs (30d)
6

Description

"oms-azure-storage-analytics-solution" creates Log Analytics dashboard on deploy.
When you open the "Azure Storage Analytics" dashboard you get the message:
`{"error":{"message":"The request had some invalid properties","code":"BadArgumentError","innererror":{"code":"SyntaxError","message":"Syntax Error","information":{"details":"{\"error\":{\"code\":\"Bad request\",\"message\":\"Request is invalid and cannot be executed.\",\"innererror\":{\"code\":\"SEM0100\",\"message\":\"'where' operator: Failed to resolve column or scalar expression named 'LeaseState_s'\",\"@context\":{\"activityId\":\"e88e1a6d-fc67-46d9-9367-22eebd495f3f\"},\"@errorCode\":\"SEM0100\",\"@errorMessage\":\"'where' operator: Failed to resolve column or scalar expression named 'LeaseState_s'\"}}}"}}}}`

The query related to the issue
`AzureStorage_CL
| where ShowinDesigner_d != 0 and MetricName_s == "Inventory" and InventoryType_s == "VHDFile" and LeaseState_s == "leased"
| summarize AggregatedValue = dcount(Uri_s) by StorageAccount_s
// Oql: Type=AzureStorage_CL ShowinDesigner_d!=0 MetricName_s=Inventory InventoryType_s=VHDFile LeaseState_s=leased | measure countdistinct(Uri_s) by StorageAccount_s`
fails to run

I couldn't find the column either.

Contributor guide

No contributing guide indexed for this repository

Research direction

Start by locating the oms-azure-storage-analytics-solution dashboard and its AzureStorage_CL query definitions. Compare the available AzureStorage_CL schema with the failing query's LeaseState_s reference and determine the intended field or condition. Done means the Azure Storage Analytics dashboard deploys and this query executes successfully.

Written by the indexing model from the issue text.

Assessment

Tech stack
azure
Domain
observability
Issue type
Bug
Difficulty
3/5
Estimated time
1-2 days
Activity status
Stale
Clarity
Mostly clear
Newbie friendliness
35/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.