I have around 8 transaction groups running. All groups log data into MYSQL using a trigger and for each database entry a timestamp is generated. Timestamp does not come from Ignition, but from MYSQL. Also, I have a serial number generated by MYSQL for each entry.
I am having issue with two of the groups in storing data. The trigger becomes active, database storage is triggered, I see an entry made in the database with a serial number and timestamp which tells me trigger works fine. The other fields in DB populated by OPC tags remain blank.
Also, when I do not run the client and just monitor values in my designer for the OPC tags, they are updated real-time.
I do not understand as to why no data is written into MYSQL.