HRESULT 0x00040948 (IDS_MON_INVALID_IN_GROUP

Status / error code:

Category:

Constant name:

Source:

Facility:

Operating System:

Description:

an ORDER IN GROUP clause names a group that is not valid in the hierarchical search result.

Previous	Next
IDS_MON_DATE_OUT_OF_RANGE	DB_S_ROWLIMITEXCEEDED

IDS_MON_INVALID_IN_GROUP_CLAUSE

IDS_MON_INVALID_IN_GROUP_CLAUSE belongs to grouped Windows Search result ordering. GROUP ON ... OVER can create named ranges, and ORDER IN GROUP applies a separate order to a particular group. The identifier must correspond to a group produced by the grouping expression.

Match the order rule to the generated group name

Log the complete GROUP ON range list and any custom labels before the ORDER IN GROUP clause.
Remember that unlabeled groups derive names from their range limits, while labeled groups use the quoted label.
Check special groups such as MINVALUE and NULL against the actual grouping expression rather than assuming they are always present.

Microsoft documents that group ranges divide the rowset at ordered limits and that labels are attached with a slash syntax. ORDER IN GROUP is specifically for applying different ordering rules to individual groups. If a query builder renames a range label but leaves an old order rule, the parser cannot bind the identifier. Fix both fragments atomically.

GROUP ON and labels · Parser messages · ORDER BY basics

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