| Previous | Next |
| DB_S_ERRORSRETURNED | DB_S_DELETEDROW |
DB_S_BADROWHANDLE
OLE DB encountered an invalid HROW while processing other work
DB_S_BADROWHANDLE is HRESULT 265939 (0x00040ED3) from Microsoft OLE DB. AllStat describes DB_S_BADROWHANDLE as “Row handle is invalid.” The high-order severity bit is clear, so this is a success result, but it carries more information than plain S_OK.
The operation reports that a row handle is invalid, typically as a per-row or mixed-status condition rather than a total provider failure.
State boundary that must be proved
The central question for DB_S_BADROWHANDLE is whether the invalid handle is identified and no valid row handle is discarded or reused incorrectly. For DB_S_BADROWHANDLE, the HRESULT alone confirms neither unrelated work nor the quality of optional outputs.
A reliable interpretation of DB_S_BADROWHANDLE names the exact method contract, the object generation, and the outputs that remain valid. For DB_S_BADROWHANDLE, this prevents a success-with-information result from being promoted to full success or demoted to a generic error.
Where this result is encountered
DB_S_BADROWHANDLEcan appear in ReleaseRows or row update batches; record the producing interface and method rather than inferring behavior from the symbolic name alone.DB_S_BADROWHANDLEcan appear in consumers retaining HROW values too long; record the producing interface and method rather than inferring behavior from the symbolic name alone.DB_S_BADROWHANDLEcan appear in dynamic rowsets where handles become invalid; record the producing interface and method rather than inferring behavior from the symbolic name alone.
For DB_S_BADROWHANDLE, the same numeric success value can be mishandled when a wrapper exposes only a Boolean. For DB_S_BADROWHANDLE, keep the original HRESULT until the code-specific outputs and state transition have been evaluated.
Evidence and telemetry to preserve
- For
DB_S_BADROWHANDLE, preserve HROW values and owning rowset. - For
DB_S_BADROWHANDLE, preserve acquisition and release sequence. - For
DB_S_BADROWHANDLE, preserve rowset generation. - For
DB_S_BADROWHANDLE, preserve per-row status array. - For
DB_S_BADROWHANDLE, preserve concurrent delete or restart activity.
Also record db_s_badrowhandle_operation, db_s_badrowhandle_object, db_s_badrowhandle_state_before, db_s_badrowhandle_state_after, UTC time, process and thread identifiers, and a correlation ID. For DB_S_BADROWHANDLE, keep secrets out of logs while retaining GUIDs, CLSIDs, media subtypes, property IDs, row identities, and hashes needed to distinguish objects.
Diagnostic sequence
- For
DB_S_BADROWHANDLE, capture the raw HRESULT0x00040ED3immediately after the returning method and record whether the caller usedSUCCEEDED,FAILED, equality testing, or exception translation. - Identify the exact owner of
DB_S_BADROWHANDLE: interface, method, object instance, provider or filter version, thread or apartment, and operation phase. - Validate the decisive contract boundary for
DB_S_BADROWHANDLE: the invalid handle is identified and no valid row handle is discarded or reused incorrectly. - For
DB_S_BADROWHANDLE, inspect every output parameter, count, status array, returned interface, or side effect that the method documentation associates with this success-with-information result. - Compare the observed state before and after
DB_S_BADROWHANDLE; do not assume that a success severity bit means every optional sub-operation completed. - For
DB_S_BADROWHANDLE, reproduce the smallest request with the same object state and then change only the condition identified by the evidence before repeating the operation.
Correct handling, retry, and recovery
Remove the invalid handle from consumer state, reacquire the row if needed, and audit handle ownership. Do not retry the same stale HROW against a new rowset.
Retry DB_S_BADROWHANDLE only when the recorded state can change the documented outcome. For DB_S_BADROWHANDLE, repeating the same call is inappropriate for a stable end marker, cancellation, unsupported format, adjusted property, or partial result whose completed side effects have not been reconciled.
Practical validation scenario
A cache mixes handles from two rowset generations. The provider flags one as bad; the client clears generation-mismatched handles and refetches by key.
The negative test should preserve the condition that produces DB_S_BADROWHANDLE; the recovery test should alter only that condition and verify the final state as well as the HRESULT.
Difference from nearby HRESULT values
DB_S_DELETEDROW means the handle identifies a row that was deleted; DB_S_BADROWHANDLE means the handle itself is not valid for the operation.
For DB_S_BADROWHANDLE, this distinction determines whether the caller should consume partial outputs, stop iteration, wait, reconfigure, notify the user, or perform no error recovery at all.
Developer and administrator guidance
Developers should represent DB_S_BADROWHANDLE as a distinct typed outcome, because collapsing it into generic success loses the condition encoded by 0x00040ED3. For DB_S_BADROWHANDLE, administrators and support engineers should retain the first component-specific evidence before wrappers replace it with a broad message.
A support report for DB_S_BADROWHANDLE should include decimal 265939, hexadecimal 0x00040ED3, the AllStat meaning, the owning API, and the first detailed status or output that explains why the method did not return ordinary S_OK.
References
- Microsoft: OLE DB return codes — official documentation relevant to
DB_S_BADROWHANDLE. - Microsoft: OLE DB Driver return codes — official documentation relevant to
DB_S_BADROWHANDLE. - Microsoft: OLE DB error records — official documentation relevant to
DB_S_BADROWHANDLE.
Looking for a different code? Search another status or error code.