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

In this blog post, let’s learn about the error message “25200 Table or view object cannot be accessed because of a version incompatibility. Its schema has version version1; node does not support schema versions 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

25200 Table or view object cannot be accessed because of a version incompatibility. Its schema has version version1; node does not support schema versions lower 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 lower than the accessing node’s oldest supported schema version. This error can be issued from the local node or from an ESP on a remote node.

Solution

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