Informix Error -12202: Smart Large Objects: Non zero open count.
Cause and resolution
Smart Large Objects: Non zero open count.
You are trying to delete a smart large object whose open count is not zero.
Oninit® Troubleshooting Guidance
Reasons / Common Causes
-12202 fires when a DELETE targets a smart large object whose open count isn't zero —
per the official guidance.
- The smart large object's open count being nonzero, per the official guidance — the direct, only cause.
Solutions / Resolution
- Close all open instances of the object before deleting it, per the official guidance's implication.
Examples
N/A
No specific triggering statement is documented beyond deleting a currently-open object.
Diagnostic Checks
- Check the object's current open count, and close all open instances before deleting it.
Related Errors / Related Topics
- -12201 — "Smart Large Objects: Non zero reference count." The same class of delete restriction, on the reference count rather than the open count.
A smart large object couldn't be deleted because its open count is nonzero — close all open instances first.