HRESULT 0x80041617 (QUERY_E_INVALIDCOALESCE): meaning and diagnosis

Status / error code:

Category:

Constant name:

Source:

Facility:

Operating System:

Description:

the coalesce query is used in an unsupported form, including incompatible mixing with grouping.

Previous	Next
QUERY_E_INVALIDSORT_COALESCE	QUERY_E_UPGRADEINPROGRESS

QUERY_E_INVALIDCOALESCE

QUERY_E_INVALIDCOALESCE is the general structural error for a coalesce query. The built-in description specifically calls out improper use and possible mixing of grouping with coalesce, so the nested query shape is the primary evidence.

Reduce the combined query to its component statements

Log each component independently and confirm that it succeeds before coalescing.
Remove GROUP ON ... OVER layers while testing whether the failure is the interaction between grouping and coalesce.
Check scope and sort consistency separately; those mismatches have their own dedicated HRESULTs.

Windows Search documents hierarchical grouping through GROUP ON ... OVER, where the OVER input is another group or SELECT. That grammar is already nested and has explicit ordering rules. A legacy coalesce feature should not be assumed to compose with every grouping shape. Diagnose the query tree as generated, not just the visible search terms.

Legacy query errors · GROUP ON ... OVER · Windows Search SQL overview

Looking for a different code? Search another status or error code.