Informix Error -2812: The temporary table table-name could not be read.
Cause and resolution
The temporary table table-name could not be read.
The application created and filled a temporary table in the database or created and filled some other temporary file, but when it tried to read rows from it, it received an error code from the database server. Probably a hardware failure occurred. Look for other error messages, including operating-system messages, that might give more information.
Oninit® Troubleshooting Guidance
Reasons / Common Causes
-2812 fires when an application successfully creates and populates a temporary table, but then fails to read rows back from it — per the official guidance, this is likely a hardware failure.
- A hardware failure, per the official guidance's named possibility.
Solutions / Resolution
- Look for other error messages, including operating-system messages, per the official guidance, for more diagnostic information.
Examples
N/A
No specific triggering statement is documented — this is a read failure on an already-created, populated temporary table.
Diagnostic Checks
- Check accompanying database-server and operating-system error messages for the specific underlying cause.
Related Errors / Related Topics
- -2811 — "The temporary table table-name could not be opened for writing." A related temporary-table error, about creation failing rather than a later read.
A read from an already-created, populated temporary table failed, likely hardware-related — check accompanying error messages.