| Previous | Next |
| CI_E_CONFIG_DISK_FULL | CI_E_NO_AUXMETADATA |
CI_E_DISTRIBUTED_GROUPBY_UNSUPPORTED
GROUP BY is unsupported for the distributed query
CI_E_DISTRIBUTED_GROUPBY_UNSUPPORTED is HRESULT 0x80041829. Windows documents it as “Groupby clause is not supported on a distributed query.”
Interpretation in context
This result belongs to validating a query that spans multiple machine/catalog targets and requests server-side grouping. The legacy distributed execution path cannot combine grouped aggregates with its target topology.
Conditions to test
- A local grouped query is reused after adding remote catalogs.
- A query builder enables grouping without checking distributed capability.
- The target list expands from one catalog to several.
- Client code assumes all Search SQL features distribute.
Compare the failing case with a control that preserves final SQL text and changes only resolved machine/catalog/scope targets; this prevents unrelated environment differences from dominating the test.
Incident record
- Check final SQL text.
- Check resolved machine/catalog/scope targets.
- Check grouping columns and aggregates.
- Check capability decision made by the query builder.
Capture final SQL text before releasing objects, closing handles or reconnecting. Retain the raw HRESULT with resolved machine/catalog/scope targets, component version, UTC timestamp and correlation ID.
Step-by-step diagnosis
- Run the same grouped query against one catalog as a control.
- Confirm the request is truly distributed after target expansion.
- Evaluate whether ungrouped rows can be merged safely client-side.
- Apply limits before retrieving data for client aggregation.
Preserve the component version and target identity, then alter only the condition described as the legacy distributed execution path cannot combine grouped aggregates with its target topology.
Retry decision
Remove server-side grouping, query targets separately and merge with defined semantics, or constrain execution to one supported catalog. Record whether validating a query that spans multiple machine/catalog targets and requests server-side grouping produced any content, update or state transition before returning.
Retry only after a concrete change in final SQL text or resolved machine/catalog/scope targets.
What the value cannot establish
It does not mean the GROUP BY syntax is invalid for a local query. Without the call boundary for validating a query that spans multiple machine/catalog targets and requests server-side grouping, it also cannot identify which wrapper or configuration layer introduced the condition.
Adjacent contract states
QUERY_E_INVALIDCATEGORIZE concerns malformed categorization; this HRESULT is a distributed-capability restriction.
Developer and administrator actions
- Record final SQL text with the returned HRESULT
- In telemetry, correlate resolved machine/catalog/scope targets with the target and component generation
- For regression coverage, force the documented condition: the legacy distributed execution path cannot combine grouped aggregates with its target topology
Concrete scenario
A dashboard adds a second catalog to a working grouped query. The planner switches to bounded per-catalog aggregation and merges totals explicitly.
Official Microsoft references
- Microsoft: content-indexing helper-function values — official contract information relevant to this HRESULT.
- Microsoft: Windows Search SQL syntax
- Microsoft: Windows Search grouping syntax
- Microsoft: Content-Indexing values
- Microsoft: HRESULT values
Looking for a different code? Search another status or error code.