In this blog post, let’s learn about the error message “20304 RESUME cannot be used as an option for this RECOVER operation. NO actual PURGEDATA work has been done. Retry your operation with CANCEL.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
20304 RESUME cannot be used as an option for this RECOVER operation. NO actual PURGEDATA work has been done. Retry your operation with CANCEL.
Reason for the Error
You attempted to recover a failed PURGEDATA request by specifying RESUME. However, PURGEDATA has progressed too far, and only CANCEL can be specified.
Solution
Use CANCEL to retry the operation