In this blog post, let’s learn about the error message “1624 The RESTART WITH value should be equal to or less than the MAXVALUE 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
1624 The RESTART WITH value should be equal to or less than the MAXVALUE of the sequence generator.
Reason for the Error
The specified value for resetting the CURRENT_VALUE is greater than the MAXVALUE of the sequence generator.
Solution
Decrease the RESTART WITH value to a number lesser than or equal to MAXVALUE
