I’ve got a bit of a quandary here.
Working on a site with a series of transaction groups for logging and pruning historical data on tanks. Effectively we have a table with the current status of all tanks in the facility that is constantly updated.
From here, there is a transaction group that runs every 10 minutes with a triggered expression that copies the “current status” table above and inserts that data into a “historical table”. Should be roughly 200 rows every 10 minutes.
We’re seeing 5-15 missing entries (an entry being 200 rows) over the course of the month, but I have no indication of what is causing the failure.
Is there a better way to execute these queries? Is this better served in a scripting block? Are there other changes we could implement to increase reliability?