Quarantined data error " Data truncation: Data too long for column 'strvalue' at row 1"

I receive an error when some? data is Quarantined with the message:
“Data truncation: Data too long for column ‘strvalue’ at row 1”

The desctipion on the

How do I analyse and/or fix this problem?

One option is to increase the size of the DB columns - any DB frontend software (MySQL Workbench, SQL Server Management Studio, etc) should have the ability to do this.

The other option is to find whichever alarm is being fired that has a very long property (eg, notes, display path, etc) that’s logging into the journal. Exporting the data should point you in the right direction.

Hello. I have the same recurrent error.
Exporting the data (now) create a file to download in which only serialised information can be found. (ie the fired alarm causing this alarm is not huma readable in this file)

I am having the same issue…


After exporting and opening the quarantine file I find the contents are not human readable, except for the XML tags. I tried to decode the seemingly base64 encoded strings between the XML tags using notepad++ and https://www.base64decode.org/ but did not get any decipherable results.

Here is the content of the exported quarantine.xml file, can anyone provide some help on how to decode this to identify the offending alarm strings?

<?xml version="1.0"?>
<cachedata sourceStore="MySQL" creationTime="Thu Jan 10 20:23:02 MST 2019">
   <data flavor="__datasourcedata__" subtype="">
      <base64>H4sIAAAAAAAAAKVWTWwbRRSe2HHjxmlIiohUIaRFChWg2msndpI6RcG/1MSJQ2wRNQGZ8e7YnnS9
u8zOOnYOlRBHxI2/Yw8cOCBxoOKOKoTELcAJTogbolLFFQ68mV1jByolLpZs7755836++d578/kD
FHIYuqVZnRg1dVfjtEuwy60O5tQyY7RlUvnQwpwc4X4MG5h1qNmKHVouM7ERywjBq97L4uhLtZjH
HCPvMxFAkRKaJl1i8qKBW04JXZQvtb5NSihsM2oxyvtlNKnDLo5ulCEk9REhqYOQVFDowN8gIrUg
7Amf62V0SVip4YZBtnGHcHS5fIi7WDUw6FU5A3VQCuvUsXcwb7+N7qBAGUVsZjWpt8UXXXAgGW3w
FnG4xYi+wyzb4ehJz6bLqaEWTLdTJRyMXuQDr/6mSdelunzu2QKJASIAe/pM2L0ch6j/k+OHV2+v
fXNcnAsg1GNo47yGNMts0lYsix2qiTQI432Ie3hKE5BzFxsugQSfGElwC9vrPRtinheymJDFbmKn
DfLQ1E9f31946ySIAkU0bVhYL2INgIIj5m1GnLZl6D1742XpYuYoDL9z8A2Csa2xAfATyEmxpJuf
BiVOZu8rtvnnlQcyi7AGjG1ZrO9Bz9DO4/raI4axaVpH/3b37b1fc9YfV1sBNLmPwg0wLU6+jKZ1
0sSuwV/HxmniVRqHRBMcCekcaM/R/MhizsCOA2vTDu3YIwTq2RN2l6E5CbvQjHn8vfvw07Xj9S+z
ggA2RxeAuJwwmweDz9dt4HTdYnXBb/mchlS1NnHq2OwrB0DzbtoPMq1y3Epv3VSzhqXdblg9Nb6q
ZLPRVHxZzZS36rXaUr2YKZXTUGedtETgmnKGgaQwkIwnpIH93PK4BhIrnoGUbyAxdgRrnoGkl0Ih
OXYEax4GKbWep7hlWg6nmqOWHCVnmSYcItHPtlalnCg75Zxaqim7FnSz/VJCiSr5SmVXyVW2a5lc
bQwjgvGuSTWvCVb34vFE9JXCdmE3U6vsjpHakgR3KX7dP97xwU154C75Burn2LxLDNz3g85CA8bc
BTS3E/GEspVVcuVKtZAfJ4SEl8MjQ3hTufYCtJYb/6clki9O7mZcdQpKu4RCbc3Soa5DmoGPj0VR
zpbRzLDIXVmol6DTm8OiffgiE2WbOm8Ur7nYoE0KwwXqddiOAwcoZGPGoRu/dHDukXjK2OIO7Bcj
kVte58hhaAV+mNA5wq5DmFB0hGzBZb6n8cP2PP3YfOOj99599gPZmCCLwDiD7r/2ft+o/RXYvPd0
QI5jULNLuj9ZQ90B+IGelwiLCuJwNOWfjkzpGY6CsAS/MLZtKYrInjo7HGUwUkn78J2JzVv8StDr
qP79hIrrQ0hQlsitz4kBNtGObH78S6/H0ZycFnWpW/euLgj8+3cg6P+kyz1eOkq1TYwu0QGPxaFn
/+awWCWMQu7HEhfgYa8fmvrh527tuxOZeYQYpOPflyQFD1DYFwE35g9GJomwCLO6+zjjlQhIPR15
1RgUhHDrsxJdlleO2eFAEg5HF23gkB/RUGH9s/d/iy5/r34y4EXwjsgjwdFsvg+FQ7V6TlbiQPyU
wBykGcexNArw6+LeM1hdGGw6vczRzMiBADKLayt6SmvoK9HmcjIZTSYSK9HGarIRJSvXV1PxRjOZ
Wlr9G+NpxmsGCwAA</base64>
      <base64>H4sIAAAAAAAAAKVYTWwbRRSeOHHjJm1Ii6hUIYSRQgWo9u7au/ktKraTUBPnh9iiagIyk92xvel6
