Data truncation: Data too long for column 'ACTION_VALUE'

Ignition
1

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.

2

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

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.

3

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.