In this blog post, let’s learn about the error message “25251 The operation operation involves node node which does not support schema versions lower than version.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
25251 The operation operation involves node node which does not support schema versions lower than version.
Reason for the Error
The target version of an UPGRADE or DOWNGRADE operation is lower than the oldest supported schema version of one or more nodes where an involved schema is visible.
Solution
The VERSION_INFO built-in function can be used to obtain the names and MXVs of all nodes where a schema is visible. Fallback the specified node and other involved nodes to a version that supports the target schema version. Or, specify a target version that is compatible with all involved nodes