Informix Error -12041: Smart Large Objects: Size of smart large object or buffer is too big.
Cause and resolution
Smart Large Objects: Size of smart large object or buffer is too big.
The size after a write or truncate operation exceeds the maximum size limit for the smart large object. The system does not allow the size of the smart large object to exceed the maximum number of bytes that the application sets. This size limit was set by the CREATE or ALTER statement for the smart large object.
Oninit® Troubleshooting Guidance
Reasons / Common Causes
-12041 fires when a write or truncate operation would make a smart large object exceed its configured maximum size — per the official guidance.
- The resulting size exceeding the maximum size limit set by the object's
CREATE/ALTERstatement, per the official guidance — the direct, only cause.
Solutions / Resolution
- Keep the object's size within the limit set by its
CREATE/ALTERstatement, per the official guidance, or increase that limit if a larger object is genuinely needed.
Examples
N/A
No specific triggering statement is documented beyond exceeding the object's configured maximum size.
Diagnostic Checks
- Check the maximum-size limit set for the object (via its
CREATE/ALTERstatement), and confirm the write/truncate stays within it.
Related Errors / Related Topics
- -12040 — "Smart Large Objects: Invalid truncate value for size." A related size-validity error, on a negative truncate size rather than exceeding the maximum.
A write/truncate would exceed the smart large object's configured maximum size — check that limit.