HPE NonStop SQL/MX Error – 20820 The RCB (Record Control Block) version defined on the label does not match the RCB version defined in the metadata for Guardian file file-name of object object-name.

In this blog post, let’s learn about the error message “20820 The RCB (Record Control Block) version defined on the label does not match the RCB version defined in the metadata for Guardian file file-name of object object-name.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.

Error Message

20820 The RCB (Record Control Block) version defined on the label does not match the RCB version defined in the metadata for Guardian file file-name of object object-name.

Reason for the Error

An inconsistency was found during the VERIFY operation. The object has not been updated since the system upgrade.

Solution

Perform a SELECT COUNT (*) on the object being verified to perform a lazy update to fix the RCB version. If the problem persists after the SELECT operation, contact your service provider. mxtool fixup fixes the RCB version inconsistency when used with the “-rt” option for SQL/MX objects