What does HRESULT 0x87AF190A (SQLITE_E_IOERR_GETTEMPPATH) mean?

Status / error code:

Category:

Constant name:

Source:

Facility:

Operating System:

Description:

SQLite could not determine a usable temporary-files directory.

Previous	Next
SQLITE_E_IOERR_MMAP	SQLITE_E_IOERR_VNODE

SQLITE_E_IOERR_GETTEMPPATH

SQLITE_E_IOERR_GETTEMPPATH corresponds to SQLITE_IOERR_GETTEMPPATH. The VFS could not determine a suitable directory for SQLite temporary files.

Check the process environment, temporary-directory configuration, and write permissions for the service account.
Verify that the selected temporary volume is online and has usable free space.
Remember that sorts, indexes, and some query plans can need temporary files even when the main database is read-only.

PRAGMA temp_store;