In this blog post, let’s learn about the error message “20758 Partition name is offline.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
20758 Partition name is offline.
Reason for the Error
VERIFY discovered that the table being verified has a partition that is offline. This is a partition that is currently part of an active MODIFY request or a failed MODIFY request.
Solution
If a MODIFY operation is currently in progress, this error can be ignored. If a MODIFY operation is not in progress, the offline partition needs to be recovered. Determine which MODIFY operation did not complete, and perform a RECOVER operation, and then resubmit