HPE NonStop SQL/MX Error – 20027 The specified begin key is greater than the end key for an ADD, MOVE, or DROP data request.

In this blog post, let’s learn about the error message “20027 The specified begin key is greater than the end key for an ADD, MOVE, or DROP data request.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.

Error Message

20027 The specified begin key is greater than the end key for an ADD, MOVE, or DROP data request.

Reason for the Error

You attempted to add, move, or drop data, but the beginning key range you specified is greater than the ending key range, which is not supported.

Solution

Specify a beginning key range that is less than the ending key range