# Transaction Groups Attempting to Write to Missing Index Column

**URL:** <https://forum.inductiveautomation.com/t/transaction-groups-attempting-to-write-to-missing-index-column/41219>\
**Category:** Ignition\
**Created:** [December 4, 2020, 6:19pm UTC](https://forum.inductiveautomation.com/t/transaction-groups-attempting-to-write-to-missing-index-column/41219 "2020-12-04T18:19:42Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![SMcIntosh](https://avatars.discourse-cdn.com/v4/letter/s/a6a055/32.png) [@SMcIntosh](https://forum.inductiveautomation.com/u/SMcIntosh)\
**Post date:** [December 4, 2020, 6:19pm UTC](https://forum.inductiveautomation.com/t/transaction-groups-attempting-to-write-to-missing-index-column/41219/1 "2020-12-04T18:19:42Z")

</div>

We’ve recently upgraded to version 8.1.0. In our implementation previously, the transaction groups didn’t have “use custom index column” selected, and the tables they were writing to also didn’t contain a column with the default name. This didn’t result in any errors, and the data recorded as expected (also, the tables do have indices, but they are not a single value recorded by the transaction groups). Now, in 8.1, this is causing warnings to be logged of the format:

Columns missing from table, and ‘create table’ option is not enabled. Missing columns: [\<TABLE\_NAME\>\_ndx]

Where \<TABLE\_NAME\> is the name of the table we are attempting to write to. Is there a way to prevent the transaction groups attempting to write to a non-existent index column? It doesn’t seem to prevent the recording of data to the DB.

---

<div class="post-metadata">

**Author:** ![rrebro](https://avatars.discourse-cdn.com/v4/letter/r/3da27b/32.png) [@rrebro](https://forum.inductiveautomation.com/u/rrebro)\
**Post date:** [April 16, 2021, 5:18pm UTC](https://forum.inductiveautomation.com/t/transaction-groups-attempting-to-write-to-missing-index-column/41219/2 "2021-04-16T17:18:08Z")

</div>

Any solution to this?

---

<div class="post-metadata">

**Author:** ![cody.abbott](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/cody.abbott/32/17533_2.png) [@cody.abbott](https://forum.inductiveautomation.com/u/cody.abbott)\
**Post date:** [September 16, 2021, 9:46pm UTC](https://forum.inductiveautomation.com/t/transaction-groups-attempting-to-write-to-missing-index-column/41219/3 "2021-09-16T21:46:39Z")

</div>

I see this error as well. SQL Bridge Module 10.1.2

---

<div class="post-metadata">

**Author:** ![Alfredo\_Egmo](https://avatars.discourse-cdn.com/v4/letter/a/ccd318/32.png) [@Alfredo\_Egmo](https://forum.inductiveautomation.com/u/Alfredo_Egmo)\
**Post date:** [September 13, 2022, 6:10pm UTC](https://forum.inductiveautomation.com/t/transaction-groups-attempting-to-write-to-missing-index-column/41219/4 "2022-09-13T18:10:25Z")

</div>

Hi, No solution found for this?

---

<div class="post-metadata">

**Author:** ![pick](https://avatars.discourse-cdn.com/v4/letter/p/9de0a6/32.png) [@pick](https://forum.inductiveautomation.com/u/pick)\
**Post date:** [September 15, 2022, 2:32pm UTC](https://forum.inductiveautomation.com/t/transaction-groups-attempting-to-write-to-missing-index-column/41219/5 "2022-09-15T14:32:24Z")

</div>

this box is checked?  
 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/7/b/7bb6b546c3186d14a6f8768ff57750c0aa56899b.png)  
on this page:  
 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/7/f/7f76ba52421c3d8034bb0749698f121e77c61939.png)