I am using transaction group to log data into a database. It works fine, but often logs duplicate data with same timestamp or sometime even with microseconds difference as seen in the pic attached. I try changing the target table that works for some time and again this issue repeats. I am also attaching the pictures of other settings that I used for the TG. Can somebody please help with this?
Aim of the TG: Log values whenever there is a change in one of the values of 'Comp1_switch', 'Comp2_switch','Tower1_switch','Tower2_switch' only when 'Plant switch' is ON (1).
You might check that you're not doing this in an inheritable project. I believe if you're doing it in a parent project and another project inherits it, both your parent project and the child project will execute these in duplicate.
If this is the case, I'd recommend making a separate project just for running your transaction groups so they're not replicated.
Hi,
Thanks for your comment. But, I run this in a separete project that has neither a parent nor a child. Sometimes, changing the sql table that the TG connects with, helps. But, still I am not sure that it won't start injecting duplicate values again as I have switched to a new table multiple times.