In this blog post, let’s learn about the error message “25203 Table or view object cannot be accessed on node 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
25203 Table or view object cannot be accessed on node 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 database object with an object schema version that is incompatible with one or more nodes where the object (or a partition or an index of the object) resides.
This message indicates that a fallback has been made without properly removing database objects of the higher version.
Solution
Migrate the software on the affected node to a version that supports the database objects that are present on the node
