In this blog post, let’s learn about the error message “1037 SQL/MX is not installed on system node.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
1037 SQL/MX is not installed on system node.
Reason for the Error
In a replication or distribution context: An operation attempted to create a catalog reference or a partition on a node where NonStop SQL/MX has not been installed.
Solution
Either reissue the statement specifying a different node, or install NonStop SQL/MX on node and resubmit