Informix Error -12097: Smart Large Objects: Invalid smart large object address or ID.
Cause and resolution
Smart Large Objects: Invalid smart large object address or ID.
The most likely reason for this error message is that the smart large object reference being used contains outdated information. The client application might have passed an invalid smart large object reference to the server: for example, a reference to a smart large object the application deleted prior to the current reference attempt. If a smart large object is deleted and then a new one created in its place, any references to the old object are no longer valid, because the new object will have a different ID even if it is stored in the same physical location.
Oninit® Troubleshooting Guidance
Reasons / Common Causes
-12097 fires when a smart-large-object reference contains outdated information — per the official guidance.
- A client application passing a reference to a smart large object it already deleted, per the official guidance — the direct, most likely cause; a newly created object in the same physical location gets a different ID, so old references never become valid again.
Solutions / Resolution
- Confirm the smart-large-object reference is current, per the official guidance's implication — don't reuse a reference after the object it points to has been deleted.
Examples
N/A
No specific triggering statement is documented beyond using a stale reference.
Diagnostic Checks
- Check whether the smart large object referenced was deleted before this call, and fetch a fresh reference if so.
Related Errors / Related Topics
- -12048 — "Smart Large Objects: unique ID does not match. Smart large object probably deleted." A closely related stale-reference error.
A smart-large-object reference was stale (its object was already deleted) — fetch a fresh reference.