Oninit
Talk to an expert →

Informix Error -23517: CM error: Cannot drop or alter a system defined cogroup.

Cause and resolution

CM error: Cannot drop or alter a system defined cogroup.

A request to drop cogroup_all fails because cogroup_all cannot be dropped.

Avoid requests to drop cogroup_all.

Oninit® Troubleshooting Guidance

Reasons / Common Causes

-23517 fires when a request tries to drop cogroup_all — per the official guidance, this system-defined cogroup can't be dropped.

  1. A request to drop cogroup_all, per the official guidance — the direct, only cause.
Solutions / Resolution
  1. Avoid requests to drop cogroup_all, per the official guidance.
Examples
N/A

No specific triggering statement is documented beyond attempting to drop cogroup_all.

Diagnostic Checks
  1. Check whether the targeted cogroup is cogroup_all, and target a different cogroup if that's the intent.
Related Errors / Related Topics
  • -23515 — "CM error: Cogroup already exists." A related cogroup-management error, on a name collision rather than the system-defined cogroup restriction.

cogroup_all (the system-defined cogroup) can't be dropped or altered.