Oninit
Talk to an expert →

Informix Error -603

-603 Cannot close TEXT or BYTE value.

This statement writes a BYTE or TEXT value, but some unexpected error prevented finishing the creation of 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

-603 fires when writing a TEXT/BYTE (simple large object) value fails to finish — the server was in the process of creating the value but couldn't complete/close it out, another stage in the same BLOB-operation error family as -600 through -602.

  1. Hardware error or data corruption in the storage space/tblspace holding the value being written, per the official guidance.
  2. An underlying ISAM-level error partway through the write, 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 was being written to
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.
  • -604 — "Cannot read TEXT or BYTE value." Same family, at read.
  • -605 — "Cannot write TEXT or BYTE value." Same family, at write — closely related to this error's "finishing the write" framing.

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