Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Issue with auto increment column in ASA 16

Hi everyone,

I faced with strange behavior of auto-increment column.

It happens in ordinary table without Foreign Constraints, Triggers and etc.

Auto-increment for  id column  (numeric(10)) works as usual - add 1 to every new row.

But sometime it 'jumps' to billion. You can see it on pictures bellow:

You can see the jumps happen randomly. First was after 200 records second was after next 690.

At the moment I have 4 such jumps and I am not sure this won't happen again.

Has anybody seen something like this before?

Former Member
Not what you were looking for? View more on this topic or Ask a question