| Previous | Next |
| DB_E_COMMANDNOTPERSISTED | DB_E_OBJECTCREATIONLIMITREACHED |
DB_E_DUPLICATEID
DBID already exists
Exact value and result class
DB_E_DUPLICATEID has unsigned value 2147749480 (0x80040E68) and signed 32-bit value -2147217816. AllStat describes it as “DBID already exists”. In this result, creation or persistence requests a provider-scoped DBID that already names another object.
The high bit is set, so DB_E_DUPLICATEID is a failure HRESULT. Its facility is 4 (FACILITY_ITF) and its low code is 3688 (0x0E68). For DB_E_DUPLICATEID, 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_DUPLICATEID, persisted OLE DB commands use DBIDs and persistence flags that are distinct from command text. For DB_E_DUPLICATEID, a live command can execute successfully without having a persistent identity, and a persistent name is scoped to the provider namespace.
Investigation of DB_E_DUPLICATEID should start with the command object, current DBID, persistence flags and provider namespace. Capture DB_E_DUPLICATEID before ADO, ATL, .NET or a database abstraction layer replaces the native HRESULT with a generic exception.
Diagnostic sequence
- Capture raw
0x80040E68and symbolicDB_E_DUPLICATEIDat the native call boundary. - Identify the exact failing stage for
DB_E_DUPLICATEID: creation or persistence requests a provider-scoped DBID that already names another object. - Retrieve all OLE DB error records for
DB_E_DUPLICATEIDbefore another COM call replaces thread error information. - Compare the live object state and provider-granted capabilities with the input that produced
DB_E_DUPLICATEID. - Reduce the
DB_E_DUPLICATEIDoperation to the smallest case that preserves the same persist contract. - Apply one evidence-backed correction for
DB_E_DUPLICATEIDand verify that the result is not merely replaced by a neighboring HRESULT.
Conditions that specifically lead to this result
- Cause 1 for
DB_E_DUPLICATEID: the application generated a nonunique name. - Cause 2 for
DB_E_DUPLICATEID: a previous deployment left the object in place. - Cause 3 for
DB_E_DUPLICATEID: two concurrent creators chose the same DBID.
Evidence to collect
A useful DB_E_DUPLICATEID 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_DUPLICATEID data involving command text, persistent command names and schema identifiers, use types, lengths, hashes or redacted identifiers rather than secrets or complete business data.
- Evidence 1 for
DB_E_DUPLICATEID: full DBID kind and value. - Evidence 2 for
DB_E_DUPLICATEID: existing object resolved under that ID. - Evidence 3 for
DB_E_DUPLICATEID: creation transaction and competing correlation IDs.
Corrective actions
- Action 1 for
DB_E_DUPLICATEID: use provider identifier rules when generating names. - Action 2 for
DB_E_DUPLICATEID: adopt an explicit replace or reuse policy. - Action 3 for
DB_E_DUPLICATEID: serialize or make create-if-absent logic race-safe.
Retry and recovery
Retry rule for DB_E_DUPLICATEID: retry with a new unique DBID or after deliberately removing the existing object. A DB_E_DUPLICATEID 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_DUPLICATEID, determine whether rows, schema objects or URL resources were partially created or changed.
Do not turn DB_E_DUPLICATEID into an unbounded retry loop. Preserve cancellation for DB_E_DUPLICATEID and use a fresh provider object when the failed call may have left local state ambiguous.
Difference from nearby HRESULT values
DB_E_RESOURCEEXISTS is URL-oriented binder creation, while DB_E_DUPLICATEID is a provider DBID namespace collision. Telemetry and remediation for DB_E_DUPLICATEID should keep these outcomes distinct.
Practical scenario
Two workers persist a command under the same generated name; adding a collision-safe identifier prevents DB_E_DUPLICATEID. Keeping DB_E_DUPLICATEID 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_DUPLICATEID 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_DUPLICATEID, 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_DUPLICATEID should group by provider version, interface, method and normalized failure stage. A DB_E_DUPLICATEID event must not expose passwords, tokens, full connection strings, unrestricted command text or raw row contents.
Official Microsoft references
- Microsoft: ICommandPersist::GetCurrentCommand — official documentation relevant to
DB_E_DUPLICATEID. - Microsoft: OLE DB interfaces — official documentation relevant to
DB_E_DUPLICATEID. - Microsoft: OLE DB overview — official documentation relevant to
DB_E_DUPLICATEID.
Looking for a different code? Search another status or error code.