In this blog post, let’s learn about the error message “1629 The MAXVALUE of the sequence generator must be greater 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
1629 The MAXVALUE of the sequence generator must be greater than or equal to the current value current_value, and the START WITH value of the sequence generator.
Reason for the Error
The specified MAXVALUE for the sequence generator is less than the current_value or the START WITH value of the sequence generator.
Solution
Specify a MAXVALUE greater than the current_value or the START WITH value of the sequence generator
