HPE NonStop SQL/MX Error – 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.

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