We are trying to get a better understanding about how Octane sequences ID’s.

In one space, we’ve added several users, and the US_ID values are jumping in increments of 1000 without any obvious trigger for moving to the next 1000. So, we have ID’s from 1001 – 1006, then 2001 – 2019, then 3001 – 3003, then 4001 – 4002, then 5001 – 5006. When we import a set of users, the ID’s are back-to-back within the same “1000” grouping. Sometimes, if we add a user later in the day, it gets added to the same “1000” grouping. Other times, a new “1000” grouping starts.

I’m used to ALM always moving sequentially, so I’m just trying to figure out why Octane is jumping to the next 1000 without using up all the values in the previous 1000. The SEQUENCES table is full of values that are all even 1000’s (see attachment). ALM always holds the value of the last ID for a particular artifact.

This is happening for all items. We imported a group of tests, and they all received sequential TS_ID values (1001 – 1068). Adding more tests over the next few days used TS_ID values 2001 – 2009 before jumping to 3001.

The users are confused about why their Test ID’s are not sequential. The gaps make it look like some tests were deleted, even though they weren’t.