In this blog post, let’s learn about the error message “25206 The system schema on node node has system schema version version1; this is incompatible with the version of the compiler. The compiler version is version2.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
25206 The system schema on node node has system schema version version1; this is incompatible with the version of the compiler. The compiler version is version2.
Reason for the Error
The affected query compilation, DDL, or utility operation need to access system schema tables with a system schema version that is incompatible with the version of the compiler that compiles the query and executes the operation. This can happen if:
The local system schema version is later than the MXV of a node that is involved in the affected query. Compilation of such a query requires a downrev compiler.
The local system schema version is higher than the schema version of a schema that is involved in a DDL or Utility operation. Execution of such an operation requires a downrev compiler.
There is a need to access the system schema on a remote uprev node, and the system schema version of that system schema is later than the current compiler version.
Solution
Downgrade the system schema on the affected node to a version that is compatible with the required compiler version
