# Quarantined Queries: Data too long

**URL:** <https://forum.inductiveautomation.com/t/quarantined-queries-data-too-long/12638>\
**Category:** Ignition\
**Created:** [February 3, 2017, 12:42pm UTC](https://forum.inductiveautomation.com/t/quarantined-queries-data-too-long/12638 "2017-02-03T12:42:39Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Sanderd17](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/sanderd17/32/8735_2.png) [@Sanderd17](https://forum.inductiveautomation.com/u/Sanderd17)\
**Post date:** [February 3, 2017, 12:42pm UTC](https://forum.inductiveautomation.com/t/quarantined-queries-data-too-long/12638/1 "2017-02-03T12:42:39Z")

</div>

There are currently 25 quarantined queries, see the error message below.

Retrying doesn’t seem to help, is there any way we can figure out what queries are being quarantined?

[attachment=0]quarantined.JPG[/attachment]

---

<div class="post-metadata">

**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\
**Post date:** [February 3, 2017, 1:08pm UTC](https://forum.inductiveautomation.com/t/quarantined-queries-data-too-long/12638/2 "2017-02-03T13:08:59Z")

</div>

Turn on query logging in your database. I vaguely recall seeing this and IA changed the column width in newer versions.  
If you aren’t on the latest version of Ignition you might just want to alter that column width manually.

---

<div class="post-metadata">

**Author:** ![anna](https://avatars.discourse-cdn.com/v4/letter/a/779978/32.png) [@anna](https://forum.inductiveautomation.com/u/anna)\
**Post date:** [February 3, 2017, 5:41pm UTC](https://forum.inductiveautomation.com/t/quarantined-queries-data-too-long/12638/3 "2017-02-03T17:41:11Z")

</div>

Sanderd17, looking at the screenshot, you have a string value being inserted into the alarm\_event\_data table’ strval’ that is longer than the column size allows. This can happen for example if there is an expression binding on one of the properties of an alarm with a fairly long expression. The fix is to change the size of the strvalue column to accommodate expression sizes (or to write shorter expressions 🙂 )

[attachment=0]img.png[/attachment]
