Hi Team,
I am using Appian with backend SQL Server database.
I have observed that the IDENTITY column value of a table where I am storing data is skipping number sequence all of sudden. If you observe in my below attached screen, it started showing 1009 after 24.
I was unable to trace the root cause of the issue.
Can someone advice on this please. Thanks.
Discussion posts and replies are publicly visible
Looks like the AUTO_INCREMENT value got set to something higher at some point - like if a new entry for some reason had its PK ID manually set to "1009" before being added. I'd guess you will need to manually fix the errant entries (if safe to do so) then manually set the AUTO_INCREMENT value back to the next-higher ID.
ALTER TABLE `TABLE_NAME` auto_increment = 35;
that was my Idea, but does't explain why it happend in the first place. mysterious