HPE NonStop SQL/MX Error – 25274 Cannot DOWNGRADE metadata for the system catalog when grants to privilege groups exist.

In this blog post, let’s learn about the error message “25274 Cannot DOWNGRADE metadata for the system catalog when grants to privilege groups exist.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.

Error Message

25274 Cannot DOWNGRADE metadata for the system catalog when grants to privilege groups exist.

Reason for the Error

You specified a target version to DOWNGRADE that does not support privilege groups.

Solution

Remove group privileges on all schemas and objects, using the REVOKE statement and then retry the DOWNGRADE