# Block\_id not updating Correctly

**URL:** <https://forum.inductiveautomation.com/t/block-id-not-updating-correctly/62929>\
**Category:** Ignition\
**Tags:** database\
**Created:** [August 11, 2022, 5:48pm UTC](https://forum.inductiveautomation.com/t/block-id-not-updating-correctly/62929 "2022-08-11T17:48:02Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Kyle\_Nussdorfer](https://avatars.discourse-cdn.com/v4/letter/k/7bcc69/32.png) [@Kyle\_Nussdorfer](https://forum.inductiveautomation.com/u/Kyle_Nussdorfer)\
**Post date:** [August 11, 2022, 5:48pm UTC](https://forum.inductiveautomation.com/t/block-id-not-updating-correctly/62929/1 "2022-08-11T17:48:02Z")

</div>

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!

---

<div class="post-metadata">

**Author:** ![apalas](https://avatars.discourse-cdn.com/v4/letter/a/e47774/32.png) [@apalas](https://forum.inductiveautomation.com/u/apalas)\
**Post date:** [September 2, 2022, 7:58pm UTC](https://forum.inductiveautomation.com/t/block-id-not-updating-correctly/62929/2 "2022-09-02T19:58:00Z")

</div>

Hi Kyle,

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

[https://support.inductiveautomation.com/hc/en-us](https://support.inductiveautomation.com/hc/en-us)