HRESULT 0x87AF010E (SQLITE_E_CANTOPEN

Status / error code:

Category:

Constant name:

Source:

Facility:

Operating System:

Description:

SQLite could not locate or use a temporary directory required by the operation.

Previous	Next
SQLITE_E_CORRUPT_VTAB	SQLITE_E_CONSTRAINT_CHECK

SQLITE_E_CANTOPEN_NOTEMPDIR

SQLITE_E_CANTOPEN_NOTEMPDIR is the extended SQLite cannot-open result for a missing or unusable temporary directory.

What to check for SQLITE_E_CANTOPEN_NOTEMPDIR

Check the process temporary-directory configuration, service account permissions, and available space.
Check container and sandbox policies that may omit a writable temporary directory.
Fix the runtime environment rather than redirecting temporary files into the live database directory without considering its security and capacity limits.

PRAGMA temp_store;

SQLite: Result and Error Codes

SQLite: PRAGMA statements

Verification: Capture the exact data or storage operation that reports cantopen notempdir, then repeat it after changing only the implicated object or storage state.

Looking for a different code? Search another status or error code.