In this blog post, let’s learn about the error message “20146 Key does not exist. Cannot perform PURGEDATA.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
20146 Key does not exist. Cannot perform PURGEDATA.
Reason for the Error
The key value you specified in the partition map clause does not specify a valid partition.
Solution
Specify a valid partition map and resubmit