Oninit
Talk to an expert →

Informix Error -604

-604 Cannot read TEXT or BYTE value.

This statement refers to a BYTE or TEXT value, but some unexpected error prevented access to the value. Roll back the current transaction. Check the accompanying ISAM error code for more information; possibly a hardware error or data corruption of the storage space or tblspace occurred. If the error recurs, note all circumstances and contact IBM Informix Technical Support.

Oninit® Troubleshooting Guidance

Reasons / Common Causes

-604 fires when the server can't access an existing TEXT/BYTE (simple large object) value a statement refers to — another stage in the same BLOB-operation error family as -600 through -603.

  1. Hardware error or data corruption in the storage space/tblspace holding the value being read, per the official guidance.
  2. An underlying ISAM-level error while accessing the value, per the official guidance's pointer to checking the accompanying ISAM error code.
Solutions / Resolution
  1. Roll back the current transaction, per the official guidance.
  2. Check the accompanying ISAM error code, per the official guidance, for the specific underlying reason.
  3. Check for hardware errors or corruption in the storage space/tblspace, per the official guidance, via chunk status and OS-level disk/hardware logs.
  4. If this recurs, note all circumstances and contact IBM Informix Technical Support, per the official guidance.
Examples
Checking for storage-level problems
$ onstat -d
-- review chunk status for the blobspace/dbspace the TEXT/BYTE value lives in
Diagnostic Checks
  1. Check the accompanying ISAM error code first, per the official guidance.
  2. Check chunk status (onstat -d) and OS-level hardware/disk logs for the storage space involved.
Related Errors / Related Topics
  • -600 — "Cannot create TEXT or BYTE value." Same BLOB-operation family, at initial creation.
  • -601 — "Cannot delete TEXT or BYTE value." Same family, at delete/replace.
  • -602 — "Cannot open TEXT or BYTE value." Same family, at open/locate.
  • -603 — "Cannot close TEXT or BYTE value." Same family, at write completion.
  • -605 — "Cannot write TEXT or BYTE value." Same family, at write.

Part of the standing BLOB-operation error family — check hardware/corruption status in the storage space, same pattern as -601/-602/-603.