HPE NonStop SQL/MX Error – 25312 A version version1 compiler is required to compile the query. The current compiler version is version2.

In this blog post, let’s learn about the error message “25312 A version version1 compiler is required to compile the query. The current 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

25312 A version version1 compiler is required to compile the query. The current compiler version is version2.

Reason for the Error

The query affects one or more nodes with an MXV lower than the current compiler version.

Solution

Explicitly use a compiler of the specified version