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