Oninit
Talk to an expert →

Informix Error -12142: Smart Large Objects: Invalid sbspace number.

Cause and resolution

Smart Large Objects: Invalid sbspace number.

The sbspace ID number you specified is incorrect. It is either out of range or does not refer to a valid smartblob space.

Correct the sbspace ID number and retry the operation.

Oninit® Troubleshooting Guidance

Reasons / Common Causes

-12142 fires when a specified sbspace ID number is incorrect — per the official guidance.

  1. The sbspace ID being out of range, per the official guidance — the first named case.
  2. The sbspace ID not referring to a valid smartblob space, per the official guidance — the second named case.
Solutions / Resolution
  1. Correct the sbspace ID number and retry the operation, per the official guidance.
Examples
N/A

No specific triggering statement is documented beyond an invalid sbspace ID.

Diagnostic Checks
  1. Check the sbspace ID number being used, and confirm it refers to an actual smartblob space.
Related Errors / Related Topics
  • -12143 — "Smart Large Objects: Invalid chunk number." The same class of invalid- identifier error, for a chunk number rather than an sbspace number.

The sbspace ID number was out of range or invalid — correct it and retry.