# Alerting using Database Driving Provider

**URL:** <https://forum.inductiveautomation.com/t/alerting-using-database-driving-provider/1496>\
**Category:** Ignition\
**Created:** [February 4, 2010, 4:31pm UTC](https://forum.inductiveautomation.com/t/alerting-using-database-driving-provider/1496 "2010-02-04T16:31:46Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![eliteaut](https://avatars.discourse-cdn.com/v4/letter/e/ecae2f/32.png) [@eliteaut](https://forum.inductiveautomation.com/u/eliteaut)\
**Post date:** [February 4, 2010, 4:31pm UTC](https://forum.inductiveautomation.com/t/alerting-using-database-driving-provider/1496/1 "2010-02-04T16:31:46Z")

</div>

The alerting setup info does not stay when configuring a tag in a Database Driving Provider. If you copy a tag with alerting configured from an Internal Provider to a Database Driving Provider it gets an error “unknown column hightagpath” in the sqlt\_sc table there is a column hitagpath???

---

<div class="post-metadata">

**Author:** ![Carl.Gould](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/carl.gould/32/7262_2.png) [@Carl.Gould](https://forum.inductiveautomation.com/u/Carl.Gould)\
**Post date:** [February 5, 2010, 7:19pm UTC](https://forum.inductiveautomation.com/t/alerting-using-database-driving-provider/1496/2 "2010-02-05T19:19:03Z")

</div>

Thank you for the report - we’re looking into it and will get this resolved soon.

---

<div class="post-metadata">

**Author:** ![Carl.Gould](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/carl.gould/32/7262_2.png) [@Carl.Gould](https://forum.inductiveautomation.com/u/Carl.Gould)\
**Post date:** [March 1, 2010, 8:15pm UTC](https://forum.inductiveautomation.com/t/alerting-using-database-driving-provider/1496/3 "2010-03-01T20:15:56Z")

</div>

Just as a followup, this has been fixed in the release that is currently up on the Downloads page (7.0.3)

---

<div class="post-metadata">

**Author:** ![eliteaut](https://avatars.discourse-cdn.com/v4/letter/e/ecae2f/32.png) [@eliteaut](https://forum.inductiveautomation.com/u/eliteaut)\
**Post date:** [March 5, 2010, 8:15pm UTC](https://forum.inductiveautomation.com/t/alerting-using-database-driving-provider/1496/4 "2010-03-05T20:15:47Z")

</div>

I must be doing something wrong somewhere. I am getting the same results.

---

<div class="post-metadata">

**Author:** ![Carl.Gould](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/carl.gould/32/7262_2.png) [@Carl.Gould](https://forum.inductiveautomation.com/u/Carl.Gould)\
**Post date:** [March 5, 2010, 9:16pm UTC](https://forum.inductiveautomation.com/t/alerting-using-database-driving-provider/1496/5 "2010-03-05T21:16:10Z")

</div>

I just tried exactly what you were describing (copying a tag with alerting) from an internal provider to a database provider, and it worked as expected. Can you post more details about the error message you’re seeing?

---

<div class="post-metadata">

**Author:** ![eliteaut](https://avatars.discourse-cdn.com/v4/letter/e/ecae2f/32.png) [@eliteaut](https://forum.inductiveautomation.com/u/eliteaut)\
**Post date:** [March 5, 2010, 10:02pm UTC](https://forum.inductiveautomation.com/t/alerting-using-database-driving-provider/1496/6 "2010-03-05T22:02:18Z")

</div>

When I create a new tag using the database driver the alert states that are added do not stay or changes made to the setpoints or timedelay do not stay. In the sqlt\_as table the id keeps changing.

---

<div class="post-metadata">

**Author:** ![Carl.Gould](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/carl.gould/32/7262_2.png) [@Carl.Gould](https://forum.inductiveautomation.com/u/Carl.Gould)\
**Post date:** [March 6, 2010, 12:06am UTC](https://forum.inductiveautomation.com/t/alerting-using-database-driving-provider/1496/7 "2010-03-06T00:06:13Z")

</div>

I’m sorry, which id are you talking about?

Are you still getting the error message about the “hightagpath”?

---

<div class="post-metadata">

**Author:** ![Carl.Gould](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/carl.gould/32/7262_2.png) [@Carl.Gould](https://forum.inductiveautomation.com/u/Carl.Gould)\
**Post date:** [March 8, 2010, 5:43pm UTC](https://forum.inductiveautomation.com/t/alerting-using-database-driving-provider/1496/8 "2010-03-08T17:43:22Z")

</div>

As a followup, this was explained to me over the phone, and is a problem with alert states in tags in a db-driving sqltags provider. Alert states cannot be altered after the initial tag creation. This will be fixed in 7.0.5.