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
