Why is sa_reset_identity throwing an error?

[MCMartin]

executing

call sa_reset_identity('tablename')

throws the error:

ERROR [HY000] [Sybase][ODBC Driver][SQL Anywhere]RAISERROR executed: invalid new_identity value

The used table has only one autoincrement column. If a new start value is explicitly provided it works.

Any idea, what's the problem with the default usage?

[VolkerBarth]

So what's the current max_identity of that particular table according to the system catalog?

[MCMartin]

it says 930

[VolkerBarth]

Hm, that doesn't look "difficult". Does get_identity() work as expected?

[MCMartin]

yes that works

[chris_keating · Accepted solution]

The new_identity value is not optional as currently implemented. The default should likely be 1 and not NULL as currently defined.

To workaround, please supply all parameters or include new_identity as in the following example:

call sa_reset_identity('tablename', new_identity=1 );

[VolkerBarth · Accepted solution]

I tried to add a comment in DCX but the login failed (before I was asked fro credentials). Is that a pitfall of the new SAP Universal ID process?

Website returns: "SAML response has errors. Please check the logs". Guess I don't have permissions to do that 🙂

[chris_keating · Accepted solution]

I have made a fix for this issue which will be available in 17.0 Build 6254 or newer. The fix will change the default to 0 making the next identity value 1. Further, only non-negative non-NULL values will be permitted.