In this blog post, let’s learn about the error message “25106 A query running on node-1 cannot use ESPs on node-2.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
25106 A query running on node-1 cannot use ESPs on node-2.
Reason for the Error
The query plan places ESPs on a node that runs on a higher version of SQL/MX than the local node.
Solution
If the local node is running on SQL/MX R3.3: Set CQD REMOTE_ESP_ALLOCATION to OFF, then recompile the query. If the local system is running SQL/MX R3.4 or higher: Recompile the query
