Oninit
Talk to an expert →

Informix Error -12027: Smart Large Objects: Cannot delete SB_LOHD_SLOT.

Cause and resolution

Smart Large Objects: Cannot delete SB_LOHD_SLOT.

You cannot delete the LO header page for a smart large object. The chunk or sbspace might be inaccessible or the LO address might be invalid. Ensure that the chunk is accessible. Ensure that the smart-large-object address is still valid--that is, the smart large object has not already been removed.

Oninit® Troubleshooting Guidance

Reasons / Common Causes

-12027 fires when the LO header page for a smart large object can't be deleted — per the official guidance.

  1. The chunk or sbspace being inaccessible, per the official guidance — the first named case.
  2. The LO address being invalid (the smart large object already removed), per the official guidance — the second named case.
Solutions / Resolution
  1. Ensure the chunk is accessible, per the official guidance.
  2. Ensure the smart-large-object address is still valid, per the official guidance — confirm the object hasn't already been removed.
Examples
N/A

No specific triggering statement is documented beyond deleting an inaccessible or already-removed object's header slot.

Diagnostic Checks
  1. Check chunk/sbspace accessibility, and confirm the smart large object hasn't already been removed before retrying.
Related Errors / Related Topics
  • -12026 — "Smart Large Objects: Cannot delete smart large object." The general form of this same class of delete failure.
  • -12028 — "Smart Large Objects: Cannot delete SB_LOMAP_SLOT." The same class of delete failure, on the extent map slot rather than the LO header slot.
  • -12029 — "Smart Large Objects: Cannot delete SB_USERDATA_SLOT." The same class of delete failure, on the user data slot rather than the LO header slot.

The LO header page couldn't be deleted, likely due to an inaccessible chunk or an already-removed object — check both.