In this blog post, let’s learn about the error message “25204 Table or view object1 has schema version version1; this is incompatible with the version of the compiler that compiles the query. 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
25204 Table or view object1 has schema version version1; this is incompatible with the version of the compiler that compiles the query. The compiler version is version2.
Reason for the Error
The affected query references a database object with an object schema version that is higher than the compiler version of the compiler. This can happen if a downrev compiler is explicitly being used to compile the query or module.
Solution
Do not explicitly use a downrev compiler to compile the query or module