What does HRESULT 0x80040E61 (MD_E_BADTUPLE) mean?

 
Previous Next
DB_E_CANTORDER MD_E_BADCOORDINATE

MD_E_BADTUPLE

Meaning

Windows documents MD_E_BADTUPLE as “Tuple is invalid”. In this case, an OLAP operation receives a tuple whose members do not form a valid tuple for the current cube and axis context.

Conditions that specifically lead to the result

  • Cause 1: members come from incompatible hierarchies.
  • Cause 2: tuple arity does not match the expected coordinate shape.
  • Cause 3: a member unique name is stale after cube metadata changed.

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.

Diagnostic sequence

  1. Identify the exact failing stage: an OLAP operation receives a tuple whose members do not form a valid tuple for the current cube and axis context.

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: member unique names and hierarchy IDs.
  • Evidence 2: expected tuple arity from axis metadata.
  • Evidence 3: cube and catalog generation used to build the tuple.

Corrective actions

  • Action 1: construct tuples from current schema metadata.
  • Action 2: include at most the permitted member from each hierarchy.
  • Action 3: re-resolve persisted member names before execution.

Practical scenario

A saved tuple combines two members from the same hierarchy; reconstructing it with one member per hierarchy makes it valid.

Retry and recovery

Retry rule: retry after rebuilding the tuple from valid current members.

Difference from nearby HRESULT values

MD_E_BADCOORDINATE rejects a complete cell coordinate, while MD_E_BADTUPLE rejects one tuple component.

Official Microsoft references


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