[BUG] String or binary data would be truncated

[gdiazderadaa]

System info:

• Umbraco 7.15.2
• uSync v4.0.15
• uSync.ContentEdition v4.1.9
• uSync.ContentMappers v4.1.8
• uSync.Core v6.0.15

Issue description: Getting the message

Error: An error has occurred. - String or binary data would be truncated. The statement has been terminated.

when trying to import a full export done in another environment. Tried several times with the same result.

Stack trace: uSync_exception.txt

[KevinJump]

Hi,

I would need a bit more info, but i am guessing there is a property on a document type, that has been changed from one type to another (maybe a string to a rich text or even a checkbox or something to text.

in Umbraco 7 - changing the underling datatype of an datatype property via the API isn't reliable so its likely it is still trying to save the data to the older state :(

the value inside the content item is now longer than that orginal datatype.

if you turn logging up on uSync (see below) you might be able to identify the offending property. and altering it via the Umbraco UI might also fix the value type.

to up logging add the following to your log4net.config file

  <logger name="Jumoo.uSync">
    <level value="DEBUG" />
  </logger>

[gdiazderadaa]

Hi Kevin, thanks for this, I'll give it a go and will let you know.

On a side note, I was wondering if it's possible to have usync configured to only handle umbraco changes and let snapshots to manage content.

Thanks!