HPE NonStop SQL/MX Error – 20861 The corrupt bit has been reset for only local partitions of file-name. Please execute the command on the remote nodes to update respective remote partitions.

In this blog post, let’s learn about the error message “20861 The corrupt bit has been reset for only local partitions of file-name. Please execute the command on the remote nodes to update respective remote partitions.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.

Error Message

20861 The corrupt bit has been reset for only local partitions of file-name. Please execute the command on the remote nodes to update respective remote partitions.

Reason for the Error

This message is displayed whenever FIXUP is used with the “-rc” option on a table or index with partitions on a remote node.

Solution

Clear the corrupt bit on each remote node by issuing the FIXUP command with the ‘-rc” option