Informix Error -32139: No initial value has been set for the SERIAL column.

Reasons / Common Causes

-32139 fires in a multilevel-secure application when no initial SERIAL value exists for the sensitivity level being accessed — per the official guidance, the initial serial value must be set at table creation if a SERIAL column exists.

1. No initial SERIAL value exists for the sensitivity level being accessed, per the official guidance — the direct, only cause; applicable only to multilevel-secure applications.

Solutions / Resolution

1. Set the initial SERIAL value for that sensitivity level at table-creation time, per the official guidance.

Examples

N/A

No specific triggering statement is documented beyond a missing per-level initial SERIAL value.

Diagnostic Checks

1. Check whether the accessed sensitivity level has its own initial SERIAL value set, and recreate the table with it set if not.

Related Errors / Related Topics

• -32128 — "No privilege for changing a SERIAL column." A related SERIAL-column error, on a missing privilege rather than a missing per-level initial value.
• -32138 — "Cannot set the initial SERIAL value." A related SERIAL-column error, on the initial value being entirely unset rather than missing for a specific level.

No initial SERIAL value existed for the sensitivity level being accessed — set it at table-creation time for that level.