HPE NonStop SQL/MX Error – 20181 Begin key is greater than end key. PURGEDATA cannot be performed.

In this blog post, let’s learn about the error message “20181 Begin key is greater than 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

20181 Begin key is greater than end key. PURGEDATA cannot be performed.

Reason for the Error

The list of partitions specified in the key range specified an invalid range. There are no partitions to purge.

Solution

Specify a valid key range and resubmit