Kusto: Relop semantic error: SEM0026: The arguments array exceeded the allowed limit (allowed=1,000,000)

Question

Hi Team,

I have been using the following query to monitor our Logic Apps.

AzureDiagnostics
| where Category == "WorkflowRuntime"
| where OperationName == "Microsoft.Logic/workflows/workflowRunCompleted"
| join kind = rightouter (AzureDiagnostics
| where Category == "WorkflowRuntime"
| where OperationName == "Microsoft.Logic/workflows/workflowRunStarted"
| where resource_runId_s in ((AzureDiagnostics
| where Category == "WorkflowRuntime"
| where OperationName == "Microsoft.Logic/workflows/workflowTriggerCompleted"
| project resource_runId_s))
| project
WorkflowStartStatus=status_s,
WorkflowNameFromInnerQuery=resource_workflowName_s,
WorkflowIdFromInnerQuery=workflowId_s,
resource_runId_s)
on resource_runId_s
| extend WorkflowStatus=iff(isnotempty(status_s), status_s, WorkflowStartStatus)
| extend WorkflowName=iff(isnotempty(resource_workflowName_s), resource_workflowName_s, WorkflowNameFromInnerQuery)
| extend WorkflowId=iff(isnotempty(workflowId_s), workflowId_s, WorkflowIdFromInnerQuery)
| summarize Count=count() by WorkflowId, WorkflowName, WorkflowStatus

Now it is throwing an error:
Relop semantic error: SEM0026: The arguments array exceeded the allowed limit (allowed=1,000,000)
If the issue persists, please open a support ticket. Request id:

I'm new to KQL, any help would be appreciated.

Thanks!

Answer 1

Hello @Shafeeq TS - The Relop semantic error: SEM0026: The arguments array exceeded the allowed limit (allowed=1,000,000) error appears to be related to an issue where the source data that your query run against is being absent or corrupted. In this case, it'd be best to open a support case and work with one of our support engineers who has deeper insight into your environment to troubleshoot the root cause. Does your Azure Subscription carry a support plan?