HPE NonStop SQL/MX Error – 20189 Data in the primary partition (or subset) cannot be moved to the previous partition because no previous partition exists.

In this blog post, let’s learn about the error message “20189 Data in the primary partition (or subset) cannot be moved to the previous partition because no previous partition exists.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.

Error Message

20189 Data in the primary partition (or subset) cannot be moved to the previous partition because no previous partition exists.

Reason for the Error

You tried to move data in the first partition to a nonexisting previous partition.

Solution

Remove the TO PREVIOUS PARTITION phrase and resubmit