When the delet older records option is selected for my historical transaction group, the entire table seems to be deleted instead of trimming the records older then the selected time. Is this the correct behavior or do I have something misconfigured?
That is not the expected behavior. It must be something with your configuration. Can you call our tech support or post a backup of that transaction group?
I was not trying to do any thing fancy. And I should clarify, the table itself was not being deleted but all the records would be deleted. I would have expected the table to consistantly hav ~ 120 entris since I am deleting after 3 minutes.
demo_2012-04-27_1602_partial.proj (3.83 KB)
What kind of database are you using? While I’ve never seen this particular issue, sometimes time-based operations run into trouble because of different database data types/behaviors. Also, in addition to the type of database, perhaps you could take a look at the table definition using the appropriate tool and let us know what the timestamp column is defined as. Hopefully we can mock it up and track down what’s going on.
I think I may have figured this out. I am using a MySQL (t_stamp was datetime) database but it is installed on a separate machine from Ignition. The problem I believe was that the two computers times were not synced ~2 ahead on the database computer. I noticed this when I set the option to delete older than 10 min and saw the behavior I was expecting. Thanks for the guidance.
Ah, yeah. Unfortunately we do the date arithmetic on the Ignition machine, to avoid complications with different databases, which means that this system is susceptible to problems with time synchronization.
Anyhow, glad you figured it out.