Transaction Group executes twice, even though OPC value changes once

Ignition
1

Hi,

I have a Transaction Group which executes twice, even though the trigger is set to a OPC value which only changed once. This results in a duplicate insert in the database

Here is what I already did :

  • Transaction Group Execution Scheduling (1s): I increased to 2s instead of 1s but not better
  • Tag Group Rate (1s): I reduced to 500ms instead of 1s but not better
  • the device itself: simulator, OPC, no visible duplicate change on the value/timestamp/quality

Now I'm suspecting something with the Latched/Source values :
is source value changing before execution/insert of the latched value ?

  • Is there a way to configure the latch time ?
  • Is there a way to force the trigger to execute once only ?
  • Any other idea to fix this issue please ?

For info, I'm using the following :
- Ignition 8.1.26 + MySQL8.0.22
- the template project "oee_downtime" in this exchange resource "Perspective Equipment Schedule" Ignition Exchange | Inductive Automation

Thanks in advance

trigger tab + Transaction Group Items
trigger tab + Transaction Group Items1139×543 73 KB

action tab
action tab345×563 24.7 KB

SQL duplicate inserts

2

Just to cover the bases...

Any project inheritance going on?
Any chance someone took a gateway backup or project export and restored it on their own system?

1 Like
3

Or, are there two transaction groups pointing to the same table?

1 Like
4

Indeed it was a project backup conflicting with the same transaction groups. That was basic.
Thanks @PGriffith and @JordanCClark !

3 Likes