Oninit
Talk to an expert →

Informix Error -47089: Cannot specify server or site as a default value with this column length.

Cause and resolution

Cannot specify server or site as a default value with this column length.

For specifying a default value that consists of the current database server name or current site name for a CHAR, NCHAR, VARCHAR, or NVARCHAR column, the minimum column length must be 18. Increase the column length, or specify a different default value.

Oninit® Troubleshooting Guidance

Reasons / Common Causes

-47089 fires in the interactive ALTER TABLE menu when SERVER/SITE is specified as a default value on a character column shorter than the required minimum — per the official guidance, the minimum length is 18.

  1. The column's length being less than 18, per the official guidance — the direct, only cause.
Solutions / Resolution
  1. Increase the column's length to at least 18, per the official guidance.
  2. Or specify a different default value, per the official guidance.
Examples
N/A

No specific triggering statement is documented beyond this menu-driven default-value restriction.

Diagnostic Checks
  1. Check the column's declared length, and increase it to at least 18, or choose a different default value.
Related Errors / Related Topics
  • -47088 — "Cannot specify server or site as a default value with this column type." A related SERVER/SITE default-value error, on the column being the wrong type rather than too short.
  • -47092 — "Cannot specify user as a default value with this column length." A related length restriction, for USER (minimum 8) rather than SERVER/SITE (minimum 18).

SERVER/SITE as a default value requires a column length of at least 18 — increase the length or choose a different default.