HPE NonStop SQL/MX Error – 20148 Begin key same as end key. PURGEDATA cannot be performed.

In this blog post, let’s learn about the error message “20148 Begin key same as end key. PURGEDATA 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

20148 Begin key same as end key. PURGEDATA cannot be performed.

Reason for the Error

The list of partitions specified in the key range has the same begin and end key. There are no partitions to purge.

Solution

Specify a valid key range and resubmit