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
In which way is it important to have no gaps?
Sequence number is very much important for business. Based on that number only they are identifying the number of records submitted and also we are showing this field everywhere.