SQL table data be insert twice with same data on Transaction Group

Ignition
1

image
image1621×716 196 KB

Hi, we're experiencing a strange issue with the Transaction Group. We have set the trigger to [active on value change], but we've noticed that the data is being inserted into our table twice.
like my screenshot, the runid should only 1 rows, but in table there are 2 datas had same runid and start_date

We have already checked, and there are no duplicate Transaction Groups. This issue occurs sporadically, not consistently.
And, when this issue starts occurring, it tends to affect data for the next two to three hours. During this period, the duplicate inserts are more frequent

We are using a redundant tag gateway -could this be the cause? (Client and Master is switching)
Or should we further investigate how [value change] functions?

2

Have you tried changing Tags to watch for change: to a single tag instead of All tags?
If some of the tags change at different times that could cause multiple triggers. Try changing it to trigger on the runid only.

2 Likes
3

I believe this is the right direction! Thank you for the suggestion.
Additionally, setting a primary key (PK) in SQL is also a solution, even though it isn't the source of the issue.

4

In my opinion, all database tables should have a primary key.

2 Likes