I am having problems trying to send setup information to multiple PLCs using a Standard Transaction Group reading data from a database view. I have multiple OPC items associated to the same database field, and each of these items is connected to a different PLC (some using Igntion UA OPC, others using RSLinx).
When I specify the part number of a triggered transaction using a custom where clause, the values are retrieved from the database BUT only the FIRST OPC item associated to the field is actually updated, the rest associated to the same field keep their value. This seems to happen for every field, only the first instance is updated.
The transaction is triggered with a boolean SQLTag that is set after the PartNumber SQLTag is changed. The triggered expression items are used to send constant values to OPC items within the transaction.
The PLCs are SLCs 505 and one MicroLogix 1500 using NET-ENI. The PLC communication is okay, since I am able to write directly to the OPC tag, but the transaction is only updating OPC item attached to the first field reference.
Any idea of what is going on?
I am using Ignition 7.6.2 with MS SQL Server 2008.