HPE NonStop SQL/MX Error – 1570 The MAXVALUE for the sequence generator must be greater than the MINVALUE for seq-name.

Data 29 Views 1 Min Read

In this blog post, let’s learn about the error message “1570 The MAXVALUE for the sequence generator must be greater than the MINVALUE 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

1570 The MAXVALUE for the sequence generator must be greater than the MINVALUE for seq-name.

Reason for the Error

For the sequence or IDENTITY column, the MAXVALUE specified is less than the MINVALUE.

Solution

Specify the MAXVALUE greater than the MINVALUE, and resubmit the statement

Tags: