In this blog post, let’s learn about the error message “1628 The new MINVALUE of the sequence generator must be less than or equal to the current value current_value, and the START WITH value of the sequence generator.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
1628 The new MINVALUE of the sequence generator must be less than or equal to the current value current_value, and the START WITH value of the sequence generator.
Reason for the Error
The specified MINVALUE of the sequence generator is greater than the current_value or the START WITH value of the sequence generator.
Solution
The specified MINVALUE of the sequence generator must be less than or equal to the current_value and the START WITH value
