Informix Error -23859: This operation is not allowed on a violations/diagnostics table (<tabname>).
Cause and resolution
This operation is not allowed on a violations/diagnostics table (<tabname>).
The specified table is a violations or diagnostics table, and the attempted operation is not allowed on such a table.
Specify a table that is not a violations or diagnostics table and retry the operation.
</tabname>Oninit® Troubleshooting Guidance
Reasons / Common Causes
-23859 fires when an operation not allowed on a violations or diagnostics table is attempted — per the official guidance.
- An operation unsupported on violations/diagnostics tables, per the official guidance — the direct, only cause.
Solutions / Resolution
- Specify a table that isn't a violations/diagnostics table and retry the operation, per the official guidance.
Examples
N/A
No specific triggering statement is documented beyond an unsupported operation on a violations/diagnostics table.
Diagnostic Checks
- Check whether the target table is a violations/diagnostics table, and use a different table if the operation requires it.
Related Errors / Related Topics
- -23858 — "This operation is not allowed on a temporary table (
)." The same class of table-kind restriction, for temporary tables rather than violations/ diagnostics tables. - -23860 — "This operation is not allowed on a duplicated table (
)." The same class of table-kind restriction, for duplicated tables rather than violations/ diagnostics tables.
The operation isn't allowed on a violations/diagnostics table — use a different table.