# Data truncation: Data too long for column 'ACTION\_VALUE'

**URL:** <https://forum.inductiveautomation.com/t/data-truncation-data-too-long-for-column-action-value/9292>\
**Category:** Ignition\
**Created:** [November 5, 2014, 11:26am UTC](https://forum.inductiveautomation.com/t/data-truncation-data-too-long-for-column-action-value/9292 "2014-11-05T11:26:36Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![fran.alija](https://avatars.discourse-cdn.com/v4/letter/f/ea5d25/32.png) [@fran.alija](https://forum.inductiveautomation.com/u/fran.alija)\
**Post date:** [November 5, 2014, 11:26am UTC](https://forum.inductiveautomation.com/t/data-truncation-data-too-long-for-column-action-value/9292/1 "2014-11-05T11:26:36Z")

</div>

Hello,

Working with Ignition 7.7.1, anytime a UDT is modified and saved the console throws this error:  
  
12:02:39 DatasourceAuditProfile  
Error auditing [DefaultAuditRecord[action=“tag edit”, actionTarget="[default]_types_/Array/Array", actionValue=“ComplexTagDiff[new members={}, modified members={bc58b895-def0-46b1-8120-099804358789=TagDiff[modified={Name=Power DC specific, EventScripts=TagEventScriptsDiff[modified={}, removed=[]], ExtendedProperties=PropertySetDiff[modified={},removed=[]], AlarmConfiguration=AlarmConfigDiff[modified={Low Production=AlarmDefinitionDiff[modified={},removed=[]], No production=AlarmDefinitionDiff[modified={},removed=[]]}, removed=[]]},removed=[]]}, removed members=[], modified overrides={}] Super ComplexTagDiff[modified={ExtendedProperties=PropertySetDiff[modified={},removed=[]]},removed=[]]”, actor=“fran.alija”, actorHost=“franalija-lapt”, context=“2”, system=“project=Cellino\_dev”, status=“AuditStatus[0x00000000, Severity=Good, Subcode=NotSpecified]”, timestamp=“Wed Nov 05 12:02:41 CET 2014”]], due to underlying exception  
com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column ‘ACTION\_VALUE’ at row 1  
   
It throws this error when saving any UDT. Even very simple test UDTs without any instance. Also after these errors the system becomes pretty unstable and reports Clock Drift warnings.

Is there any configuration we may change or any action we may do to avoid this?.

Thanks.  
Fran.

---

<div class="post-metadata">

**Author:** ![JordanCClark](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/jordancclark/32/83362_2.png) [@JordanCClark](https://forum.inductiveautomation.com/u/JordanCClark)\
**Post date:** [November 5, 2014, 2:49pm UTC](https://forum.inductiveautomation.com/t/data-truncation-data-too-long-for-column-action-value/9292/2 "2014-11-05T14:49:21Z")

</div>

Well, looking at the actionValue it’s trying to use:

```auto
actionValue="ComplexTagDiff[new members={}, modified members={bc58b895-def0-46b1-8120-099804358789=TagDiff[modified={Name=Power DC specific, EventScripts=TagEventScriptsDiff[modified={}, removed=[]], ExtendedProperties=PropertySetDiff[modified={},removed=[]], AlarmConfiguration=AlarmConfigDiff[modified={Low Production=AlarmDefinitionDiff[modified={},removed=[]], No production=AlarmDefinitionDiff[modified={},removed=[]]}, removed=[]]},removed=[]]}, removed members=[], modified overrides={}] Super ComplexTagDiff[modified={ExtendedProperties=PropertySetDiff[modified={},removed=[]]},removed=[]]"
```

The length is 597 characters. You’ll need to set your column size in the audit table appropriately.

---

<div class="post-metadata">

**Author:** ![fran.alija](https://avatars.discourse-cdn.com/v4/letter/f/ea5d25/32.png) [@fran.alija](https://forum.inductiveautomation.com/u/fran.alija)\
**Post date:** [November 12, 2014, 9:22am UTC](https://forum.inductiveautomation.com/t/data-truncation-data-too-long-for-column-action-value/9292/3 "2014-11-12T09:22:58Z")

</div>

Thanks, you leaded us in the right direction. Since Tag Event Scripts can be very long we decided to stop auditing during development and activate it back when the system passes to production, because even 4096 charts was not enough.

Fran.