| Previous | Next |
| MD_E_INVALIDAXIS | DB_E_NOCOLUMN |
MD_E_INVALIDCELLRANGE
Meaning
Windows documents MD_E_INVALIDCELLRANGE as “One or more cell ordinals is invalid”. In this case, a requested cell range contains at least one ordinal outside the current cellset.
Relevant contract
OLE DB for OLAP models axes, tuples, coordinates and cells separately. A tuple identifies one member from each relevant hierarchy, a coordinate positions a cell across axes, and cell ordinals are valid only for the current dataset shape.
Investigation of this result should start with the dataset object, axis metadata, tuple construction and cellset generation used by the failing call.
Conditions that specifically lead to the result
- Cause 1: the start or end ordinal exceeds cell count.
- Cause 2: range arithmetic overflows or reverses boundaries.
- Cause 3: cached cell ordinals belong to an earlier axis cardinality.
Evidence to collect
When recording diagnostic data involving member unique names, cube coordinates and calculated-measure expressions, use types, lengths, hashes or redacted identifiers rather than secrets or complete business data.
- Evidence 1: requested first and last cell ordinal.
- Evidence 2: current total cell count and axis cardinalities.
- Evidence 3: dataset generation used to calculate the range.
Diagnostic sequence
- Identify the exact failing stage: a requested cell range contains at least one ordinal outside the current cellset.
Corrective actions
- Action 1: perform checked range arithmetic.
- Action 2: clip user paging only within documented bounds.
- Action 3: recompute linear ordinals whenever axis shape changes.
Retry and recovery
Retry rule: retry after replacing the range with ordinals valid for the current cellset.
Practical scenario
A grid requests the old final page after filtering shrinks the cube result; recomputing cell count avoids the invalid range.
Difference from nearby HRESULT values
MD_E_BADCOORDINATE rejects a multidimensional coordinate, while MD_E_INVALIDCELLRANGE rejects linear cell ordinals.
Official Microsoft references
Looking for a different code? Search another status or error code.