# Strvalue in alarm\_event\_data needs larger default datatype

**URL:** <https://forum.inductiveautomation.com/t/strvalue-in-alarm-event-data-needs-larger-default-datatype/10843>\
**Category:** Ignition\
**Created:** [December 1, 2015, 5:35am UTC](https://forum.inductiveautomation.com/t/strvalue-in-alarm-event-data-needs-larger-default-datatype/10843 "2015-12-01T05:35:37Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![iamthebull](https://avatars.discourse-cdn.com/v4/letter/i/58f4c7/32.png) [@iamthebull](https://forum.inductiveautomation.com/u/iamthebull)\
**Post date:** [December 1, 2015, 5:35am UTC](https://forum.inductiveautomation.com/t/strvalue-in-alarm-event-data-needs-larger-default-datatype/10843/1 "2015-12-01T05:35:37Z")

</div>

When multiple alarms are shelved at the same time there is an entry in the alarm journal alarm\_event\_data table that records the following value in the strvalue column:

(_path\_or\_disppath_:matches\_any [\* (…)

where \* is a list of paths for all the alarms that were shelved. In my case it only takes shelving three alarms together for the strvalue of this entry to go beyond the default 255 characters allowed in the database for this column. Thus the write to the database fails and the update query sits in the quarantine.

It is very reasonable to expect users to shelve more than one alarm simultaneously and that this could be a regular occurring problem. Rather than having to manually modify the datatype of the strvalue column in the database is it possible to adjust how this event is recorded in the alarm\_event\_data table or at least have ignition use a larger datatype when creating this table in the first place?

---

<div class="post-metadata">

**Author:** ![zxcslo](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/zxcslo/32/61610_2.png) [@zxcslo](https://forum.inductiveautomation.com/u/zxcslo)\
**Post date:** [August 5, 2018, 11:03am UTC](https://forum.inductiveautomation.com/t/strvalue-in-alarm-event-data-needs-larger-default-datatype/10843/2 "2018-08-05T11:03:55Z")

</div>

☹This is still present today. 👎
