HPE NonStop SQL/MX Error – 20033 The partition must be empty before you drop it.

In this blog post, let’s learn about the error message “20033 The partition must be empty before you drop it.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.

Error Message

20033 The partition must be empty before you drop it.

Reason for the Error

You attempted to drop a nonemtpy range partition.

Solution

Make sure that the range partition is empty before dropping it