In this blog post, let’s learn about the error message “25210 Schema schema has schema version version1; node does not support schema version lower than version2.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
25210 Schema schema has schema version version1; node does not support schema version lower than version2.
Reason for the Error
The affected DDL or utility operation references a database object in a schema with a schema version that is lower than the oldest supported schema version of the node where the operation is executed.
Solution
Depends on the circumstance:
If the schema is defined on remote downrev nodes only, then an upgrade of the schema should be attempted from one of those nodes.
If the schema is defined on the local node, then the schema – and all database objects in it – is inaccessible. A fallback of the local node to a software version that supports the schema’s version is required
