# Historical Transaction to table with autonumber primary key ID column

**URL:** <https://forum.inductiveautomation.com/t/historical-transaction-to-table-with-autonumber-primary-key-id-column/110534>\
**Category:** Ignition\
**Created:** [September 11, 2025, 11:14am UTC](https://forum.inductiveautomation.com/t/historical-transaction-to-table-with-autonumber-primary-key-id-column/110534 "2025-09-11T11:14:37Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![bweisenburger](https://avatars.discourse-cdn.com/v4/letter/b/c89c15/32.png) [@bweisenburger](https://forum.inductiveautomation.com/u/bweisenburger)\
**Post date:** [September 11, 2025, 11:14am UTC](https://forum.inductiveautomation.com/t/historical-transaction-to-table-with-autonumber-primary-key-id-column/110534/1 "2025-09-11T11:14:37Z")

</div>

I am not able to add records to my SQL Table. I am using a histrorical transaction and it says the transaction is running and it shows that it is writing to the table, but the table never has any more records. It has something to do with the ID field of the table. The ID field is a auto number, integer, primary key. If I duplicate the table to a test table that doesn’t have the ID field then I can add records with no problem.

---

<div class="post-metadata">

**Author:** ![Transistor](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/transistor/32/3380_2.png) [@Transistor](https://forum.inductiveautomation.com/u/Transistor)\
**Post date:** [September 11, 2025, 1:05pm UTC](https://forum.inductiveautomation.com/t/historical-transaction-to-table-with-autonumber-primary-key-id-column/110534/2 "2025-09-11T13:05:30Z")

</div>

You'll need to show us the table structure and the transaction configuration before anyone could help.

---

<div class="post-metadata">

**Author:** ![bweisenburger](https://avatars.discourse-cdn.com/v4/letter/b/c89c15/32.png) [@bweisenburger](https://forum.inductiveautomation.com/u/bweisenburger)\
**Post date:** [September 11, 2025, 1:39pm UTC](https://forum.inductiveautomation.com/t/historical-transaction-to-table-with-autonumber-primary-key-id-column/110534/3 "2025-09-11T13:39:32Z")

</div>

Just found my error. It is working fine. Thanks

---

<div class="post-metadata">

**Author:** ![Transistor](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/transistor/32/3380_2.png) [@Transistor](https://forum.inductiveautomation.com/u/Transistor)\
**Post date:** [September 11, 2025, 2:00pm UTC](https://forum.inductiveautomation.com/t/historical-transaction-to-table-with-autonumber-primary-key-id-column/110534/4 "2025-09-11T14:00:23Z")

</div>

Would it help anyone else if you shared it?

---

<div class="post-metadata">

**Author:** ![bweisenburger](https://avatars.discourse-cdn.com/v4/letter/b/c89c15/32.png) [@bweisenburger](https://forum.inductiveautomation.com/u/bweisenburger)\
**Post date:** [September 23, 2025, 11:17am UTC](https://forum.inductiveautomation.com/t/historical-transaction-to-table-with-autonumber-primary-key-id-column/110534/5 "2025-09-23T11:17:19Z")

</div>

I doubt it. My problem was I was working with a second instance of my database for testing purposes. When I saw that the Ignition group had written data, I checked my table and there was not data. What I found was I was checking the table in my first instance of my database and not the table in the database that I was using to test Ignition. Very frustrating, and a waste of my time and yours.

---

<div class="post-metadata">

**Author:** ![Transistor](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/transistor/32/3380_2.png) [@Transistor](https://forum.inductiveautomation.com/u/Transistor)\
**Post date:** [September 23, 2025, 11:19am UTC](https://forum.inductiveautomation.com/t/historical-transaction-to-table-with-autonumber-primary-key-id-column/110534/6 "2025-09-23T11:19:03Z")

</div>

We've all done stupid stuff!  
Thanks for the update.