Block_id not updating Correctly

I have some block Group add transactions that are not working correctly. Ignition Version 8.1.17. when it inserts a block it is not calculating the next block_id correctly. id expect it to be (select max(block_id) from table)+1

the current max block_id is 45257, yet the most recent entries are around block_id 44000. has anyone else seen this issue and found a solution? very hard to use the block_id as a unique identifier in the database when it has multiple entries from different days!

Hi Kyle,

I think it will be best to contact support so that you can demonstrate the problem on a remote session.