# Stale SQL Tags

**URL:** <https://forum.inductiveautomation.com/t/stale-sql-tags/2005>\
**Category:** Ignition\
**Created:** [July 5, 2010, 5:20pm UTC](https://forum.inductiveautomation.com/t/stale-sql-tags/2005 "2010-07-05T17:20:41Z")\
**Posts on this page:** 10\
**Page:** 1

<div class="post-metadata">

**Author:** ![david\_mccutchen](https://avatars.discourse-cdn.com/v4/letter/d/919ad9/32.png) [@david\_mccutchen](https://forum.inductiveautomation.com/u/david_mccutchen)\
**Post date:** [July 5, 2010, 5:20pm UTC](https://forum.inductiveautomation.com/t/stale-sql-tags/2005/1 "2010-07-05T17:20:41Z")

</div>

Periodically I have some of my SQL tags go stale. When they go stale they never go back to good quality unless you change the scan class. You can then change back to the original scan class and all is good until the next time.  
Please help.

---

<div class="post-metadata">

**Author:** ![Travis.Cox](https://avatars.discourse-cdn.com/v4/letter/t/b9bd4f/32.png) [@Travis.Cox](https://forum.inductiveautomation.com/u/Travis.Cox)\
**Post date:** [July 6, 2010, 3:14pm UTC](https://forum.inductiveautomation.com/t/stale-sql-tags/2005/2 "2010-07-06T15:14:37Z")

</div>

What version of Ignition do you have?

---

<div class="post-metadata">

**Author:** ![david\_mccutchen](https://avatars.discourse-cdn.com/v4/letter/d/919ad9/32.png) [@david\_mccutchen](https://forum.inductiveautomation.com/u/david_mccutchen)\
**Post date:** [July 9, 2010, 4:28pm UTC](https://forum.inductiveautomation.com/t/stale-sql-tags/2005/3 "2010-07-09T16:28:26Z")

</div>

Version 7.1.2 running on Linux

---

<div class="post-metadata">

**Author:** ![Travis.Cox](https://avatars.discourse-cdn.com/v4/letter/t/b9bd4f/32.png) [@Travis.Cox](https://forum.inductiveautomation.com/u/Travis.Cox)\
**Post date:** [July 9, 2010, 4:41pm UTC](https://forum.inductiveautomation.com/t/stale-sql-tags/2005/4 "2010-07-09T16:41:42Z")

</div>

We have made some changes to Ignition regarding stale values so you may want to upgrade to 7.1.3 that is on the website to see if that fixes your problem.

---

<div class="post-metadata">

**Author:** ![david\_mccutchen](https://avatars.discourse-cdn.com/v4/letter/d/919ad9/32.png) [@david\_mccutchen](https://forum.inductiveautomation.com/u/david_mccutchen)\
**Post date:** [July 9, 2010, 11:30pm UTC](https://forum.inductiveautomation.com/t/stale-sql-tags/2005/5 "2010-07-09T23:30:37Z")

</div>

Today we upgraded to 7.1.3. The tags are not going stale now, but they are not updating either. This seems to be confined to several tags that are referenced to and are triggers for alarms. I think this may be an issue with the OPC-UA server. The tags show good data but when compared with our identical fpmi application running kepserver the tags and values don’t match.

---

<div class="post-metadata">

**Author:** ![david\_mccutchen](https://avatars.discourse-cdn.com/v4/letter/d/919ad9/32.png) [@david\_mccutchen](https://forum.inductiveautomation.com/u/david_mccutchen)\
**Post date:** [July 12, 2010, 2:37pm UTC](https://forum.inductiveautomation.com/t/stale-sql-tags/2005/6 "2010-07-12T14:37:32Z")

</div>

Something has changed with the way SQL tags are handled. I dug a little deeper and found it takes forever to initialize the tags. What’s going on? The stale tag handling needs to be corrected because now it is misleading. 1 other thing I noticed sql tags cannot be edited, deleted, or added for about an hour after the gateway is started. Read timeout error.

---

<div class="post-metadata">

**Author:** ![Kevin.Herron](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/kevin.herron/32/7259_2.png) [@Kevin.Herron](https://forum.inductiveautomation.com/u/Kevin.Herron)\
**Post date:** [July 12, 2010, 3:50pm UTC](https://forum.inductiveautomation.com/t/stale-sql-tags/2005/7 "2010-07-12T15:50:40Z")

</div>

What kind of device are these tags from? Do you have time to call into support and do a GoToMeeting today?

---

<div class="post-metadata">

**Author:** ![david\_mccutchen](https://avatars.discourse-cdn.com/v4/letter/d/919ad9/32.png) [@david\_mccutchen](https://forum.inductiveautomation.com/u/david_mccutchen)\
**Post date:** [July 12, 2010, 4:10pm UTC](https://forum.inductiveautomation.com/t/stale-sql-tags/2005/8 "2010-07-12T16:10:13Z")

</div>

Yes, I’ll give you a call in a bit

---

<div class="post-metadata">

**Author:** ![david\_mccutchen](https://avatars.discourse-cdn.com/v4/letter/d/919ad9/32.png) [@david\_mccutchen](https://forum.inductiveautomation.com/u/david_mccutchen)\
**Post date:** [July 14, 2010, 9:46pm UTC](https://forum.inductiveautomation.com/t/stale-sql-tags/2005/9 "2010-07-14T21:46:28Z")

</div>

This problem went away when our FPMI application was taken offline and only Ignition was running by itself.

---

<div class="post-metadata">

**Author:** ![david\_mccutchen](https://avatars.discourse-cdn.com/v4/letter/d/919ad9/32.png) [@david\_mccutchen](https://forum.inductiveautomation.com/u/david_mccutchen)\
**Post date:** [July 23, 2010, 6:36pm UTC](https://forum.inductiveautomation.com/t/stale-sql-tags/2005/10 "2010-07-23T18:36:17Z")

</div>

This problem came back several days later. It seemed to be confined to one device. After consulting with the IA guys, it was determined that there may be some latency with this one device. The stale threshold for the OPC-UA server was adjusted from 3 to 5 to compensate.
