In this blog post, let’s learn about the error message “1573 The START WITH value must be greater than or equal to the MINVALUE and less than or equal to the MAXVALUE for seq-name.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
1573 The START WITH value must be greater than or equal to the MINVALUE and less than or equal to the MAXVALUE for seq-name.
Reason for the Error
For the sequence or the IDENTITY column, the START WITH value is not in the MINVALUE and MAXVALUE range.
Solution
Specify the START WITH value greater than or equal to the MINVALUE and lesser than or equal to the MAXVALUE, and resubmit the statement
