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
-> did somebody delete the other DB entries?-> got the unique key counter somehow setted to 1009?
I am the one who is working on this and I am sure no one deleted the data and also not touched IDENTITY column setting.
is this a unique key?
it is a IDENTITY column.