In this blog post, let’s learn about the error message “25268: The DOWNGRADE command cannot complete because the version of the system schema on remote_node is higher than 1200.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
25268: The DOWNGRADE command cannot complete because the version of the system schema on remote_node is higher than 1200.
Reason for the Error
The DOWNGRADE command was executed in a distributed environment where one or more affected catalogs were originally created on remote_node and where the system schema version on that node is higher than 1200.
Solution
Execute the following command on remote_node:
>> DOWNGRADE ALL METADATA TO VERSION 1200
Execute the following command on the local node:
>> RECOVER ALL METADATA RESUM