| Previous | Next |
| DB_SEC_E_AUTH_FAILED | DB_E_CHAPTERNOTRELEASED |
DB_E_CANCELED
Operation was canceled
Exact value and result class
DB_E_CANCELED has unsigned value 2147749454 (0x80040E4E) and signed 32-bit value -2147217842. AllStat describes it as “Operation was canceled”. In this result, an OLE DB operation terminates because cancellation became effective before normal completion.
The high bit is set, so DB_E_CANCELED is a failure HRESULT. Its facility is 4 (FACILITY_ITF) and its low code is 3662 (0x0E4E). For DB_E_CANCELED, these fields identify an interface-defined result family; they do not identify the provider instance, method, object generation or partial effects.
Contract boundary
For DB_E_CANCELED, cancellation can originate from the consumer, an asynchronous status object, a timeout policy, a notification veto or provider shutdown. For DB_E_CANCELED, the returned result does not by itself prove that the underlying server performed no work.
Investigation of DB_E_CANCELED should start with the operation correlation ID, cancellation source and provider phase at the moment cancellation became effective. Capture DB_E_CANCELED before ADO, ATL, .NET or a database abstraction layer replaces the native HRESULT with a generic exception.
Diagnostic sequence
- Capture raw
0x80040E4Eand symbolicDB_E_CANCELEDat the native call boundary. - Identify the exact failing stage for
DB_E_CANCELED: an OLE DB operation terminates because cancellation became effective before normal completion. - Retrieve all OLE DB error records for
DB_E_CANCELEDbefore another COM call replaces thread error information. - Compare the live object state and provider-granted capabilities with the input that produced
DB_E_CANCELED. - Reduce the
DB_E_CANCELEDoperation to the smallest case that preserves the same cancel contract. - Apply one evidence-backed correction for
DB_E_CANCELEDand verify that the result is not merely replaced by a neighboring HRESULT.
Conditions that specifically lead to this result
- Cause 1 for
DB_E_CANCELED: the application explicitly called a cancel method. - Cause 2 for
DB_E_CANCELED: a timeout or shutdown path requested cancellation. - Cause 3 for
DB_E_CANCELED: a notification receiver vetoed an operation that permits cancellation.
Evidence to collect
A useful DB_E_CANCELED event records provider CLSID and version, process architecture, interface IID and method, object correlation ID, transaction state and the immediately preceding HRESULT. When recording DB_E_CANCELED data involving command text, user identity and partial output data, use types, lengths, hashes or redacted identifiers rather than secrets or complete business data.
- Evidence 1 for
DB_E_CANCELED: the component and timestamp that initiated cancellation. - Evidence 2 for
DB_E_CANCELED: whether the provider reported partial row or property statuses. - Evidence 3 for
DB_E_CANCELED: server-side activity showing whether work continued after the client returned.
Corrective actions
- Action 1 for
DB_E_CANCELED: propagate a distinct cancellation result instead of mapping it to failure. - Action 2 for
DB_E_CANCELED: make cancellation idempotent and preserve the original correlation ID. - Action 3 for
DB_E_CANCELED: verify partial effects before replaying any modifying operation.
Retry and recovery
Retry rule for DB_E_CANCELED: retry only when the caller deliberately starts a new operation and partial completion has been excluded. A DB_E_CANCELED retry is safe only when the relevant input, object generation, capability or external state has changed. Before replaying a modifying call that returned DB_E_CANCELED, determine whether rows, schema objects or URL resources were partially created or changed.
Do not turn DB_E_CANCELED into an unbounded retry loop. Preserve cancellation for DB_E_CANCELED and use a fresh provider object when the failed call may have left local state ambiguous.
Difference from nearby HRESULT values
DB_E_TIMEOUT reports expiration while binding to an object, whereas DB_E_CANCELED records an effective cancellation request. Telemetry and remediation for DB_E_CANCELED should keep these outcomes distinct.
Practical scenario
A user cancels a long command while the server has already changed several rows; the client checks transaction outcome before offering retry. Keeping DB_E_CANCELED with the method and object state makes this scenario diagnosable instead of reducing it to “database error”.
Developer and operations guidance
Code handling DB_E_CANCELED should release COM objects in ownership order, retain per-row, per-column or per-property statuses, and log granted capabilities rather than only requested options. While handling DB_E_CANCELED, opaque values such as HACCESSOR, HROW, HCHAPTER, DBID components and provider handles must remain scoped to the object that issued them.
Operational dashboards for DB_E_CANCELED should group by provider version, interface, method and normalized failure stage. A DB_E_CANCELED event must not expose passwords, tokens, full connection strings, unrestricted command text or raw row contents.
Official Microsoft references
- Microsoft: OLE DB interfaces — official documentation relevant to
DB_E_CANCELED. - Microsoft: OLE DB return codes — official documentation relevant to
DB_E_CANCELED. - Microsoft: IErrorRecords — official documentation relevant to
DB_E_CANCELED.
Looking for a different code? Search another status or error code.