Informix Error -8019: Cannot open temporary file filename for reading of a TEXT column.
Cause and resolution
Cannot open temporary file filename for reading of a TEXT column.
For each TEXT column that is selected for the report, ACEGO prepares a temporary file in the directory that the DBTEMP environment variable names. This message indicates that the file was created and loaded with a copy of a TEXT value, but now it cannot be read. Look for operating-system error messages that might give more details. If the error recurs, note all circumstances and contact IBM Informix Technical Support.
Oninit® Troubleshooting Guidance
Reasons / Common Causes
-8019 fires when ACEGO's temporary file for a TEXT column can't be reopened for reading —
per the official guidance, this file was already created and loaded with a copy of the
TEXT value, in the directory named by DBTEMP, but now can't be read back.
- A failure reading a temporary
TEXT-column file after it was already created and loaded, per the official guidance — the direct, only cause; the specific reason is in accompanying operating-system messages.
Solutions / Resolution
- Look for operating-system error messages that might give more details, per the official guidance.
- If the error recurs, note all circumstances and contact IBM Informix Technical Support, per the official guidance.
Examples
Checking DBTEMP
$ echo $DBTEMP
$ df -h $DBTEMP
Diagnostic Checks
- Check accompanying operating-system messages, and verify the
DBTEMPdirectory's disk space and permissions.
Related Errors / Related Topics
No closely related error codes are cross-referenced for -8019 in this set yet.
A temporary TEXT-column file couldn't be reread — check the accompanying OS message and
DBTEMP's space/permissions.