Gaps in historian data after moving history blocks between servers

hello,

I was transferring history blocks between historian servers.  I started by copying 30 blocks, i.e. data for january 25. When viewing trend data from a tag that period looked fine.  I then continued and copied approximately half year's data more . i.e. june24 - dec 24. When looking at that data in the trend viewer it has gaps in random places.  When looking at the data in the source historian the data is complete.  So im a sure all the data is there.  I have done this before and it seems to me that these gaps happen in a random manner.  I shutdown the historian while adding each batch of blocks. Is it maybe neccessary to transfer less amount of blocks in each transfer?

I remember seeing a article regarding a problem with history gaps appearing even though the data is there, but I can't find it now.

On the screenshot, the first batch, where 30 blocks were copied (blue line 1 ) a part of the second batch of approx 150 blocks copied shown with red.  Is there a way to get rid of  these gaps?

Parents Reply
  • Some more questions:

    1. Just eyeballing the chart, it looks like the gaps and the filled portions are about the same duration and might be 24-hours each. If so, this suggests there might be something wrong with alternating history blocks (duplicates, overlapping, etc.).
    2. Does the same gap pattern align with other tags (e.g. several tags have 12-minute gaps for the same period)?
    3. Is some application/script routinely updating metadata for the tags (e.g. TrendHi/Lo, description, etc.)?
    4. If so, is there any correlation with those metadata changes? You might be able to tell using a query like this: select * from TagHistory where TagName = 'Foo'

    If none of the above leads you to a resolution, I suggest reaching out to Tech Support and include specific version information about the Historian version (old and new if this is related to an upgrade). 

Children