In this blog post, let’s learn about the error message “25202 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 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
25202 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 lower 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 migration has been made without properly upgrading database objects of old schemas that are no longer supported on the new version.
Solution
Perform a fallback of the software on the affected node to a version that supports the database objects that are present on the node
