Historical sqltags with tags deleted and recreated

Ignition
1

We have the following issue with historical sqltags.

In our development workflow, we need to very often delete and recreate sqltags with the same full tags paths.
when tag are recreated new id are generated for historical tag definition in sqlt_te table.
So old historical data which are binded to old id are lost.

We would like when tag are recreated that old ids are reused in sqlt_te instead of creating new ids.
Is there a way to do that or to make a sync between realtime historical definition and sqlt_te table ?

2

To get started I have two questions for you:

  1. Is there a reason why the tag id has to be reused when recreating the tag?
  2. Are you manually deleting/altering any entries sqlt_te table when a tag is deleted?
3
  1. I suppose unique id for one tag path is the only way to be able to query all tag history from easy chart
  2. No

It’s seem that id are not recreated for the same tag path, when tag are deleted and recreated if the history db is well connected during these action.

perhaps the case occur when history db is disconnected when tag are deleted ? or when tag are recreated ?

4

I feel like you shouldn’t be having this issue. If the tag is being recreated with the exact same path in the same historical provider on the same machine then the system should still see and return the old historical data from before you deleted and recreated. I have seen on rare occasions the old tagid still used to store data after it’s been retired , but in that scenario you don’t see any new data.

What version of Ignition are you currently running?

5

7.7.3 or7.7.4
We will test more closely as soon as possible. I will keep you posted if we reproduce the issue and the test workflow