Issues with saving records in the database

Ignition
1

Dear community,

I need your help to try to understand and resolve an error that has occurred while saving records in my database. I am using Ignition 8.1 and Microsoft SQL Server v19.1.

To save the data from Ignition to the database, I used the Standard Group tool from the Transaction Groups. Tags and a Trigger were created to read the information from OPC. When the Trigger is activated, it saves the tag information into the corresponding database table.

This operation seemed to work well for a few weeks, but a few days ago, after the Trigger is activated, the tag information is not saved immediately in the database, and no error messages are displayed. After several subsequent activations of the Trigger and changing the tag information, upon refreshing the database, it can be seen that the entire set of records appears in the database.

2

That usually means the data was temporarily placed in Ignition's store and forward system while your database was bogged down or unavailable. When Ignition retried later, it was available again.

If this is undesirable, you can configure your transaction group to not use the S&F subsystem. Then you would have immediate failures on DB problems instead of eventual delivery.

That the S&F system was triggered suggests you have some other DB problem to solve.

1 Like
3

Thank you very much for the help, I will continue investigating this error.