HPE NonStop SQL/MX Error – 20858 File file-name is located on a remote node. The current FIXUP operation cannot be performed remotely.

In this blog post, let’s learn about the error message “20858 File file-name is located on a remote node. The current FIXUP operation cannot be performed remotely.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.

Error Message

20858 File file-name is located on a remote node. The current FIXUP operation cannot be performed remotely.

Reason for the Error

You attempted to specify the FIXUP utility on a file that exists on a remote node.

Solution

Run the FIXUP utility on the remote node