| Previous | Next |
| hrInvalidPath | hrTooManyOpenDatabases |
hrRecordTooBig
Where the operation crossed the contract
hrRecordTooBig means the assembled row exceeds the record-size budget after fixed, variable, tagged, and key overhead are considered.
This is the legacy Directory Service backup/restore HRESULT form of JET_errRecordTooBig (0xC8000402).
The key comparison is: hrColumnDoesNotFit is tied to a particular field update; this code reflects the completed record size. The first useful observation is to measure each column payload, null state, multivalue count, and schema overhead for the failing row. This evidence separates schema definition, row-size accounting, null semantics, multivalue selection, and stale column IDs.
Reconstruct the engine state
- Code-specific observation: measure each column payload, null state, multivalue count, and schema overhead for the failing row.
- the complete row-size contribution from fixed, variable, tagged, and long-value data; associate it with this result rather than with a later generic exception.
- JET_COLUMNDEF fields, flags, code page, maximum length, and column ID origin; associate it with this result rather than with a later generic exception.
- the encoded value length, null/empty state, and itag sequence.
The ESE objects in play
| Diagnostic layer | column schema, row-size accounting, tagged/multivalued storage, and column identifiers |
|---|---|
| Typical API surface | JetAddColumn, JetDeleteColumn, JetSetColumn, JetRetrieveColumn, and JET_COLUMNDEF |
| Code-specific condition | the assembled row exceeds the record-size budget after fixed, variable, tagged, and key overhead are considered |
| First corrective direction | move large payloads to supported long-value columns or split the logical record without changing keys blindly |
Column IDs are metadata scoped to a table and should be refreshed after schema changes. Null, zero-length, deletion, and missing multivalue instances are distinct states.
Repair without destroying evidence
- Freeze the failing request context and record
0xC8000402, the Jet API name, and the current instance/session ownership. - Verify the code-specific precondition: measure each column payload, null state, multivalue count, and schema overhead for the failing row.
- Apply the targeted fix: move large payloads to supported long-value columns or split the logical record without changing keys blindly.
- Before retrying the operation, reconcile column metadata, row layout, and the exact stored value state.
Do not collapse these codes together
hrNullInvalid | the target column definition requires a non-null value |
|---|---|
hrTaggedNotNULL | a tagged-column operation used null semantics that are not valid for this representation or engine version |
hrInvalidColumnType | the JET_coltyp value or its option combination is unsupported for this column definition |
Actions that can hide or worsen the problem
- Do not alter the column schema in place without a migration and rollback plan.
- Do not collapse null, zero-length data, missing value, and tagged-value deletion into one state.
Technical references
Looking for a different code? Search another status or error code.