I have a transaction group which is triggered by a combination of two Boolean tags. When MAC_TO_SQL_DATA_READY is true and SQL_TO_MAC_DATA_RECEIVED is false, an expression item becomes true and the transaction runs. It writes a record to the database based on several other OPC tags. Then it has two triggered expressions, one of which is a SQL query and the other a SQL insert.
I have selected the option to write a handshake on success, which would set the SQL_TO_MAC_DATA_RECEIVED tag to true. This never works. I thought that maybe the problem was that the SQL query item was returning NULL, which in turn causes the SQL insert to insert no records, even though the status does not show a failed execution… This is still something that would be considered success from an operational standpoint, but I can see how it might mean that the transaction as a whole is considered a failure. So I checked the option to write the same handshake on failure as well, and it still never writes.
I’m sure there’s just something wrong with how I’ve set up the transaction, but I’m stumped. I’m attaching the transaction as an xml export.
Thanks,
Dan