Ignition Historian Query Data

Hi
I am trying to understand how historian module handles the data.
Current Version of ignition vision 8.1.17 . windows server 2019 on VM.
Data is logged into historian and then going to SQL server (separate server).

On 26dec 2022 we observed that date changed on windows OS and ignition has picked up and start logging data. on next day ignition gateway script created xml file by query historian, and it created a file with incorrect date(26dec2023) and time. it was like this till 31dec2022 and then it corrected itself.

Now if I go into trending tools and check the data for 26Dec 2023 there is nothing showing there. so somehow historian self corrected the date and time stamp...?

i have been informed now to investigate what happened that day and how can we prevent it in future.

I am trying to understand how historian handles the transactions to SQL.

Hello @mandeep_gill,

The way the Tag Historian works can be a little complex for this post, but we do however have some documentation.

How the Tag Historian System works: How the Tag Historian System Works - Ignition User Manual 8.1 - Ignition Documentation

I suggest making a support post at https://support.inductiveautomation.com/hc/en-us so we can look further into why it was able to correct itself and the data in between where the issue occurred.