IBM Support

Error -79701 "Blob not found" while retrieving blobs (problem creating temporary files)

Troubleshooting


Problem

While using the IBM Informix JDBC driver to retrieve blobs, you get error -79701 "Blob not found".

Symptom


While using the IBM Informix® JDBC driver to retrieve blobs, you get error -79701 "Blob not found".

Cause


Error -79701 is given when the IBM Informix® JDBC driver gets an error while trying to access temporary files for caching blob data.

To find out if disk access is the cause of the problem, set the connection property LOBCACHE to -1. If the error does not reoccur, then you know a problem with disk access caused the error.

Important: This is not the only possible cause of the problem.

Resolving The Problem


The most common reasons that the driver could not write files are:

  • The user the java program is running as does not have the right system permissions for the directory it is writing to.
  • There is not enough disk space.

The IBM Informix JDBC driver will use the current directory for temporary files (including the cache files) by default. You can change the directory used to store temporary files by setting the connection property JDBCTEMP.

You can also tell the JDBC driver to cache all blob data in memory instead of files by setting LOBCACHE to -1.

See the IBM Informix JDBC driver manual for information on setting LOBCACHE and JDBCTEMP.

[{"Product":{"code":"SSVT2J","label":"Informix Tools"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Informix JDBC","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF025","label":"Platform Independent"},{"code":"PF008","label":"DYNIX\/ptx"},{"code":"PF010","label":"HP-UX"},{"code":"PF015","label":"IRIX"},{"code":"PF016","label":"Linux"},{"code":"PF026","label":"Reliant UNIX"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"1.0;1.1;1.2;1.3;1.4;1.5;1.6;2.0;2.1;2.2;2.3;2.4;2.5;2.6;2.7;2.8;2.9;3.0;4.0;4.1;4.2;5.1;6.0;7.2;7.3","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
20 January 2022

UID

swg21152782