Azure / Azure/azure-quickstart-templates
LeaseState_s column is absent in an oms-azure-storage-analytics-solution query
- 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