| Previous | Next |
| hrCurrencyStackOutOfMemory | hrWriteConflict |
hrOutOfSessions
Why this is more specific than the message text
hrOutOfSessions means the instance cannot allocate another JET_SESID.
This is the legacy Directory Service backup/restore HRESULT form of JET_errOutOfSessions (0xC800044D).
The key comparison is: hrTooManyActiveUsers describes workload concurrency; this result is the session-handle pool itself. The first useful observation is to inventory session creation/end pairs, thread pools, abandoned requests, and transactions that keep sessions alive. This evidence identifies the exhausted pool so a leak, long transaction, concurrency spike, and hard capacity limit are not confused.
Related ESE conditions
hrOutOfMemory | ESE or its caller could not reserve memory required for the operation |
|---|---|
hrTooManyActiveUsers | the engine reached its active-user or concurrent-session workload limit |
hrOutOfFileHandles | the engine could not obtain another operating-system file handle for database work |
The ESE objects in play
| Diagnostic layer | bounded engine, process, and storage resources |
|---|---|
| Typical API surface | instance system parameters, sessions, cursors, temporary tables, database attachment, and file growth |
| Code-specific condition | the instance cannot allocate another JET_SESID |
| First corrective direction | pool cautiously, call JetEndSession on every terminal path, and impose a hard admission limit |
Long transactions can retain versions and indirectly amplify memory and log pressure. A retry without closing owners or adding capacity often repeats the same failure and increases load.
Data for a reproducible case
- Code-specific observation: inventory session creation/end pairs, thread pools, abandoned requests, and transactions that keep sessions alive.
- live resource counts grouped by session and request owner.
- relevant JET_param values and process or system capacity at first failure.
- the oldest transaction, longest-held cursor, or file growth operation retaining the resource.
Corrective workflow
- Freeze the failing request context and record
0xC800044D, the Jet API name, and the current instance/session ownership. - Verify the code-specific precondition: inventory session creation/end pairs, thread pools, abandoned requests, and transactions that keep sessions alive.
- Apply the targeted fix: pool cautiously, call JetEndSession on every terminal path, and impose a hard admission limit.
- Before retrying the operation, reconcile resource counts, owner cleanup, and capacity after the correction.
Actions that can hide or worsen the problem
- Do not raise limits before checking ownership and release paths.
- Do not create a retry storm while the exhausted resource remains unavailable.
Technical references
- JET_param enumeration.
- Transactions and save points
- ESE files and storage paths
- ESE source repository
- Microsoft: JET_ERR enumeration
Looking for a different code? Search another status or error code.