Corrupt Tag in Historian.

Hi,

I have a corrupt tag in Historian, with the following errror message in the Log viewer

Retrieval failed to create data source tagname GARH_NDF10CF201.XQ01 range 2024/01/13: 12:59:55.000 --> <INFINITY>  , error = 241 (Tag has too many versions) [SCADASERVER2; AsyncDataCacheHolderFactory.h; 130]

when i look in historian, the tag is listed there but the data is "null"

I have tried deleting a instance and creating a new one with same name and same attribute to historize, is there a way to completely purge this tag out of database? want to get rid of this error from the log

  • Hi Jakob,

    That Error 241 (Tag has too many versions) comes from Tags that are reconfigured to often. Each time a Tag configuration is changed (EUmin/max is mofidied for example) a new set of this configuration is saved in the Historian. If those changes run into the several thousands at some point there is an overrun.

    There are several queries to solve this problem, so I recommend that you consult technical support (softwaresupportsp.aveva.com) so that they can provide you with these queries and guide you in solving the problem.

  • Hi Ruben, thank you. I have a active support subscription. So i will seek support there. I found an support article 000011738 -  from 2015 that touches on the topic. 

    PDF

    I thought maybe, undeploying the instance/io attribute from the galaxy, and then deleting the tag from the historian server , through the SMC would be something that is possible.  Is there no option to delete a tag there? 

    anyways thank you. Will contact support.

  • It may depend on the version of Historian is use, but there is a utility (at least includes Historian 2020 R2 and later ) available from Tech Support that can consolidate the "tag versions" that Ruben described above. After using the utility, you should be able to query the data normally. You can reference HF 2138814 when contacting Support.

    If you don't care about the data, it is also possible to delete the offending tag, but that can be a little tricky: it is easy to delete it from the SMC (or OCMC in newer releases), but unless it was an IDAS tag, it was probably created by an external source (e.g. AppServer, SDK, etc.) and that source will usually just recreate it. You can disable the historization in the source, but will need to go through some extra steps to clear cached IDs in the source to prevent "resurrecting" the same tag and ID. All of that makes it a little more work to truly delete data, but does make a whole lot easier to recover when you accidentally delete it.