Oninit
Talk to an expert →

Informix Error -8244: The value <column-value> provided for row security label column </column-value> is invalid.

Cause and resolution

The value <column-value> provided for row security label column </column-value> is invalid.

An INSERT or UPDATE statement specified a value for a column of type IDSSECURITYLABEL. The value corresponds to a null label or cannot be converted to a valid security label for the security policy that is protecting the table. Check the INSERT or UPDATE statement and make sure that the value being set in the security label column is valid for the security policy protecting the table. Sometimes an invalid value can be generated as a result of a SELECT statement done from a table that is not protected with the same security policy as the target table. You should only copy security labels between tables protected by the same security policy.

Oninit® Troubleshooting Guidance

Reasons / Common Causes

-8244 fires when an INSERT/UPDATE sets an IDSSECURITYLABEL column to a value that's a null label or can't be converted to a valid security label — per the official guidance.

  1. The value corresponds to a null label, per the official guidance — the first named cause.
  2. The value can't be converted to a valid security label for the protecting policy, per the official guidance — the second named cause.
  3. A SELECT copying a security label from a table protected by a different security policy, per the official guidance — a specific, named contributing scenario.
Solutions / Resolution
  1. Check the INSERT/UPDATE statement, per the official guidance, and confirm the value being set in the security label column is valid for the protecting policy.
  2. Only copy security labels between tables protected by the same security policy, per the official guidance.
Examples
N/A

No specific triggering statement is documented beyond an invalid/null-corresponding security-label value.

Diagnostic Checks
  1. Check the value being inserted/updated into the IDSSECURITYLABEL column, and confirm its source table (if copied via SELECT) uses the same security policy.
Related Errors / Related Topics

No closely related error codes are cross-referenced for -8244 in this set yet.

A value set into a row-security-label column is invalid or from a differently-policied table — check the value and its source policy.