# Problem with alarms

**URL:** <https://forum.inductiveautomation.com/t/problem-with-alarms/5893>\
**Category:** Ignition\
**Created:** [February 19, 2013, 10:29am UTC](https://forum.inductiveautomation.com/t/problem-with-alarms/5893 "2013-02-19T10:29:05Z")\
**Posts on this page:** 9\
**Page:** 1

<div class="post-metadata">

**Author:** ![andrey](https://avatars.discourse-cdn.com/v4/letter/a/73ab20/32.png) [@andrey](https://forum.inductiveautomation.com/u/andrey)\
**Post date:** [February 19, 2013, 10:29am UTC](https://forum.inductiveautomation.com/t/problem-with-alarms/5893/1 "2013-02-19T10:29:05Z")

</div>

Hi All.

We have exported tags from our project, edited them and imported. Than we repeated those operations for a few times. Now, when alarm is appeared we see 6 alarms…

Someone can help in this matter?

---

<div class="post-metadata">

**Author:** ![gljuk](https://avatars.discourse-cdn.com/v4/letter/g/90ced4/32.png) [@gljuk](https://forum.inductiveautomation.com/u/gljuk)\
**Post date:** [February 19, 2013, 11:54am UTC](https://forum.inductiveautomation.com/t/problem-with-alarms/5893/2 "2013-02-19T11:54:13Z")

</div>

Restart Ignition Gateway. When changing alarm configuration, it is sometimes needed to restart the gateway and then it works fine.

---

<div class="post-metadata">

**Author:** ![andrey](https://avatars.discourse-cdn.com/v4/letter/a/73ab20/32.png) [@andrey](https://forum.inductiveautomation.com/u/andrey)\
**Post date:** [February 20, 2013, 12:42pm UTC](https://forum.inductiveautomation.com/t/problem-with-alarms/5893/3 "2013-02-20T12:42:55Z")

</div>

I have already done this. But no effect.

---

<div class="post-metadata">

**Author:** ![gljuk](https://avatars.discourse-cdn.com/v4/letter/g/90ced4/32.png) [@gljuk](https://forum.inductiveautomation.com/u/gljuk)\
**Post date:** [February 20, 2013, 1:35pm UTC](https://forum.inductiveautomation.com/t/problem-with-alarms/5893/4 "2013-02-20T13:35:13Z")

</div>

Then, you have many alarms defined. Look, when you are importing SQLtags with same names as existing tags, then they are not replaced, but RENAMED.

---

<div class="post-metadata">

**Author:** ![greg.simpson](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/greg.simpson/32/3135_2.png) [@greg.simpson](https://forum.inductiveautomation.com/u/greg.simpson)\
**Post date:** [February 20, 2013, 10:12pm UTC](https://forum.inductiveautomation.com/t/problem-with-alarms/5893/5 "2013-02-20T22:12:30Z")

</div>

I would probably start looking to see if you have duplicate tags. Duplicate tags with alerts configured can cause issue like this. Also, you can try to clear the alert cache and see if that corrects the issue, but I would be more inclined to think its duplicates since you have done exports and imports a few times. Look at the OPC item paths of the tags that are in an alert state, and then check the names also.

---

<div class="post-metadata">

**Author:** ![Colby.Clegg](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/colby.clegg/32/3282_2.png) [@Colby.Clegg](https://forum.inductiveautomation.com/u/Colby.Clegg)\
**Post date:** [February 21, 2013, 11:35pm UTC](https://forum.inductiveautomation.com/t/problem-with-alarms/5893/6 "2013-02-21T23:35:10Z")

</div>

To clarify a bit, we’ve seen some cases where CSV import results in multiple definitions for a tag in the internal database- but these duplicates aren’t seen in the designer.

What version of Ignition are you using? I can’t track down the exact revision, but recent versions should only load the most recent definition of a tag, effectively eliminating the problem.

However, you can try using a tool that we made to remove duplicate definitions. It can be [downloaded here](http://files.inductiveautomation.com.s3.amazonaws.com/temp/tagcleanup.zip). As it says in the readme, make sure to make a backup of your internal database first (explained there) in case anything goes wrong.

A little more information (such as where to find the .alerts file) can be found in [this thread](http://inductiveautomation.com/forum/viewtopic.php?f=70&t=9316&p=32111), that seems to describe the same problem.

Regards,

---

<div class="post-metadata">

**Author:** ![andrey](https://avatars.discourse-cdn.com/v4/letter/a/73ab20/32.png) [@andrey](https://forum.inductiveautomation.com/u/andrey)\
**Post date:** [February 22, 2013, 11:26am UTC](https://forum.inductiveautomation.com/t/problem-with-alarms/5893/7 "2013-02-22T11:26:41Z")

</div>

Hi everyone.

Thanks for help.

I want to tell how I solved this issue.

1. Open db table sql\_core and see “last tag id”.
2. Export all tags and delete them from designer.
3. Import tags.
4. Delete from db tables (sql\_core, sql\_as, sql\_meta) all rows with tag id less or equal to the “last tag id”
5. Restart ignition gateway.

---

<div class="post-metadata">

**Author:** ![Colby.Clegg](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/colby.clegg/32/3282_2.png) [@Colby.Clegg](https://forum.inductiveautomation.com/u/Colby.Clegg)\
**Post date:** [February 22, 2013, 4:29pm UTC](https://forum.inductiveautomation.com/t/problem-with-alarms/5893/8 "2013-02-22T16:29:25Z")

</div>

I’m glad you got it sorted out. Just for others who might happen onto this thread, the responses above assume that the internal tag provider is being used, but in this case (given the description of the solution), it was the external provider that was in use.

Regards,

---

<div class="post-metadata">

**Author:** ![andrey](https://avatars.discourse-cdn.com/v4/letter/a/73ab20/32.png) [@andrey](https://forum.inductiveautomation.com/u/andrey)\
**Post date:** [February 22, 2013, 5:59pm UTC](https://forum.inductiveautomation.com/t/problem-with-alarms/5893/9 "2013-02-22T17:59:42Z")

</div>

> [@Colby.Clegg](#):
>
> ... the responses above assume that the internal tag provider is being used, but in this case (given the description of the solution), it was the external provider that was in use.

Yes, you are right. We use database provider to establish connection from main server to other servers.

Best regards, Andrey.
