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