In this blog post, let’s learn about the error message “25252 The operation operation involves node node which does not support schema versions higher than version.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
25252 The operation operation involves node node which does not support schema versions higher than version.
Reason for the Error
The target version of an UPGRADE or DOWNGRADE operation is higher than the MXV 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. Migrate the specified node(s) 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