HPE NonStop SQL/MX Error – 25201 Table or view object cannot be accessed because of a version incompatibility. Its schema has version version1; node does not support schema versions higher than version2.

In this blog post, let’s learn about the error message “25201 Table or view object cannot be accessed because of a version incompatibility. Its schema has version version1; node does not support schema versions higher than version2.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.

Error Message

25201 Table or view object cannot be accessed because of a version incompatibility. Its schema has version version1; node does not support schema versions higher than version2.

Reason for the Error

An attempt is made to access a table or view in a schema with a schema version that is higher than the accessing node’s MXV. This error can be issued from the local node or from an ESP on a remote node.

Solution

Downgrade the affected schema to a version that is compatible with the MXV of the nodes that need to access the schema