d9mdde0cKiGOwA0Qxx44cEDiQMWJC0IIiVuAExy5ISpVXOHAm5l17RYE9TRSbO/svHnvfe97b/e9
z+6gZBiga6bXztquFZnU7hAcUa+Nqe25Wbvp2vxHE1NyA/ey2MFB23ab2UMvClzsZAts4RVxMTd8
UV1fxRQj8TeWQNNlNEU6xKXrDm6GZXSSX9R6PimjlB/YXmDTXgVNWCBF0aUKmKT8i0lK3yQFNrTh
q2+RssbOYzpXKug0O6WGDxyyhduEorOVQ9zBioNhX5UGsB02pSw79Hcwbb2FbqJEBU37gdewhUi8
dCIEZ8z+1XRIvYBYO4HnhxQ9Ls6MqO0oa27UrhIKh56kfa2x0EQU2Rb/3fUZEn1EAPbl/4Vd+DhA
/Z6PH164vvjt0fpsAqFugC4/7EGm5zbsZraIQ9tkbpCA9sDuQZTGwOcOdiICDj425OAm9le6Pth8
hq1l2Vr2Cg5bsJ6c/Pnrb869eTyOEutoyvGwtY5NAApCTFsBCVueY3X9yy9xFadupOBzFv7H4bDN
kQGIHSjxZU632A2bhIWrXwYbf56/w71ImcDYphf0BPQB2pHVdZU4zobr3XhQ3Xe3fy15f1xoJtDE
HkodwNEs8hU0ZZEGjhz6GnbuJ972wSExGUeSFgXaU3Rm6GbJwWEI96ZCu+0PEajrj/mdAM1y2NnO
rODvrbufLB6tfFFkBPApOgHEpSTw6emvnqv7wOm6F9QZv/nvZXDVbJGwjt1eeh9o3lmOjVxWKG4u
b15Rio5nXj/wuoqupovFjKbllEJls16r1SvLkGPtZe79xfR/Cxs6E85p8zLCap4J51UpzbkFoVmV
EdbnmbCu5WWE8zkmbKhLMsIa9zmnygG2yM1WdSG8ptfXC+WRQJsX2vuma6MeYIiQaYYUcKowXwo4
VRfCmpRmQ8RbStgQZo/E8apNSXqnUlJY4Ypc2xTPsupVVdUyL69tre0Watu70u7vlfIjh94QaS6V
L7k4UxekhOOwL0rli8hUVYpwui7YKpXmek4UGDlhkeaaLgWYKKqSgC2K6mQo9VUbN10vpLYZKuUw
XfJcF55HxJKvOI8Su73SyNVGXRC+SIVAMwRnpSqtpglhOc2CdnKcVTURfLmH4qLQLFVh9QVR56Ri
beREqkmhnefZYsiVZ00VPsuZPS+qopTZOU3wW6oqaqK8SJptiPIiVxVFYsjFWZ0XKSkVqgfzOTdy
QVgSiEulpSHCJQdaTvBbribroibLPUpU8e4iVxB0TfBb7jn0wNviaGbHgI1ClF3i4F78klSEvh3T
CJ5cWxrUxM1iulTZrq6tjpJioqDJPQFySyJLRnlfuvfWV66ldz2vreyVtXQmvbq9vZsubW/VCqXa
0CFvpC8+Dz3xpUfp5cnnx7cKkTIJPWkZJVumZ0FDmjQdfHTEusmZCjo16E4j3mGerqAJd9Bt3n0h
YP2m8bBWvBphx27YxGKDlMEcIbGPkj4OaEjRi/sPPcu577C5HZBnsxzqiZa3hKGHjc2EljcVhSRg
G0O2di4KYk2jmy00/dR4/aN333nmA95RgxeJUSY0/zzv98u1vxIbt59M8DkSbPPLVjwSSnb64Ce6
wpEgwwhE0WQcHe7SUxSNwy349PzQ50vTfBgwM5jBrGJKWodvj21co+fHxSggHqzZbO6VZElDuOiz
bPIy1jLG33u626Volo856nxvXczcEOiPh3cUnSUdKngZpqst4nSIBXjMDTTHI6+5Kgls8P2I4wI8
7PaSkz/+0ql9f8w9nyYOaceDPk7BfZSKl4AbZ/aHRiDsxJUuc3D0uRBhkIo9fEbWTwimNmYlOstn
ZTODSQpTOHzTBw7FFg02rHz6/m+Z/A/Kx31ejN9kfmgUzaz2IHFss17imdhffoJhDquFMPRMG+C3
2MCuf/dcX+j+2xSdGgoIIDOnGdhsLOBGZl7TjIxuQQ1cWrBIZslSrQNjyWqoufzf6gCnIL8VAAA=</base64>
   </data>
</cachedata>

@PGriffith, are you able to provide a response to to my question regarding decoding the quarantine.xml file?

I misspoke/was misinformed when I made the original post. The issue here is that while any data can be exported from quarantine, different data types need exporters manually written to make something actually useful to you. So, the export will work, and allow you to reimport, but it’s not particularly useful until we write an editor.

That said, there really is no reason to keep the strvalue column at its default 255 characters - it’s extremely easy to overflow that. We even changed the default in 7.9.11 to create those tables with a longtext or equivalent type, depending on db flavor.