In this blog post, let’s learn about the error message “20147 User specified an empty range. 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
20147 User specified an empty range. Cannot perform PURGEDATA.
Reason for the Error
The range that you specified is empty.
Solution
Verify the key range and resubmit