In this blog post, let’s learn about the error message “20177 Resume option of RECOVER command for Import is possible only if Import finished inserting the data in the target table. RECOVER cannot be performed.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
20177 Resume option of RECOVER command for Import is possible only if Import finished inserting the data in the target table. RECOVER cannot be performed.
Reason for the Error
The resume option is not allowed for the failed IMPORT operation because the data insertion part was not finished.
Solution
Retry the operation using the CANCEL option of the RECOVER utility