Informix Error -12002: Smart Large Objects: Cannot add entry to sbspace table.

Reasons / Common Causes

-12002 fires when the server can't add an entry to the internal sbspace table — per the official guidance.

1. The sbspace entry possibly already being present in the table, per the official guidance — the named, likely cause.

Solutions / Resolution

1. Check whether the sbspace entry already exists before retrying, per the official guidance's implication.

Examples

N/A

No specific triggering statement is documented beyond a duplicate/failed sbspace table entry.

Diagnostic Checks

1. Check the internal sbspace table for an existing entry matching the one being added.

Related Errors / Related Topics

• -12010 — "Smart Large Objects: Cannot delete entry in sbspace table." The mirror-image operation on the same sbspace table — delete rather than add.

Adding an entry to the sbspace table failed, likely because it's already present — check for a duplicate entry.