Sybase Error – Cannot specify range that excludes next value for sequence %1

In this blog post, you’ll learn more about the Sybase Error Cannot specify range that excludes next value for sequence %1 and the reason for receiving this error

Sybase SQL Error Message

Cannot specify range that excludes next value for sequence %1

Reason for this Error

You attempted to modify either the MINVAL or MAXVAL boundary of a sequence to a value that would make the next invocation of the nextval expression for the sequence invalid. If you want to change the range boundaries to these values, you must also specify a RESTART WITH clause and supply a value within the new range.

Leave A Reply

Your email address will not be published. Required fields are marked *

You May Also Like

In this blog post, you’ll learn more about the Sybase Error Seek failed: the requested segment offset %2 is outside...
In this blog post, you’ll learn more about the Sybase Error No indicator variable provided for NULL result and the...
In this blog post, you’ll learn more about the Sybase Error %2: Memory & disk block number mismatch; buffer={%3} page={%4}....