In this blog post, let’s learn about the error message “20190 Data in the last partition (or subset) cannot be moved to the next partition because no next partition exists.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
20190 Data in the last partition (or subset) cannot be moved to the next partition because no next partition exists.
Reason for the Error
You tried to move data in the last partition to a nonexisting next partition.
Solution
Remove the TO NEXT PARTITION phrase and resubmit