| Previous | Next |
| DB_E_BADTYPENAME | DB_E_ROWSETINCOMMAND |
DB_E_ABORTLIMITREACHED
Meaning
Windows documents DB_E_ABORTLIMITREACHED as “Execution stopped because a resource limit was reached. No results were returned”. Here, command execution stops because a configured resource limit is reached and no results are returned.
Evidence to collect before changing the system
When it involves command text, parameter values, object names and query-plan details, record types, lengths, hashes or redacted identifiers instead of secrets or full business data.
- Evidence 1: the exact limit and measured consumption at abort.
- Evidence 2: command, plan and parameter identity.
- Evidence 3: provider and server diagnostic records for the limiting resource.
Relevant OLE DB contract
This result must be interpreted against this contract: an OLE DB command moves through explicit states: command definition, properties and parameters are established before optional preparation and execution; dialect, query-tree and optimizer contracts are provider-specific and should be inferred only from reported capabilities.
Specific conditions that produce it
- Cause 1: execution exceeds a time, memory or row-processing limit.
- Cause 2: the data set or plan changed after the limit was chosen.
- Cause 3: a provider or server governor aborts the request before producing a result.
Corrective actions
- Action 1: reduce the command's resource demand through predicates, indexes or batching.
- Action 2: raise a limit only when operational policy permits.
- Action 3: distinguish an intentional resource abort from connectivity or syntax failure.
Practical incident
A query that previously fit a work-memory guard grows after data expansion and is aborted with no rows; adding an index lowers resource use and prevents it.
Retry and recovery policy
Retry rule: retry only after reducing demand, changing the plan or intentionally adjusting the limit.
Difference from related HRESULT values
DB_E_COSTLIMIT means no acceptable plan was found before execution, while DB_E_ABORTLIMITREACHED means execution began and then hit a resource ceiling.
Official Microsoft references
Looking for a different code? Search another status or error code.