Store and forward - old data from 2014

Ignition
,
1

I have problem where old data is popping up in database table. I think tag values are right but time stamps are way in the past. I have managed to pinpoint issue in database, table with name "sqlt_data_1_20140407". In there I can see new data showing up but with old timestamps. In the picture I cleared table before and new data is showing.
If I delete the table then store and forward QUARANTINED COUNT will rise about 35 000 in 24h. And I think that´s why ignition has been restarting after few days.

What do I need to stop this from happening?

image
image909×848 72 KB

2

Double-check your PLC clocks where you are using PLC OPC servers. They must be correct.

3

I think that was issue. Clock where indeed in 2014 era.
How did You know it was to do with OPC servers and its time?

image
image479×249 6.75 KB

4

Common problem. OPC requires accurate timestamps and Ignition trusts the timestamps from OPC servers.

If a few minutes off, this shows up in realtime trends.

It is a best practice to synchronize your PLCs with good time sources. I recommend the Time Machines TM2000B, which has both PTP and NTP support.