# Alert Distribution Group Setup

**URL:** <https://forum.inductiveautomation.com/t/alert-distribution-group-setup/3119>\
**Category:** Ignition\
**Created:** [July 21, 2011, 11:25pm UTC](https://forum.inductiveautomation.com/t/alert-distribution-group-setup/3119 "2011-07-21T23:25:55Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![rooks](https://avatars.discourse-cdn.com/v4/letter/r/ce7236/32.png) [@rooks](https://forum.inductiveautomation.com/u/rooks)\
**Post date:** [July 21, 2011, 11:25pm UTC](https://forum.inductiveautomation.com/t/alert-distribution-group-setup/3119/1 "2011-07-21T23:25:55Z")

</div>

Can someone give me a step by step setup procedure to generate a window that allows operators/users to add or remove themselves from an “On Call” alert distribution list? On call operators need to receive text message alerts. I am already using the Administration Window from the IA Demo Project. I would like to incorporate the above mentioned functionality into this window.

---

<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 21, 2011, 11:40pm UTC](https://forum.inductiveautomation.com/t/alert-distribution-group-setup/3119/2 "2011-07-21T23:40:53Z")

</div>

I can do one better. Here is a completed window to add/edit/delete distribution lists and contacts. You can alter the window to fit your needs.

[AlarmDistributionLists.vwin](https://us1.discourse-cdn.com/inductiveautomation/original/1X/561c37e3d398a770a73514e7842b20a1dd438bfc.vwin) (27.4 KB)

---

<div class="post-metadata">

**Author:** ![Duffanator](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/duffanator/32/3560_2.png) [@Duffanator](https://forum.inductiveautomation.com/u/Duffanator)\
**Post date:** [July 22, 2011, 12:46pm UTC](https://forum.inductiveautomation.com/t/alert-distribution-group-setup/3119/3 "2011-07-22T12:46:10Z")

</div>

That’s an awesome screen but I ran into a problem with it. When you try and save a new group it comes up with an error that it can’t add it into the data base because of a Null value:

fpmi.db.runPrepStmt(“INSERT INTO %s (%s\_ndx, name, expression) VALUES (NULL,?,?)”

Seems like it’s a Microsoft SQL thing though:

Traceback (innermost last):

File “event:actionPerformed”, line 13, in ?

java.lang.Exception: Error executing system.db.runPrepStmt(INSERT INTO alert\_distro\_groups (alert\_distro\_groups\_ndx, name, expression) VALUES (NULL,?,?), , [Kill\_Floor, {[SEVERITY]} = 4 && {[GROUP\_NAME]} LIKE ‘Kill Floor Alarms’])

Caused by: com.inductiveautomation.ignition.client.gateway\_interface.GatewayException: Gateway Error 301: SQL error for “INSERT INTO alert\_distro\_groups (alert\_distro\_groups\_ndx, name, expression) VALUES (NULL,?,?)”: DEFAULT or NULL are not allowed as explicit identity values.

Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: DEFAULT or NULL are not allowed as explicit identity values.

It also seems like the ‘Items’ section of the Reference Property button needs to be updated, it seems like some of those properties either don’t exist or the names changed? FYI.

---

<div class="post-metadata">

**Author:** ![rooks](https://avatars.discourse-cdn.com/v4/letter/r/ce7236/32.png) [@rooks](https://forum.inductiveautomation.com/u/rooks)\
**Post date:** [July 22, 2011, 2:18pm UTC](https://forum.inductiveautomation.com/t/alert-distribution-group-setup/3119/4 "2011-07-22T14:18:11Z")

</div>

That is just what I needed. Thanks Travis!

---

<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 22, 2011, 3:40pm UTC](https://forum.inductiveautomation.com/t/alert-distribution-group-setup/3119/5 "2011-07-22T15:40:20Z")

</div>

To fix that error just remove the ndx column from the insert query.

---

<div class="post-metadata">

**Author:** ![Duffanator](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/duffanator/32/3560_2.png) [@Duffanator](https://forum.inductiveautomation.com/u/Duffanator)\
**Post date:** [July 24, 2011, 4:54pm UTC](https://forum.inductiveautomation.com/t/alert-distribution-group-setup/3119/6 "2011-07-24T16:54:35Z")

</div>

That did indeed fix it, thanks!