| Previous | Next |
| DB_E_NOTAREFERENCECOLUMN | DB_E_NOCOMMAND |
DB_E_LIMITREJECTED
Meaning
Windows documents DB_E_LIMITREJECTED as “Cost limits were rejected”. Here, a consumer submits command cost limits that the provider rejects instead of adopting.
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.
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 requested limit identifiers and values.
- Evidence 2: provider-supported command properties and limit capabilities.
- Evidence 3: property status values and OLE DB error records returned with the rejection.
Specific conditions that produce it
- Cause 1: the provider does not support the requested limit type.
- Cause 2: minimum and maximum constraints are internally inconsistent.
- Cause 3: the requested limits conflict with command properties or provider policy.
Retry and recovery policy
Retry rule: retry after changing or removing the rejected limits; executing the unchanged limit set will not make it acceptable.
Corrective actions
- Action 1: query supported limits before setting them.
- Action 2: remove unsupported or contradictory constraints.
- Action 3: treat rejected advisory limits separately from command execution failure.
Practical incident
A query framework sets a memory limit property on every provider, including one that does not implement that limit; capability-gating the property avoids it.
Difference from related HRESULT values
DB_E_COSTLIMIT means no plan can satisfy an accepted cost limit, while DB_E_LIMITREJECTED means the limit request itself was rejected.
Official Microsoft references
Looking for a different code? Search another status or error code.