Is the block_id from a block transaction group always unique? Or are there certain things I could have done which would have caused it to reset to 1? For instance, does modifying a group and then saving it cause the block_id to reset? What about changing the group name?
Here is my situation. I have a block transaction group which writes to table_staging in the database. Then I have a job on the SQL server that does some calculations and modifications, verifies these new rows have not already been moved, and moves that data to table_final and deletes the rows from table_staging.
Yesterday afternoon, it stopped moving the data to table_final, and it turns out that it is because the block_ids already exist there, so it thought they would be duplicated. I can go through and fix the data this time, but I need to know if it is going to reset the block_id again so I can stop assuming that is going to be unique.