I’ve been trying to figure out this problem for sometime now, without any luck!
Let me try to explain:
I’m using SQL Server Express(2014) as my database.
I have several Transaction Groups that record Tag Data into a database table. I have some on Timers and some on Schedules.
They all do as expected EXCEPT for (1) group, this group is set to record every 30 minutes.
But here’s what happens: Every few days it records a NULL value instead of the actual tag data for 1 row, them everything is good again for a few days and it will happen again.
My server is on a UPS so I don’t think it’s a power problem and all of the other groups work as they should.(Ignition and SQL Server on same computer)
Does anyone have any Ideas that I might start to look at?