In this blog post, let’s learn about the error message “1599 The recalibration value is greater-or-less-than-an-option value, recalibration-value,of the IDENTITY column, col-name, for the table, table-name.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
1599 The recalibration value is greater-or-less-than-an-option value, recalibration-value,of the IDENTITY column, col-name, for the table, table-name.
Reason for the Error
The specified recalibration value does not comply with these rules:
For the IDENTITY column, the recalibration value must not be less than the START WITH and MINVALUE options.
The recalibration value must not be greater than the MAXVALUE option of the IDENTITY column.
The recalibration value must not be greater than the maximum value allowed for the IDENTITY column data type.
If the statement does not contain the NO SELECT option, the recalibration value provided must be greater than the maximum value in the IDENTITY column.
Solution
Correct the recalibration value, and resubmit the statement